I posted this within a prior question hoping to get a reply, but nobody
answered, so I'm posting my own question.
I have a form where the user clicks on a button, which returns to him a
print preview of a report...I'd like for him to then have the option of

Here's what I would like to happen...
Browse for file dialog comes up, user selects a file (or multiple files),
the files will probably be on their computer, so after they select it (them)
I want to move the files to a particular folder the server (everyone has the

Currently, I have 2 loops.  One to import all workbooks in a folder, and a
loop within that to import all worksheets within those books.
But when the workbooks close, I get a message box saying the book I just
closed in now available to read-write  or cancel.  How do I make that box ...

How can I append records from an Access table to a SQL Server table?
regular append queries cut off the memo fields at 255 chars. no good.
i tried using adodb with sqloledb provider, bu then it doesnt find my access
table.

i have an access2003 database and i have created a .chm file using HelpMatic.
Does anyone have any sugestions how i can integrate the .chm file with access?
i have a help button on all my forms but when i use the follow hyperlink cmd
i get warning messages before it opens the file ...

I did a complete recovery on my laptop, and saved my data on a WD external
USB harddrive.  Now when I copy the data back onto my laptop, I find many
files are corrupt!  I have a couple access databases that I really need to
code from.   The database tables are important, but the ...

I am new to Access and SQL. I am trying to open a recordset, initially
showing all records but eventually I will also need to apply filters in a
WHERE clause.
I am getting a "Syntax error in FROM clause" message, and can't figure out

i have a imported data in a table which has a field [sales price] of text "AU
$ **.**" and i need to do calculation on the field. I have created a form
with the exact table and trying to link the field [sales] of currency to the
field of [sales price]. What can i do?

Why am I getting a "runtime error '13': type mismatch" for the line
       Set rsState = dbs.OpenRecordset("Select State From tblState2000
Where StateID = " & iLoop)
that is within the following script?

I have an MDB that is working fine on 5 systems, but it will NOT open with a
double-click on the icon on ONE machine if other users have the file open.  
If NO ONE has the file open, this machine will open the mdb with a
double-click on the icon.  Also, if another user has the mdb ...

I have a database than I wrote to keep track of an co-operated vending route
and I have. And I have a huge inventory of CD’s that I would like to enter
into my database, can you use a bar code scanner to read the artist name on a
CD. And how would you do this.

Can anyone help with me please - been scratching my head for over a week now
- I am trying to colour stacked bar charts dependant on a set of different
variables using the series collection property struggling to work out why I
continually get

Anyone know of a method to programmatically determine the name and IP
address of SQL Servers running on a network?
Dale

Has anyone had any problems with Access (2000 and up), full product or
run-time,  when converting from XP to Vista?

In a database of mine I have a form with a few text boxes (first name, last
name ...) and some subforms for additional information. The problem is: When
I try and register a new person and have typed in what is required in the
form, I move to the first subform. Then Access says ...