I am developing a new database and created a form that contains 2 subforms.
I created code behind the main form that was connected to one of the command
buttons, but I did not create any other events for this form or the sub forms.
The sub form are based on queries.  The Main form ...

Dear newsgroup,
For a fairly simple MS Access application I need to create a form to
enter a few fixed fields of customerdata and answer a unknown number of
Yes/No (radio button) questions. The questions are stored in a table X

This is a curious one. My Users say that this used to work but now does not
and I can't see why.
I have a form with a subform. Previously, the users could edit a certain
field in the subform and when they moved to the next main form record, the

I have one main form with two subforms.  I can enter data through the form
and all info is logged into the corrosponding tables except for the ID
numbers that are autogenerated and all linked.  The only subform that logs
all the correct ID numbers is the second subform.  The main ...

Using MS Access 2003.
I would like to set up my forms such that I am the only person who can
get into the design mode of these forms.  Thus far I've set the form to
remove all toolbars "On Open", but there are still a number of ways to

Is there a way to sum a specific column in a query? What I have is a
query that pulls several line based on a id field. I want to total just
1 column in the query and have it report back as new column. Example
Id         Site        price        date

I am building a database to store data for biological sampling of fish.
I have a trip form with all the data for individual trips (includes a
calculated unique trip number that links the subforms to it).  A
subform frmTripCatches that shows catch data (including species,

Hiya
I am having a big of a bad time trying to get an upload button to work on my
site
http://www.templates4auctions.co.uk/submit_a_template.htm

I have created a Main menu and a Print menu. Editing the 8 options in each is
not a problem. Editing the appearance on any but the Main is impossible.
Everytime I open the print Menu in design mode it defaults to the Main menu.
Never had this problem in DOS!  Woe Is Me!

I designed my form and see it in design view but it doesn't appear in Form
View.  How do I get it?

Each record starts with an Autonum Id Field which is incremented by one; ten
fields follow. I need a control button on my data entry form to add the row
of data; then start a new record by incrementing the first Autonum Id Field
and duplicating all remaining fields with the same ...

In my form under 'control source' i have input my datediff expression but it
is returning result #Name?, so am not to sure what I have got wrong where.
I am not an expert on Access and am only self taught through books and
websites so struggling to to figure out what doing wrong.

I'm currently creating a database that assigns problems to people that could
solve them. I have a table called "employees" and one called "incident
catagories". Since one incident may be solved by multiple people and since
one person could solve multiple problems, the database is ...

What I try to do is make my addnew subform visible on click...
Private Sub Kommandoknapp74_Click()
If Me.Kommandoknapp74.Caption = "New Call" Then
   Me.Underobjekt73.Visible = True

I am trying to calculate the number of days between a StartDate and EndDate
in Access while ignoring the weekends and holidays. I copied code and
directions from a posting in early November from Greg & Steve.
My main table is called Recruitment, and I have fields within that ...