I have a query that works on linked tables from two distinct backends
(SQL Server and MySQL) and is very fast to fetch data, about 2" to be
executed. In a form this query act as rowsource for a listbox.
The problem is that when I try to open the form, it takes about 20" to

If you use the wizard to drop a delete button on a form, it generates the
following code:
   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
   DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

I have a form [fInsurance] based on a query [qInsurance].  The query is based
on two tables [tVendors] and [tInsurance].  While the form will allow me to
update records, it will not allow me to save new records.  The new records
button is not grayed out so I can go to a new ...

Hello experts,
This is what i've used for my subform(FormSub) to interact with my treeview
control
on the Main Form(FormMain) of my database.

I'm using the Flex Grid demo  (thanks peter h)...i've managed to change most
of it to my needs but have come to a stubbling block.
The demo uses Project ID in two tables, they are defined as numbers. My
project ID needs to be Text, so i changed it in both tables opened one of the

Is there anyway to add the 'running query' status bar (bottom left) to a
form? The form I want to add it to is a 'database busy' form so that the user
is aware that something is running and that the database has not fallen over.
Adding this status bar more visibly to the form ...

I use the mscal.ocx as a drop down calender and it works fine "except" I run
into a problem when there is another mscal.ocx on the users system with a
different date.  When the user has this other mscal.ocx on there computer
Access cancels when the user clicks the down arrow.  Is ...

I'm not sure what I did, but I've lost the ability to add new records to a
form in Access 2003.
I can go into a Table and add the record, but not directly through the form.
The form's source is a Query that is run from the aforementioned  Table.

Hi everyone.  I have a form that contain a subform.  At the top of my form I
have 5 unbound textboxes that represent Date Scheuled, Lead Auditor, Audit
Team, Department, and Audit Scope.  Underneath these 5 unbound textboxes is a
command button to click to add to schedule.  I am ...

I am creating a new database and my subform is acting strange.
I have three (3) tables
Meetings
  MeetingID

I have form called Schedule with two subforms. One subform shows appointments
by date and the second subform show appointments by time.  I want to update
the form showing appointments by time from the subform by date.  I tried the
method

This seems like it should be simple:
Using a form property sheet Access allows me to specify "Allow Edits",
"Allow Additions", and "Allow Deletions", but these pertain to entire
records.  I can't figure out how to "Allow Additions" and not "Allow Edits"

I have a form created and it contains check boxes. When I save the form then
re-open, the check are not present anymore. how do i fix this?

Hi Is there anyway to change the size of a tick box displayed on a form ?????
I have tried everything !!
Thanks Tony

I have read a lot of literature on how to extract records in a query, based
on input from a form, where certain fields are left blank as an indication of
wanting all the options from that specific field. It goes something to the
effect of criteria: [Forms]![Form]![Field] or Like ...