Need VB code to take all of the data from a table in Database1 and append
this data to a table in Database2

Thanks for taking the time to read my question.
I'm wondering if you can copy a table with code into the same db, but
structure only.
I found docmd.copyobject, but there is no option for structure only.

I am using Access XP.  I would like to create a query that returns a
cummulative number for a given person, then starts over with the next person.
for example.  Assume Expr1 returns the cummulative query function:
Name     Amt     Expr1

I have many disabled text fields on my forms. They work fine and don't let
the cursor in, but they are very hard to read. How can I change the
foreground and background properties of my diabled text fields?
Thanks much!

The function "normsinv" in Excel is used in an equation to calculate the
sigma quality level (sql) of a process.  The equation is
"=NORMSINV(1-((B1)/(B2)))+1.5".  I have not found a similar function in
access.  Is there anyone who has developed an access function that will

I am creating a new function and need to pass the name of a field as a
parameter.  I am passing a query name and it works fine.  But then I need to
use the field, also a parameter but can't figure out how to convert the name
so it can be used and not look like a string.  Below is ...

I'm a bit confused finding the source of the ODBC error 3156 (Delete on
linked table <name> failed).
I'm having a form showing me the contents of a table. On top, I have a
combobox showing me the names so I can easily jump to the correct

I have a form that displays a recordset of data from a table. I have a
textbox for users to enter a search string & a button labelled "Find" to do
the search. The OnClick event procedure is defined as:
Private Sub FindButton_Click()

I have created several arrays from which I want to create a table in a VB
routine. Within this routine, I have created a new table successfully and now
I wish to populate the table with data from the arrays. The SQL statement
INSERT INTO always seems to require values or select ...

When in debug mode and I hit CTL+BREAK the module does not stop until it
finishes and the menu's aren't active. Is there a way to turn off/on
Control+Break in debug mode?
Thanks

I have two mdbs, call them mdb1 and mdb2. mdb1 has some modele code that I
want to execute via events triggered through a GUI interface in mdb2. From
reading other threads on this board, the only way this can be done is to make
the code in mdb1 a Function. Question 1 - Is this ...

I hope this isn't inappropriate, but I figure if anyone can help me, it's you
fine folks at the MSDN newsgroups </suckup>
I recently found out that my position is being eliminated and I'm updating
my resume. My quandary is this: since a lot of what I know is self-taught,

I'm trying to automate a process from access (acccess 2002, windows XP).
I've already done a routine wich enables me to connect to a web site, then
does the adequate request to the web site.
The web site creates then a file (.csv), that I want to download (within the

Thanks for taking the time to read my question.
I have to import text (.csv) files to tables in my database.  The trick is,
the user can select what file they want to import into what table.  It's ok
if the files to import are speradsheets as docmd.TransferSpreadsheet takes

Hi,
Has anyone written a script to increment a hexadecimal number? We want to
keep track of the the Mac Addresses that we're using.  Basically, I'm
thinking of keeping the last used hex number in a table so that anytime a new