I am using MS Office Access 2003 (11.5614).  My basic question is can
I run a query of a query datasheet.  I want to use more that one
criteria and can not get that query to work.  I thought I might be
able to accomplish the results in two steps by using two queries.  If

I am using MS Office Access 2003 (11.5614).  I have been running the
following query with good results.  The query lets me enter the month
period and returns the SUM of the age fields.
SELECT [Enter Month/Year as mm/yyyy] AS [Month/Year], SUM([0 to 18])

I have a bound textfield in my form. In the beforeupdate event of that field
I want to refer to that field's value. What's the easiest way to refer to
that field's value?
st = MyFieldName works but I'd rather refer in a more generic way like

I'm new to Access and VBA. (I've been working with Pick/Universe forever.)
I'm about going nuts trying to figure out something that should be (and most
likely is) very simple.
I have a form that reads and writes data from/to a table (call it

Does anyone know if Microsoft has a page for free or royalty-free office
2007 style application icons? If not, can anyone recommend a good site for
app icons?
Many Thanks,

I have an Office 2003 database with custom menu bars that work fine
under Access 2007 with the following exception.  The Officelinks menu
item, "Analyze it with Microsoft Office Excel" is grey out and won't
work.

Hi there; I hope someone can help  with this:  When trying to past a
set of rows into a table, Access only pastes 31 rows but no more. I do
know that this is a parameter somewhere in Access but for the past
week have been unable to find it. I tried every button in Access 1997

I have a date field in a database. I have been given forms to be
printed out.
The problem is that the form requires the date to be printed out in 3
seperate parts. In the form day month and year.

The raw order data that is imported into my database contains the
price of each product including UK VAT (17.5%). The client needs to
show VAT separately in reports, so I have to strip out the VAT from
the raw data, show the sub total, show the VAT and show the total.

In MS Access 2003, I'm using a command button to raise a Find and
Replace dialog so the user can look up records by last name:
txtLastName.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

How do you use the format function in acess to display the month part
of a date fied

I have googled for 2 days and tried every example I can find to use
ADODB to query a table from VBA.  I'm using Access 2003.  In all cases,
the error I get is something to the tune of "you left a required
parameter blank". I even tried plugging in all the Optional parameters,

The message body of my last 2 posts has been deleted as soon as I post
it.  Does anyone know what's going on?  This is wierd.

Hi.  Does anyone have the patience and knowledge to determine what's
wrong with the following SQL statement (that is being passed to my
MAILMERGE routine)?  I haven't a clue.  The error message doesn't really
help.  All is says is that the SQL statement is not valid.  Does it have

Discount on gaming laptops http://cheaphardware.blogspot.com/