Access event procedure using docmd.openform to launch a form. i want it to
start out in datasheet view and set the form default. however, the form opens
in single form view.
how do i change that to datasheet view?

Using Office 2003 and Windows XP.
Here is my configuration:
Split DB; users have FE stored on their local C drives; BE is password
protected and stored on a network. User security is NOT being used; instead

New to Access....
How can I create a parameter in a query, such as a date range to pull data
back in that range or if the parameters are null to pull all records?
Any help would be appreciated.  Thanks.

I am getting an invalid SQL error when I run this. I would like capture the
Computer name and compare it to the result of a query to determine if the
user is in a group that needs buttons visible or hidden.
Private Sub Form_Load()

I have just upgraded an Access 97 DB to 2007. In the DB I have a main form
that creates a subform in VBA when a selection is made in a combo box. This
form is used by our data entry personal. I have the subform set to
automatically jump to the next field when an answer is ...

My if stmt is not in the correct syntax and I've tried rst.Carrier; Carrier
and the following. It always empty and I know there is a record in the table.
   Dim db As DAO.Database
   Dim rst As DAO.Recordset

Using Access2003 and Word2003 I face the following challenge.
I do use the outstanding mailmerge program of Albert Kallal to create letters.
Within my template I have defined some "ask" boxes to complete the letter
with referencenumbers and so on.

I have a continuous form displaying data, it has the fields SpecID and
ReviewDate populated and the rest of the information is entered by a user. If
an activity lasts more than one day, I want the record details to copy to the
next date for as long as the activity lasts. ie if an ...

I'm using Access 2003 and I have several users that use an shortcut to an mde
that's on a server.
I'm having a problem with users leaving the mde open all the time. These
users have read only permission so I don't have to worry about lose of data.

Using Office 2003 and Windows XP.
Apart from creating a macro to run a form hidden, is there any other way to
accomplish this? I don't see a Visible property for the form...unless I just
missed it...?

I have a SQl query that should pull data from an Access database only
the recordsets that havew the specified 'startDate' in the Date Field.
At the moment an error pops up that says 'type mismatch'
Please note that the field 'Date' is set to "text"(i know!..but it has

I have a SQl query that should pull data from an Access database only
the recordsets that havew the specified 'startDate' in the Date Field.
At the moment an error pops up that says 'type mismatch'
Please note that the field 'Date' is set to "text"(i know!..but it has

I am having issues getting a sql statement w/ a date parameter to work from
ADO connecting to an oracle DB.  I am putting the date in the oracle date
format (dd-mmm-yy) and it doesn’t seem to be working.  I have tried several
things including: to_date oracle function, formatting ...

I am new to using SQL server as the backend for my database and I am looking
form some help on a DAO add record procedure.  I use this procedure allot on
Access DBs but now I have inherited an Access project and need a little help.
I am trying to use the following procedure to add a ...

Using Access 2003 on Windows XP.
I have the example code from Microsoft that closes the DB if the user goes
idle for some specified period of time and this functions well. But, I would
also like to display a message that tells the user that the DB is going to