I have a form with two tabs on it, both tabs getting its information from the
same query. When I tab through the first tabbed form and reach the last
control, and then tab again it goes to the next record on the first tabbed
form. Is there a way so that when I continue tabbing it ...

Based on my main-form controls values, my sub-form shows the query result.
Now if Control1.value has certain values, then Control2.value must be left
Null on the main form, otherwise the query results in no record in sub-form.
Now the question is how I can turn a control's value ...

Hello gurus!
In the startup options I have set it so the database opens a form. This
works ok. I can also open the same form from the contents window.
I have also set up a small menu on which I use a command button to open the

I am trying to find away of calculating how many days there are between
today's date and the start date. This is basically what I have:
Start date of audit/SA: dd/mm/yyyy
Running day count:

I realise that there is no way of turning off the "auto save on close" in a
form in access, and that you can use beforeupdate to test if the user wants
to save but what if i had a bound form where i only wanted the user to save
using a button, is there any way at all to cancel or ...

I am trying to insert a record into a table based on inputted info from a form
using the code builder. Code is as follows:
Dim Sql As Text
Dim TT As Text

I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to

I am currently working on a form called Manage Distribution Lists. What I
want to happen is when I select a list via a ComboBox called ListsCombo, the
Listbox (which right now is named List Box shows me all the users associated
with that list. I have the users stored in a table ...

How would I go about setting up a command button so that if I click "yes"
the code proceeds and if I click "no" the code is cancelled. The code I have
at the moment is this in the "click" event:
   Me.CreInv.Value = True

I have a couple of questions regarding use of the quick access toolbar, in
short I want to be able to create some custom buttons in the QAT which will
carry out the most common actions of my users.
I have been advised this may not be possible however I am wondering about

I know it is not generally a good idea to store calculations in a table but
for my application there is no way around it i need to store the difference
of 2 times. Many people use the table resulting from the form and it is
outputed to excel alot. So is there anyways at all to ...

I am building a form where I use a short date input mask in a date field in
my table.  After the date is entered, I can see the date reflected as I would
like it as "08/18/07".  
However, when I go to someone elses computer and use my form who has their

Using Access 2002.  The application is opened through a metrframe
presentation server.  3 out of 50 users can't view the entire form.  The
window cuts it off on the right.  If they tab over, it doesn't scroll.  The
cursor just vanishes into the right.  I played with a bunch of ...

If i have a database linked into Access, and that database only allows "read-
only" access, and my other problem is the data i need to pull from it, the
column names do not match up with any of my other column names and i cannot
change them.

I have a report that is grouped by year. 2007, 2006, 2005. within each year
there are 4 ratings, and a count of those ratings. This table is linked to a
query that is doing a count of the ratings by year.  I also have a footer
that sums the count of ratings, by year. What I'm trying ...