I have an access application with a SQL server back-end database.  The main
form is called GCPP Modifications Entry Form.  We store screen shots relating
to some modifications, however, because of the time it took to load each
record we decided to add a button that would open the ...

Main form with 3 subforms, one on each page of a 3-page Tab Control.
Each subform has a gotfocus event, but that event only fires for SubForm1
when the main form (and its 3 subforms) opens.
Switching to the other pages and selecting a field on a subform does not

I have two tables (STUDENTS and SCHOOLS) with a many-to-many, so I created a
third table between them (APPLICATIONS), where the PK is an index of two
fields, the two FKs from the first two tables.  (I know concatenated keys
violate 3NF, but bear with me.)

I've got a database that I am trying to house on the East Coast, and
run on the West Coast. When users on the East Cost open the database
on the East Coast server, it takes them 5 seconds to get it open. When
the West Coast folks try to open on the East Coast server, it takes

I get the following error w/ the code below. Can someone help me with
figuring out how to insert the current VisitNo (fldVisitNo) that is linked to
RNnotes into the equation below. Thanks Robert
Error 3201 You cannot add or change a record because a related record is

I have a comboBox with 4 fields; fldDeviceNo(unique ID stored in underlying
table), fldManufacture, fldModel, fldModel#.
When a device is selected, I need all the fields to be displayed in the
forms field.

Here at my shop we use peoplesoft and peoplesoft uses julian dates that look
like this: 107040.  My question is if someone gave me a date in the format
of 02/09/07 on a form, how could I format it to look like 107040 so I could
scan the peoplesoft table?  Any sugestions?

I have three combo boxes on a form
combo1 = Organization region
combo2 = Division
combo3 = UserID (user names)

In the snippet below I am trying to assign a hyperlink variable to a field
using DAO, but get erro 438:Object doesn't support this property or method.
[txtDoc] is a hypelink value on a form textbox. [Doc] is a hyperlink field
in table Docs.

I have a document number field that is formatted:

The first two characters should actually be the same as what the user input
into another field, TYPE which could be BV or IV or WV etc.  

The user found a problem with the code listed below.  If they happen to type
in the SSN in the form where another document was already opened.  Even
though I have a button "Add New Record".  The problem is sometimes they are
not doing that and they type in the SSN over an ...

I currently have two bound list boxes on a form. The first selects
the main catagory, then the second finds the sub catagory from the
first. (works fine, bit cumbersome) I then store the two seperate values
in separate fields.

I have a textbox which is meant to be clicked on, not edited. It is an
unbound control in a subform in continuous view. There is code in the
OnClick event procedure which calls Application.FollowHyperlink. I
need to have a different URL for each record, which is why I can't use

Using Access 2003.  I added a comand button to my form and used the wizard.
This works fine in opening up the Find window but I would like the default
settings to be
--Look In: "Last Name" (This is the default because my focus is in this

I've build a couple of forms utilizing queries to first gather data from
several tables and then allow the updating of that data back to the tables.  
Probably a very fundemental process but relatively new to me as an Excel
junkie.  Anyway, the fisrt form's query draws certain ...