I have a query with data in two columns:
Column A | Column B
1                2
3                4

I have created several queries that summarize the data from a table. But now
I want to be able to display this information in a report. I want users to
have the ability to enter a date range (2/1/07-2/21/07 or Feb 2007) and then
have my queries execute and display the resulting ...

Is there anyway to use shortcut keys to move from header to detail
section of a form? I have a combo box in the header. When I select a
field from the combo box, it calls an event (procedure pasted below
for reference). The event causes the detail section to jump to the

Good morning,
I have a combobox linked to a query that looks up user-entered values.  I
have a button that will re-query the combobox, but I want it to automatically
drop down with the new values when the query is entered instead of having to

I've created three toggle buttons that run an applyfilter macro. When
I click on button_1 the records are filtered as they should be but
when I click on Button_2 although the records are filtered accordingly
button_1 still stays depressed. Is there anyway of changing this so

Dev Ashish explains the process here of what I want to do perfectly here:
http://www.mvps.org/access/forms/frm0012.htm
However it only seems to work with one control.  What do I need to do if
there are more than one control I wish to carry over?

Is it possible to run Access 2003 databases under the Runtime 2007 edition?
Is the Runtime 2007 edition available? If yes, is it downloadable? Costs?
Many thanks for your feedback in advance.
Rgds,

When I search for questions on relationships -- trying to find a question I
posted -- the order of the results is not chronological -- skips around and
includes items posted back in 2005 near the top.  Most lists are
chronologically ordered from most recent.  I like that and hate ...

In an A2003 application I have a large TAB control with 10 pages. On a
couple of those pages are a series of date fields where I want to
ensure that they are filled in in order - in other words a user cannot
enter a date into a field until the one before it has data in it.

Why do I get this message RUN TIME ERROR 3061; TOO FEW PARAMETERS, EXPECTED 1?
This is the code:
           Dim Bookable As Boolean
           Dim strSQL As String

Greetings. SQL 2k5, Access 97 (I know)
If I create User Defined data types in SQL, and relink my SQL tables
in the database, will Access still be able to read those data types?
For instance: for State I currently have Char(2) in SQL. If I open the

The tables are as follows:
tble_query -.> 1:n -> tble_CCode <- n:1 <- lkup_CCodeS <- n:1 <- lkup_CCodeT
I have a form that holds "query" information and a subform that holds
"CCode" information. Within this subform I have a cascading combo that uses

I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is having a
problem with it.
The message reads: Your database or project contains a missing or broken

can someone explain why/how a new database gets created whenever I close one
of my access databases.  I am using access 2007 and the new database is being
created and saved in the same directory as the one which I open....and much
smaller.  does this have something to do with the ...

How do I compact an Access database in 2007?