I would like to find the position of a record on a form
according to how the records are sorted on the form.
So, For example, I have Three records
ID  FruitType

I want to find and goto a record on a form based on a set
of criteria.
Like if I do a dlookup to find record and get its ID,  
goto that record.

Hi I have a date input mask and I get an error message
saying that the format is wrong if for example one number
is left out of the year etc..
please could you tell me how to trap this error to

Hi I am using the following code to try and validate my
form before quitting the application.
I require cbocycle, cbometer, cbosite & txtreading to all
be filled in if the db is quit so the record is only

I have the table with a field of DATE type.
I want to sort the table based on the DATE field in a way
that records with the same value of the DATE field are
sorted by the TIME portion of the DATE field.

How do you change the caption of the mainform, when the subform is dirty.
Like [Register] -> [Register (changed)]
I have tried severel methods, but none is working.
/Lars

I am using a DoCmd.open form command with an opening argument.  how do i set
it so that i can use multiple open arguments. for example, i want the
dateofvisit, and SSN to be teh open args because they are both primary keys.
i would also like to use lastname as an openarg if it is ...

How do I modify the docmd OpenReport  ,,,, so that it
opens the printer dialog box? I want to be able to select
the printer that I print a report to. Currently I am
using the following code and get no dialog box.

I have a simple form with one of the field defined
as autonumber(Field1) in the table design.I am wandering if it is possible
to adjust behevior of that field
in a manner that I can enter a value in that field

I am using MS ACCESS 2003.
I placed MS Progress Bar Control 6.0 over the form.
When event is fired, progress bar has to be working. When another event is
fired,

Access 2000 SP8, Jet40, Windows 2000 Pro SP3
Hi there. Another problem I run into, has to do with the DoCmd.RunCommand
acCmdSaveRecord, after calling an API function.
I have a form that holds the properties of my report fields, in order to set

In a previous post (which I can't find) I had asked a question about time
being displayed in only minutes and seconds.  There was a response about
using the Format command, however I am having problems getting that to work
Mytime = Format(Hour([StartTime])*60 + Minute([StartTime]) ...

I use the following code to open a recordset.
Set rs2 = db.OpenRecordset("tbl2", dbOpenDynaset)
Users are receiving the following error upon execution of this code.
The Error states "Function is not available in expressions in table-level

I have several forms with a lot of check boxes on it. Each checkbox
represents a form that will print out if its corresponding check box is
checked. instead of writing an if...then statement for each checkbox i would
rather write code that will automatically check all checkbox ...

Hi there! Using A02 on XP and loving the newsgroups!!! I'm
having a problem with occasional lockups on a few shared
DB's. Have dozens of users and about 6 DB's that are used
frequently by many. DB's are frontends and tables are all