I am trying to create a table that has current date on first column and
a day based on the current date. Can someone please help me with this?
For Example:
Date             Day

I am trying to create a table that has current date on first column and
a day based on the current date. Can someone please help me with this?
For Example:
Date             Day

Is there a way to pause code in a form to wait for an on-click event from a
button on the same form?

I want to export all objects from one mdb to another. I can think of a way
to export tables and queries looping through the querydefs and tabledefs
collections, but what about forms, macros and modules? Is there an easy way
to do this? Note that the export to mdb contains ...

Im looking for a way to return the information of multiple contacts
taken on a per company basis for my own custom bulk emailing (mail
merging).  The data I have is like this.
1st       2nd      3rd          COMPANY                  FIRSTNAME

I have successfully created some code that enables me to double click an
email address in a field on a form wich opens our default email programme
(Outlook) and drops the address into the To: field. It also adds a subject
line and some copy to the body if this is passed to the ...

In Access XP I have merged two tables into a third one using the SELECT INTO
construction.  Access changes the respective AutoNumber PK columns’ Indexed
property to False which allows duplicate values.  Since I wish to have a
unique identifier column, I used the ALTER TABLE ...

We abuse Access on a daily basis, but it keeps running right along with us!
My department uses several large tables (like, 365 of them...each 100
records long...on average.)
I know we are not supposed to change data right directly in a table but we

Does anyone have either another method for implementing Mail Merge or
something similiar?  I have been scouring my books and don't find another
method.
AND The current method I am using now fails.  I am using ACCESS 2K, and

I'm looking for code that will allow me to restrict inputting data in one
table if data is not found in another table.
Tables:
tblParts.PartNo

I have a large 460+ page pdf file.  I want to be able to open the pdf file
and go to a specific page, say page 99.  There will be a control on my form
that has the page number.  The pdf file will always be the same one with a
specific path.  Any help or thoughts on this would be ...

Hey all, I have some code that seems to run fine on some machines but not
others.
It's an mde distributed to a number of machines but they all run 2003, same
build and Jet as the development box.

I am using a list box to identify the criteria for a query. Please help:
Private Sub cmdOpenQuery_Click()
On Error GoTo Err_cmdOpenQuery_Click
   Dim MyDB As DAO.Database

Realtively new to Access programming, so bear with me. I have a database on a
server with one linked table (through the Link table wizard). I am trying to
run a query using a parameter passed from a form. I am struggling to get it
to work, and even switched from ADO to DAO. The ...

I am trying to convert my database program to a run time program.  From what
I have read here, all macros must go and be replaced by code before
conveting.  This has been easy until i get top the autoexc macro.  Is there a
way or do I have to have the opening form do the job.?