I have a database which has linked tables, none stored locally - it
has a size when compacted of nearly 200Mb
it comprises 21 queries, 26 forms and 2 reports - there are no
embedded images and very little code on the forms

SELECT CEILING(5/2) AS OOPS, CEILING(5.0/2) AS HMMM FROM Schools
In my part of the world
CEILING(5/2)
and

Let us suppose we have this table
ID - CITIES
1 New York
2 New York

Is there any method to schedule Access queries to run regularly?If yes
pls mention how it is being done?

I am trying to run a pretty simple select query in Access 2007, and I
keep getting the error message "Reserved error (-1524); there is no
message for this error." There are no linked tables in the database -
the design of the database is very simple.

I some times have to scan 20 to 40 databases (on a daily basis) to see
who worked on that particular file and the only way to know is to open
it and check for their initials in the last field of the last record.
The file names are computer generated and no way of changing that so

Access 97/2003   Windows XP (Classic Start Menu)
I just converted an mdb from A97 to A2K3 and found something that,
after Google search, doesn't appear to have been addressed in cdma...
I have a form "frmMainMenu" that is the designated startup form (under

I am using Visual Basic to open a saved query and then save
information in the query to an array for later use.  The problem is
that the same query shows different results when opened directly vs.
when opened by Visual Basic.  It is as if Visual Basic is not letting

Happy New Year All!
I have 2 queries, a qry_HISTData and qry_RAWData.  qry_RAWData is
automatically triggered from a subform using the "asofdate" of the
mainform as a date parameter.  What I'm attempting is to have the

I am trying to make a query and I am stuck.  There probably is a
simple solution to this so hopefully one of you can help.  Here is
what I want to do:
I have a table that has 2 fields (Test Type and Date Performed).  The

I recently purchased the MS Access 2007.  I have used MS Access 2003 for
years.  I need to transfer a table in a Tab Delimited Text File format  and
do not see where2007 has a  TransferText function which gives you the tab
delimited option.  Is TransferText not available with 2007 ...

hello I am trying to use the iff function in a textbox in a report
like such: =Sum(if([prospdate]=[month1],[tcs],0))
but I get an error undefined function.
Kaspa

Great website for IT / Database professionals like you,
http://certdream.googlepages.com
and,
http://securityrules.blogspot.com

I'm exporting XML from Access. There is an option to not export key and
index information to a schema (XSD) file, but there's no option for the XML
file.
What I've been doing is using editors like AttEdit and XMLSpy to edit the

I have to localize an Access 2002 application: The application using
several form, tables etc. is currently only in English. Now the
frontend has to be bilingual, so the user can choose if he wants the
form content in English or in French. I have never done something like