I have several queries that create tables that I then use for reporting
purposes.  I need to be able to create a Date/Time field in these new created
tables.  These tables are constantly replaced so I need to be able to use a
macro or vba to add the new column, name it and set ...

A couple of versions back there was a run-time version of Access I could give
to low-level users.  Is this available with the 2007 version?

Does anyone know why on a computer that was running a program I wrote
(office Access 2003) and when I sent another copy with some formatting
changed on a report they are telling me that they are getting broken
references to:

Hi, i'm developing an access 2k aplication and i want the users log in to the
aplication with their usernames and passwords directly from active directory
so they don't have to type their usernames or passwords.
Thanks in advanced...

Hi all
I keep seeing Enums  in various bit of code and I've read some material on
them. But I'm no wiser, has anyone got a muppets guide to Enums?
TIA

How can I determine which column of a subform in datasheet view I've
selected (just for order by that column)? Which is the event? what
column was selected?
I'll apreciate a lot you help

I have a portion of an Access app that creates an Outlook Calendar item.  
That part works fine.  The problem is, I have nother part of the same Access
app that has need to delete the calendar item if it gets cancelled.  I
haven't been able to figure out how to use automation ...

The following code generates a syntax error on the RecordSet.Open command.  
In looking at a number of examples it appears to me as if I'm apllying the
syntax properly (please note thea the sql string is word wrapped here, but
not in my app).  What am I doing wrong here?

I am trying to color rate fields on status level (ex.HIGH/RED,
Medium/YELLOW and Low/GREEN).  I have created code that does  that but
when the choice is made the back color is changed for  all the records
for that specific field.  I want it to specific  only for that one field

I have a parameter text box (criteria) that I want to pop up when you click
on a command button which asks for input.  My problem is, I have 7 reports
that I want to open and print but I don't want the text box to appear for
every report.  I want it to ask once and use that ...

I have a main report and a sub report embedded in the main report.
Now, my main report is filtered by a date range and I want to pass the
same date range as a filter to the sub report. What is the easiest way
to do this in Access?

I use the following script to write registry entry:
WSHShell.RegWrite "HKCU\Software\Microsoft\Internet
Explorer\Main\Print_Background", "no"
I would like to replace "Print_Background" to "Print\ground.exe".

I have a problem with ADO. I am updating a ADO recordset in a multi-user
environment but somehow it seems that the code I am using is ignoring locks
by other users.
This is the code I am using

I would like to know how to create or delete a table in the Back-End database
programmatically.
Any help is appreciated.

I would like to click a button and it will scan a document and ask for the
filename to save to.  Any ideas how I can accomplish this?