I have a querie that needs to use multiple calculations (...I think...)
Fields:
TransID
TransDate

My default menu in Access 2003 is completely missing. I've tried reset
the toolbars and programatically enumerating all the toolbars/menus in
order to revive it. I've also tried reinstalling Access on the PC and
just cannot get the default menu to return.

We have a user who is suddenly getting the following error message
when they start our very mature application.  Other users of the same
version are NOT getting this error:
"Error 3075 - Function is not available in expressions in query

First a quick background on the form:
I have a form that is normally viewed in Single form mode. It has a
subform on it that is in datasheet view. The main form is for work
orders and the subform is for parts used on the work order. On the main

I first read about this in mvps.org, but the code he gives doesn't seem
to work for my form.  I"ll post my code below.  I'd love it if someone
could point out the error in my code.  BTW, this is my very first time
here and I will look forward to sifting through all of the posts and

I have a database that allows the user to input a department code and
get all the employees within the department.
The table is generated from another script that places the numeric code
as a text field, which is fine.

What is the name of the version to create run-time's for Access?  I
don't know where it's located at the MS web site.  Do you have any idea
what the MS model number is?  Do you need to Office as well as the
developers kid or is the kit include office too?

I have a funny issue. I have a stored procedure that opens up as a
datasheet. User can use the filter by selection option in Access to
filter records. For some reson, some of the columns cannot get
filtered. I get an error "Cannot apply filter on one or more fields

We have a user who is suddenly getting the following error message
when they start our very mature application.  Other users of the same
version are NOT getting this error:
"Error 3075 - Function is not available in expressions in query

I cannot make sense of the ODBC error messages my VBA application
throws at me. I connect to an Access database of about 500MB in size.
First, there is the "Not enough space on temporary disk". This happens
when I insert many rows to my Access database. If I increase the ODBC

I have a Access 97 query that has in its where clause:
And ((tbl_01_LoanData.PayOffDate) Is Null)
Upon execution, all records returned have no PayOffDate except 1. When
I include PayOffDate in the select list one record shows a date of

is it possible to download files from web site,
if list of files is given as full URL, for example:
http://www.somewebsite.com/file01.jpg
Thank you!

I am using the DatePart funtion in a query to extract the day, month
and year in separate fields in a query. The function works fine but I
am only getting a number for the month even if the field type is a long
date and the month is stored in the table. I tried the following to try

In my form I have an option group with 3 option buttons. My form is
tied to a table. the options are Temp, Permanent and Overtime.
I have these inside a frame. I have an AddRecord button to enter the
data into the table. After the record is Added the option buttons are

I've got a form in datasheet mode. Access 2002, English language.
Windows XP in German language. This form gets it's data from an Oracle
View.
I've got a field 'text' on my form, the field's contents looks like