I have A2003 split; FE on the C drive, BE on the network.  There are
some other people in the system.
The FE app is in A2003, the backend in A97.
I have an opening form; MainMenu that opens.  I can go between various

I faced strange situation. To explain, let's take the following table
with 2 rows.
ID | Order # | Order Date | State | Count
1   | 201 | 10/1/2007 | CA | 1

I just acquired a pro bono nonprofit client who has various problems
with Access that they want me to address.  In our initial discussion,
they mentioned that their network is a LInksys wireless network,
connecting 5 PCs in a small access.  Of course, my ears perked up at the

I've been searching the net for ways to convert an .mdb file to .exe
for distribution to non-Access licence holders.  There seems to be
lots of conflicting opinion on the matter.  It seems that the
Developer kit from Microsoft doesn't give the best result.

i found a program that provide a solution of how to create a timeline
report similar to microsoft project
i made my changes on the program
some of the results is berfict and others is wrong in the same report

I have a report that is 14 columnar sub-reports (Line up: Position-
holders in each of our 14 locations - Manager, Assistant Manager,
Receiving, Office, etc).
I output directly to PDF (using ConvertReportToPDF from this site -

I have a PROBLEM form with a TASK table embedded as a subform. Each
problem can have many tasks.
What I'm trying to do is when I double-click on the task ID, the TASK
form opens up on that specific task.

Hi gurus,
I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job.
What it does:
When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process.

I use access as a front end for several databases (both access
database-seperated from the front end, sql, and iseries DB2).
I am about to start developing forms for useres to search for
different data. I read at Alan Brownes site that he does not recommend

Is it possible to have Access 2003 put the ldb in a different folder that the
mdb is in? Thus allowing users Read-only access to the data without having to
set up database security.

Does anyone know why the query below would return numbers?  I'm
attempting to produce a report that shows in *one* column the names
that appear in multiple columns in a single table.
Table Name: project

I have a database that is on my company's network that everyone needs
to be able to see, but I only want certain people to change any data
in the database. Is there a way (like there is in Excel, why can't
Microsoft make products of the same family have the same advanced

Re: Access 2003
I have a line of code in my app that sends an email after these strings
are populated: gblSendTo, gblEMailSubject, and gblEMailBody.
DoCmd.SendObject , "", "", gblSendTo, "", "", gblEMailSubject,

You know, I've had so much fun reading the thread on lookup field's
subservience to the Dark One that I thought I'd provoke another, ah,
polite discussion on the topic of Macros.
I've always been of the opinion that the only reason Access even has

this is my sql code.
-----start code-----
SELECT Reeksen.ReeksNR, Reeksen.ReeksText, Count(Strips.Titel) AS
NBTitel,