I have tried to place "Me.OrderBy = [Fieldname]" in a Form_Open event, but it
seems to be ignored.  Is it not possible to establish the order of records in
the recordsource behind a form in code this way?
I know you can set the Order By form property in the form itself, but I want ...

Hello all.  I have a form in which is only used to add or update records.  A
field on the table and field in the form is for keeping track of all updates
of each record at the record level.  I am using the following coding to do
so.  The table field is called ...

Hello I wonder if any one can help me.
ms access 2000, pro win xp home
I use a form in datasheet view to enter dates of death, ages of death and
date of birth.

I have a form that has to be filled out. One of the fields in the form
relates to shipping and specifies who the freight company would be for a
specific order. There will be a limited number of freight companies, but the
llist may change and new freight companies may be added. ...

Hi. I'm using the following code on the OnCurrent of the form
to return the number of rows being returned in my continuous form:
In the General section of the module:
Dim frm As Form

This has been bugging me for ages and it's probably right in front of me.
Form Header:
A series of unbound controls, some of which source info from tblPersonInfo
Form Detail:

I am getting this error 94 in my Dmax but cannot understand why, If I remove
the criteria, everything is working well. The strPa value changes on regular
basis but for my testing I assign it a perm value and stil lget the same
error

I have Access 2003
I have one form that uses a combo to find a record. When I use the combo,
the record fills in and a new blank row is shown below, ready for the next
lookup.

I have been using the following code to prompt a message when data in a text
box changes to a particular value.
If Me.TheTextBox = "Particular Value" Then
MsgBox "Out Of Specification"

I'm tying to get a handle on the forms collection.  If I have 5 forms in my
application, why don't I get a message box for each of the forms in my
application using the code below?  Currently, I'm only gettng the name of the
form where this handler exists and none of the other ...

I have unbound form with 5 combo boxes bound to quries.
All the quries have parameters, which the parameters are name of controls in
the form
Sometimes when i close the form, and another form is being activated (it was

good day all,
I have my db set up to open to my main "switchboard" when I open my db. I
was wondering if there was a way to open the db in design mode (maybe with a
password) so that I could easily make behind the scenes modifications...

I am trying to use the following code in a textbox
if asc(key) = 3 then
me.seltext = chr(13)
return true

while testing the Janus Gridex Control Gridex2000 within Access 2003 (works
smoothly) I was testing an unbound form a là "master/detail" fashion.
That is I was wondering what is the fastest way to retreive data and fill in
master & detail data, also questioning how Access does the ...

good day all...
  I have an invoices form that I am using the following controls, however,
if the controls have no data, the control shows #Error... is there a way to
prevent this?