I searched for answer and found "Me!FirstControlName.SetFocus"...but not sure
how to use and if it actually can solve my problem.
Not sure what "first control name" means -- is that the first field in the
form?

i have done this before but i cant recall, how do i enter todays date in a
date field by clicking a command button or even have the date already on the
field when the form opens, would this require me to go back to the table or
can i do this from the form.

I am trying to open a form in "Datasheet view" using a command button but if
i use the wizard, the form opens to "form View", i have tried looking at
various possabilities with no luck.
Can i do this ? can someone help me please ?

sIR
I wanted to refresh controls which i have built... making lock property of
controls to true, when user escape records half filled before saving in form.
so that when he re enters a fresh from first record, it enables control to

I was trying add some fields to my form and I must of hit something wrong
because now none of my information will transfer over to my form or report
from the table. I am very confused and in need of help.
Thanks

I am trying to make a find box in Form Design so I can search for records
without having to go the the Edit-Find process on the Access tool bar.  My
combo box wizard does not have the third choice "Find a recond on my form
based on athe value I selected in my combo box" that I am ...

I have this in the 'Connect' column in 'MSysObjects':
Description=MyDb;DRIVER=SQL Server;SERVER=MyServer;APP=Microsoft Data Access
Components;WSID=MYSERVER;DATABASE=MyDb
..an all I want to do is to change the server name.

I work in tourism. We have a form that we collect every month from
guesthouses that has a list of all nationalities and then columns for the
lenght of stay. It looks like this:
Country   1Day   2Day   3Day   4ormore   Total

I have a form to enter help desk calls. We have one field with start time and
one with end time. Then we have a field to calculate the number of minutes
spent on each call. That field is called "Minutes".
In my monthly report,  we detail the month's calls. Then we want a total of ...

I have this code I got of the internet to import files from a floppy disk.
I also have a need to import e-mailed files which I save to a folder I
created.  When I try to import from the directory nothing happens, no files
are imported.  It works finne when I import from a floppy. ...

In a search form I have code that builds a select statement using a query
taking values from form controls as parameters and then adding a few more
criteria generated by passing other values in controls through specialized
sub routines. The code then sets the record source of a ...

I have a question concerning to open the reports.
I know that DoCmd.OpenReport is a obsolete form of opening the reports, but
how to implement opening reports in VB using another VB code?
I mean also OpenForm, OpenQuery etc.

How do you preform a search on a form and display results in subform

A particular application has been in use for 6 years, with this issue coming
up rarely on a form.  I have seen it occassionally on another client's app.
Suddenly it is happening on a particular subform while adding a new record.
The message you will recognize without typingit all ...

I have a form that show it's Form Header & Footer sections (not Page
Header/Footer!).
However, when I open the form, the focus always goes to the first control in
de details section.