|
Filtering a report issues
Okay this code will work. However I need to add code so that it will
accept 3 more strings from 3 more fields txtStartDate, txtEndDate, and
txtNumber. Two of the fields need to be dates and filter on a field
called DateEntered. The other field needs to take the number entered
and filter for results >= than the CountofPolicy field.
Can somebody please help?
Also is there some way I c...
|
2 |
12.09.2006 04:13:23 |
|
|
Background Style
When using the Form Wizard you can choose various background styles. Is it
possible to get to these styles to modidfy an existing form?
CurtainMary...
|
3 |
12.09.2006 03:52:01 |
|
|
New York state interrogatories
I'm looking for Plaintiff's response to interrogatories, format to work online ...
|
2 |
12.09.2006 02:36:36 |
|
|
Limitations to How Many Users can use the same form at the same ti
Good Afternoon Everyone,
I have a question in relation to Limitations for a Database. We are working
on a new project that involves about 300 people using the same Standard
Created Form to populate information in an Access Database all at the same
time, is this possible or would it better to use something else?
Any suggestions or information would be greatly appreciated...
Thank you...
|
3 |
11.09.2006 23:16:50 |
|
|
Controlling a value of one edit box based on another in a dynamic form
Basically I have a dynamic form with several date fields. One of which
is a "finish date". All of these fields have a control source of a
field from a table. When the value of the finish date is anything but
blank, meaning it has an actual finish date, I want to set the value of
another edit box to a value of "Closed". If there is no finish date I
want it to have a value of "Open".
I h...
|
4 |
11.09.2006 21:54:11 |
|
|
Need Access ad placement (print, broadcast) by size/run/vendor
...
|
2 |
11.09.2006 21:46:06 |
|
|
Most recent date function
I have a main form that populates tblCUSTOMER with many different
customers.
That form has a subform that populates tblHISTORY tracking the
purchases of each individual customer by date. Both tables are linked
by AUTO ID.
I want to run a query that pulls only the most recent entry from
tblHISTORY for a particular set of customers.
Any assistance is much appreciated
JC
...
|
3 |
11.09.2006 20:44:01 |
|
|
From Listbox1 to listbox2
I have two listboxes on Form1. Listbox1 and Listbox2. Listbox1 is
base on a table on names. Listbox2 is base on a blank table. How
can I use a command button to copy names from list1 to list2.
Floyd
...
|
2 |
11.09.2006 20:31:24 |
|
|
Does anyone have a registration form for an event?
...
|
2 |
11.09.2006 19:04:31 |
|
|
Requery - three level form
Main form has a Combobox which is behaving the way I expect it to. (Finally
<g>). The Combobox deals with Product_Family which is the name of a table and
also the text field in that table. The ID field is Product_ID.
Each Product Family may not necessarily relate to every Company in the
Company table, so the Company Table (shich has its own sub-form on the main
form) has a Product...
|
1 |
11.09.2006 18:52:02 |
|
|
Access Parameter Queries
Hi,
I have designed dialog boxes which allow the user to enter a specific
critera for data they are searching for only problem is that when the
user clicks on the OK button it opens up the query how can I change it
so that the results from the selected criteria are displayed in a
report??
Fie
...
|
3 |
11.09.2006 18:00:16 |
|
|
START / RUN Command - VBA to execute a DTF file
Hi
I have a DTF file which I execute through the Start/Run and then I paste a
pathname in.
Is it possible to do this through code.
I suppose what I am asking for is, is it possible to simulate through code,
the START/RUN action from the Windows desktop?
Kind Regards
Ricky
...
|
2 |
11.09.2006 17:58:01 |
|
|
Filter/Dependent Combo box problem...
I am trying to get this code to work and it won't work if I select
values in the dependent combo boxes based on queries. Please help.
Private Sub cmdFilter_Click()
'Purpose: Build up the criteria string form the non-blank search
boxes, and apply to the form's Filter.
'Notes: 1. We tack " AND " on the end of each condition so you
can easily add more search boxes; _
...
|
1 |
11.09.2006 17:25:23 |
|
|
Subform to pull data from main form
I have a main form that holds general data about each customer. That has its
own table. Then there are several tabbed sub-forms hanging off this, each
containing various specific details. Each of these sub-forms has its own
table.
I want the customer name and ref to pull through from the main form onto
each sub-form so that you can always see which record you're in. (And maybe
some othe...
|
2 |
11.09.2006 17:09:47 |
|
|
Combo boxes in form
Hi
I have a form named Client containing the information of the Client
and attached to it is a subform Parent which has information about
Client's parent. In the client form, i put a combo box for Client ID
and when i select a Client ID and go to the subform to enter or edit
information about parent, it gives me an error.
"The changes you requested to the tables were not successful beca...
|
3 |
11.09.2006 16:46:45 |
|
|
Default value on form and report after update
Hi all,
I have a subform with many number feilds, like over 20 of them. What I
would like to do is have any of the fields that are left blank, no data
entered, to have the words "ND" (not done) entered automatically. I
print out a report of this data when I finish entering the some of the
fields, so I need the data "ND" for the blank fields to be on the
printed report as well. Can this be ...
|
4 |
11.09.2006 16:42:27 |
|
|
Dependent combo boxes and filtering a report by a form...
can anyone tell me what is wrong with this code
See the trick is i have dependent combo boxes and I need to be able to
leave one blank to filter as well. The fiter works with the code below
but not if I leave the DeptName combo blank which is dependent on RC
name with its query... I have no idea how to fix it. I would like the
option of leaving it blank.
Code:
--------------------------...
|
1 |
11.09.2006 16:40:44 |
|
|
Lock / Unlock only one field on form
Hello,
I have a form with only one field that needs to be locked, but with the
option to edit if necessary. The problem arises when users are maneuvering
thru database and don't pay attention to where they are and this particular
field, which is the first entry field on form, sometimes gets deleted. I
want to lock this field when it's not a new record and have a command button
they hav...
|
3 |
11.09.2006 16:29:09 |
|
|
Creating a series of folders if none exists.
I have a form that displays records for sale units. On that form there
is a button that, when clicked, opens a folder (e.g. 07-19) that
contains four related subfolders (e.g. Documents, Pictures, Maps,
Miscellaneous). The user can then open the tools related to that sales
record from the form. The hierarchy for these folders is
FY07>07-19>Documents.
I have coded the button to edit th...
|
2 |
11.09.2006 16:28:33 |
|
|
Error in simple query when I use variable
Please see below query when I use any digit instead of X it works but X is
not working:
Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,
DetailPicknote.DDate, DetailPicknote.DetailID FROM DetailPicknote WHERE
DetailPicknote.DetailID = x")...
|
2 |
11.09.2006 16:02:08 |
|
|
transactions in date order
wonder if anyone can help me - i have a sub-form which lists all details of
licences held by various customers - each licence has an identifying number
which it keeps throughout the life of the licence, however these licences are
renewed every 3 years and can be amended at any time. As a result i can have
a number of records with the same licence number although the status may vary
- th...
|
3 |
11.09.2006 15:51:01 |
|
|
Linking list box to combo box
I have a subform which is a many-to-many relationship. The subform contains
only two things - a combo box (containing products) and a multiple select
list box containing information related to that product.
The product, selected by a unbound combo box in the header, is linked so
that the product in the main and subform show information only for that
product. However when I select muliti...
|
1 |
11.09.2006 15:25:02 |
|
|
3rd Party Tools
I am looking for some good 3rd Party Tools to create MS Access forms. I
thought I would get some other opnions. Does anyone out there use 3rd
party Tools to create forms.
I nomally create my own forms but I was asked to do some research on
the 3rd party tools.
Thanks for any assistance you can give me.
...
|
2 |
11.09.2006 14:32:05 |
|
|
Sizing grip
I would like to add a sizing grip to certain resizable forms in my access
application (at least the sizing grip on the bottom right corner of the form
so that the user can see that the form is resizable). Any suggestions as to
how to do it using only VBA coding would be highly appreciated. I wonder if
an API would be appropriate to do it, but I have very little experience on
that subjec...
|
1 |
11.09.2006 14:01:01 |
|
|
ON Open error
I have an Access application, one of the forms is giving an error when I try
to open it. This occurs on one PC, but on another one it works OK.
The error I get is
The expression ON OPEN you entered as the event setting produced the
following error: Member already exists in an object from which this object
module derives.
Both PC's are running Windows XP and Access 2003.
The applica...
|
2 |
11.09.2006 14:00:02 |