I am using the code shown as an example in the help files and when run, it
cannot locate the file.
Dim dbsProjects As Database
Set dbsProjects = OpenDatabase("Projects.mdb")

I would like to loop thru all of the forms in a current project (whether the
forms are open, loaded or not) (and change the background color of the formm
header to a public constant.)
It seems as though the "forms" collection only accesses those that are open.

Help on this method leaves one or two questions unanswered.  Firstly, does
the transfer append the source data to the target table or is the latter
overwritten?  Is there a choice?  (I can't see one in the syntax.)  Secondly,
if the target table does not exist, will the method ...

my app starts an instance of Word in an Acc97 form. So far I have
complete control over Word, except in the circumstance that Word has
other "windows" (including dialogs like the printing dialog) open.
Searching the web I found no reliable way to get Word's status in case

Hello together,
I got this wonderful code from the internet to relink all tables from
a backend database in the same folder.
Unfortunatelly its not working: The code gets me the right folder (see

Is there a way to manipulate the textbox class so that I can set the
backcolor of every textbox on a form to a value when a textbox has the focus,
and a different value when a textbox does not have the focus?
I've done this in VB.NET by creating a custom textbox class that ...

In a control on one of my forms, if a user tries to enter values that
already exist in the data table (duplicates) , I have a messagebox
appear telling them the record already exists.  My problem is
thereafter, I want Access to return to the original values that were

Link child fields
Link master fields
I'm use this code to link master form and sub form
Me.subclient.LinkMasterFields = "Text6"

I get "Run-time error '3141'
The SELECT statement includes a reserved word or an argument name, that is
misspelled or missing or the punctuation is incorrect.
I get this error when clicking the Select button on a Main Form, after the

I have found a perfect Stephen Lebans code and dll to stop the mouse scroll
function on forms (http://www.lebans.com/mousewheelonoff.htm), but it don't
work with the touchpad scroll.
Any solution there?

I have a frame called "fram_approv_notapprov."  Within this frame are two
option buttons.  The first option button is approved which = 1.  The second
option button is notapproved which =2.  
I then have a text box for a date, called approv_notapprov_dt.  Once either

I have a frame on a subform called fram_srpm_rom.  Within this frame there
are two options.  srpm, which when selected =1.  rom, which when selected =2.
Now on this subform there are other text boxes, check boxes and command
buttons that I would like to not be available in srpm is ...

I'm using an unbound field and cmd button to lookup records in the "Search
for Student Form".  I'm using this code on the click event of the command
button to find the record:
DoCmd.ApplyFilter , "[LastName]= '" & txtLastName & "'"

To save a lengthy reinvention of the wheel, does anyone have a program to
convert a VB form into an access form please.
About six years ago, I wrote a VB6 program to convert an AS/400 screen
format into a VB6 form.  Once I found that Access was much easier to

I'm sure there's a quick and easy answer to this question.
After doing all of my previous work in Access 2003, I just installed Access
2007. Much to my surprise, the first time I opened a custom form, none of the
command buttons on my form worked. I couldn't open a report, save a ...