I am using Access ’97 on a shared network environment.  On one of my forms I
have a combo box (based on an Employee table) where users can select their
name.  I’d like to enhance this by having their name auto-populate that combo
box when they update one of my other toggle ...

Have been having a devil of a time, trying to get the syntax correct.  Not
having much luck.  I have the following:
Main form: Test
Subform: test1

I have 5 queries that have [Start Date] and [End Date] parameters in them.
I want to make several different forms that can fire up a variety of
combinations of these queries so I can't hard code the queries' criteria
parameters to be [formsname].[controlname].

I have this code which works perfectly to print the reports but I want to
preview them:
Private Sub cmdBkAgtReports_Click()
Dim intItem As Integer

When using bound object frame in form bound to OLE object field in table I
used to be able to insert a JPG image of  a wild flower and have the flower
displayed in the frame.  Since the computer was worked on to remove a virus,
the bound object frame displays only an icon of the ...

There are three command buttons and a combo box in a form.
Here is the code in the first button:
       On Error GoTo TrataErro
       Dim sql As String

Hi Thanks in advance.
I have problem that a laptop keep going to sleep (Or Hibernation) approx
every 20 mins.
I have no access to security so can't change the settings.

I have created a text field (CUSTOMERS) which has its Display Control
Property set to a Combo Box and The Row Source Type set to Value List.
When users in my database want to add a new customer they select the button
to add more values to the list. (I have the Limit To List ...

I have mainForm with two subforms, linked to the main by ClientID. The
subForm1 is datasheet-view (Orders), while subForm2 is single-view and its
recordsets (Order details) relevant to the subForm1 rows (it gives more
detailed/differently queried look on each row-recordset).

most of the time when i write a code and attaced it to a command i will be
receiving this error message:You can reference a property or method for a
control unless you the control  has a focus
pls how can I set a focus for a control

Currently, I am using the following code to execute a stored
procedure.  How can I support the use of RETURN values from a stored
procedure to use as a basis for user feedback?  Do I just send another
parameter?

My form has a command button that runs:
Private Sub cmdClearList_Click()
   Dim SQL As String
   SQL = "DELETE tblCatalog_Temp.* " & _

I have a form containing a subform. The subform lists payments. I need to
display on the main form a total of the payments in the subform. The current
controlsource is working except when the subform is empty (no payments exist)
it displays #Error. How should this be done? Also, ...

I was after a code that gets me the IP Address of the current machine and
found a link to the following source code previously referred by Graham R
Seach to someone called Lee and worked for him;
http://www.source-code.biz/snippets/vbasic/8.htm

I have a Form with a Subform.  The subform is invisible except in certain
situations when I need to make it show on my main form.  When the subform
appears, I really need to take a field value off the main form and have it
displayed on the subform.  I have assigned this field ...