I wrote a bunch of SQL statement in SQL SERVER and now im trying to do
the same thing in access. OMG what a pain that Access can't handle
updates or CAST() the way SQL server can. OK I thought I wrote
everything in Ansi standard SQL statement so it should be compatable?

The problem I'm having is the rsa.RecordCount always returns a '1' when
I know there should be about 1600 records returned. I read somewhere
that one should use '.MoveLast' before recordcount but that returns ar
error 'Invalid Operation'. And when I do the bottom loop, the counter

               Re: Access 2000
I know that to use a date criteria on a query, you have to surround it
with pound signs.  I am having a problem when I reference a date from a
loaded form.  Here is my date criteria:

I have a table (tblCorrespondence) holding records with fields like
[CorrespID], [VehicleJobID], [UserID], [OutType], [OutDate], [InType],
[InDate], etc...
About a dozen [OutType]'s are defined and I often use queries to

I am fairly new to the intricacies of relational databases so please be
gentle with me ;-)
I have just taken on a delivery run. The same (mostly) customers receive
deliveries Monday to Saturday every week. I need to keep these details of

I have looked for examples using " Double Columns per page but have found
none.
I have created a Query from a table, they consist of only 2 Fields namely
Movie and Id

UPDATE GIS_EVENTS_TEMP SET GIS_EVENTS_TEMP.FSTHARM1 =
HarmfulEvent.HarmfulEvent
WHERE (((HarmfulEvent.UnitId)=1) AND ((HarmfulEvent.ListOrder)=0) AND
((GIS_EVENTS_TEMP.CASEID)=[harmfulevent].[crashnumber])),

I stored the file name and path of photos in a table with data from students
and teachers.
Is there a way to show the photos in a report or form?
Thanks!

I am working on a cars investment tracking database and need some help
with structure
You have investors, who pass the money to company the money in turn
purchase cars, sell, and return profit plus capital to investorsy,

In the past I have had this issue with sendobject not working with A97.
Often it was related to more Access versions installed.
IME SendObject would only work with the latest version.
But I never had the issue one of my clients is having now:

I have some code pasted below.  It works down to the line where it sets the
permissions for the document and throws an exception "Runtime error 3358;
Cannot open the microsoft jet workgroup information file".  I'm not using
anything more than the system.mdw for the workgroup info ...

I am trying to create an installation CD for my MSAccess program in
Office 2003. I used the "Access 2003 Developer Extensions". My MDE
files are installed ok, the problem is with OCX files. There is no
option for selecting them in the package program. In previous Office

Is it better to create a query in DAO where a report has 4 sub-reports
each of whose record source is a query created at runtime and
everything is in 1 MDB file?
From what I've read and experienced it appears DAO is the way to go in

I use the following to add a column. This does not work on a linked table.
Error: Cannot execute data definition statements on linked data sources.
Any ideas ?
Thanks

Ciao a tutti,
ho un problema che non riesco a risolvere nonostante abbia girato mille
newsgroup...
Ho creato un'applicazione con access divisa in frontend e backend.