I have two unbound combo boxes that are based on the 'look up a record' combo
wizard.
When the form opens they both query the same underlying table and offer up
two criteria for the underlying form query to display a set of records on

I have a text field that stores numbers that may occassionally have letters
after them.  I need to be able to sort this field as if it is a number field
even though it holds text.  Unfortunately, that is not something I have an
option to change, but I have to find a way to work ...

I'm having trouble copying a child record to a new parent.
All fields are copying properly, EXCEPT the combo box field that is bound to
column 2 in the child record.
The other combo box fields that are in the child record are copying fine,

How does one clear all of the fields when entering a form?  I have two forms
(one query and one data entry) and the user does not want to see the previous
results.
I attempted to use the forms on open and on load events to set the field to

i have a table with the following fields autonumber mnumber ,fname,
lname, etc. i need to find the last number entered in the table and
add 1 to it. I tried using dmax mnumber +1 but it finds the higest
value in mnumber and then adds 1 to it every time the user submits the

Help.  I have a labor tracking database that I'm ready to roll out today and
I have one last error to correct.
I have a field for operators to enter their employee ID into.  This will be
done with a bar code reader that also sends CR/LF to move to the next field.  

I'd like to show multiple times in the database but can not figure out how to
do this.
I've tried =(Time()+8)
Looked through the help menu and searched this discussion group without

Hi,
Ok here's the scenario........I have data going back to Jan/06 but when I
run a query based on date submitted with no criteria attached my query only
reports as far back as Jan/07.  How do I get around this or more importantly

Here is an interesting one I am struggling with!
I have a frm Projects_Main on which I have cboProjectMgrID. The SQL is
as follows:
SELECT Company_Contacts.CompanyContactID, Company_Contacts.CompanyID,

Bear with me, I am very new to access...
I have a contributor table and a donations table. I also have a form for each.
On the contributors form I have displayed a child form generated from the
donation table which shows the donations that contributor has made.  I would

On my forms I have a checkbox with code to lock record and do certain
things on the form via code by using Tag on fields and such.
I also have a check box on one form that I use to enabel or disable a
field. Is there a way to use more than one tag on a single field such

I would like to use OnEnter to place the check in a check box and then be
able to tab to the next feild on my form but I currently have the Keyboard
option to go to a new record OnEnter. Is there a way to do both? Any other
ways to go about it?

Hi All, i have a partnumber search that returns several "like" part numbers.
if i enter "1533" it returns all parts starting with this. This is the
desired result.
However The result is being returned in a form, with the first occurence

Table 1 Name:  Bank
Table 2 Name:  Ledger
1 Main form with 4 subforms (only having problem with 2 subforms)
1st Subform:  UnMatch1 (query based on Ledger)

I've just made a frame contain some toggle buttons.
Everything works properly except one thing.My toggle button
keep pressed after I click it.How to make it not pressed after we click it?