I'm designing my first Tabbed SubForm in Access 2003 and I noticed a few
minor issues that I find puzzling. Here they are:
1. If I place a New Record command button on the tabbed sub form, I noticed
that it shows up on every tab. Why? It would be nice to have a New Record

I have a search form. The form receives search parameters. On the search
output it gives records in a continuous form.(The search and the output is a
single form) Now I have added code in the oncurrent event of the form. I have
put a breakpoint on the new code. As soon as I am ...

I am creating a library catalog DB where the main table, “bookTable” includes
relevant book fields. One such field is the publisher’s name, “Publisher.”
Publisher is a combo box that looks-up publisherTable, which has an
AutoNumber ID and a Publisher field. On my new book entry ...

I have a datasheet form which opens from a Macro.  In the Macro I set a
filter.  I would like the user to be able to filter on the datasheet but only
based on my original filter criteria.  Currently what is happening is if they
click the "remove filter" button on the tool bar ...

I would like to build an option group with two options, if one option is
selected, a combo box displays one query's results, if the other option is
selected, a different query is populated into the combo box.  How would i go
about doing this?

I brought a copy of an application home, modified an update query to update
two additional fields (don't ask).
It worked.
I took just the query back and copied it to the original program.

I have a form that is a popup form.  I would like to have the form as a
continuous form for listing out the information, which works fine.  But 2 of
the fields are memo fields and cannot be placed on the subform.  I thought
about making the popup with a subform for the task list ...

I have a form that I want a message box to pop up showing the number of
records in the dataset after a filter is applied (Filter By Selection, Filter
Excluding Selection, Remove Filter/Sort, etc).
I've added the following code to the form:

I have a job form with a subform that numbers the reports submitted for each
job.  I set my default for reportNumber as follows:
=DMax("[ReportNumber]+1 ","tblPWreportLog","[jobnumber] =  
Forms!frmJobs![JOBNO]  ")

i need to Update a field in a table from a cmd button.
i know how to do it with a simple WHERE:
DoCmd.RunSQL "UPDATE tblEmp SET tblEmp.EmpRecords = -1 WHERE " &
strFilterNoCancelados & ""

Hello we have a form in which the users enter the data in Greek language. In
some fields the data must be entered in english (e-mail field etc) Is it
impossible every time they enter a specific field the language to
automatically be changed from Greek to English? and when they ...

I have an Access.mdb. What is required so that it can be viewed online.
Appreciate complete codes and processes.
Thanks for the help.
Regards

I have a form that contains a control [CourseCategory].  There's another
control [Category] on the same form.  For new records, I'd like the value of
Category to default to the value of CourseCategory.  I've tried setting the
Default Value property of Category to CourseCategory ...

My main form when the database is open is HelpDesk Switchboard.  I need a
shortcut or something to open another form called HelpDesk info based on a
combo box listing our 3 company locations from the HelpDesk Info form.  I'll
just call the locations L1, L2 and L3 for simplicity.  ...

I just learn that to set subdatabse sheet name from auto to none  and
compact database to improve database performance.
It seems that Access reset sub database sheet name while compacting
database.