Access 2002.
Hi.  I am an experienced programmer in C, but rather new to Access
programming.  I suppose the question I am about to ask has been asked
and answered before, but I have not been able to find it just by

  I got the following error msg while i try to disable a control from a
different form's close event.
      "error '2164' can't disable a control while it has the focus"
Here is a part of the code:

Is there a way for me to set up a "window" in a form into which I can load
(and, ideally, un-load) pre-existing Excel workbooks? Essentially, I'm going
to use the FileSystemObject to read all the files available in a given
folder, and the users will pick from a list box.

When I run the code below it gives me the error that Method or Data Member
not found.  I have compared the "frmExpenseReport" and they appear to be the
same as the "frmPurchaseOrder" as far as properties, etc.  I added the
stDocName = "frmPurchaseOrder" because when the drop down ...

Using Access 2003:
My main form has a tab control on the bottom and on a particular tab is
a subform.  On this particular subform is a field is a date.  I want to
reference that field so that I can use it in formulas on other tabs and

I have Start_Date and End_Date text boxes in a report.  These needs to be
changed based on where clause passed from a form to run this report.  Please
advise how can these be changed/filled based on user selected dates from the
code in the form.

I have a problem, I want to use the beforeupdate event of a combobox to
cancel
an action (using a simple msgbox warning in the event), but it doesn't seem
to work.

I am running Access97. The application has a number of combo boxes for
setting report criteria. They are Cbo_1 and Cbo_2. If I sellect or set a date
in Cbo_1 as the starting date, I'd like to have to Cbo_2 be set or default to
one day or date earlier, then, I'd like for that date ...

I have a User Defined function in SQL SErver that returns a single value.
I cannot figure out how to reference it in each of the following
circumstances:
in an IF THEN ELSE construct in VBA code

Hi. I have the following code in the 'Before Update Event' of combo
cboSchoolName. The message appears OK if I try to select a value in
cboSchoolName before selecting one in cboPlacementStage but after clicking on
OK, the user is still then able to select  a value in ...

I have a command button in a form that initiates email and I have coded the
email addresses I want it to use, problem is there are so many that the text
is too long and wraps onto the next line except now I get a syntax error and
I have forgotten what sign to use when you want to ...

I am using FrontPage 2003 and want to insert a watermark backgound which is  
smaller than the web page which results in an unattractive tiling.  Is it
possible to create a smaller graphic without it tiling?

I have a problem with combo box based on query that catches values from two
tables. One of the columns is ID which value I need from combo box in order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to ...

I've just moved from Access 2000 to Access 2003 and have come across an
annoying little problem in the Visual Basic editing environment.
If I am typing a line of code and stop before the end of the line the cursor
comes back to the last character and the line turns red as there is ...

Hi! I wan't to merge records from a table to the microsoft outlook. The
result is one draft for each table record that contains the email address.
Each record as also a subject and text that it will be post in each email
draft.