Can anyone tell me if there is a way of creating a compressed(zipped) folder
from within my VBA code?
I have a document management database which creates/moves/deletes etc files
and folders using the FileSystemObject. A folder may contain several

How can i prevent my databse objects from being imported?

When I send an access report to Microsoft Word, all the numbers show up fine,
but none of the lines.  How do I get the lines to show up.

Is it possible to export a table from a database with user level security to
an external unsecure database?  I need to do this to allow another program
to access the data.  I have admin user access to this secure database.
Thanks

I known that is more or less easy to set up a unbound form and it is
possible to create, but I have never seen a unbound subform.
Is it possible to create a unbound subform (Datasheet layout)?
If it's´possible, I will be very grateful if I could have some codes's

[Discouraged by the lack of any response on
microsoft.public.access.odbcclientsvr, I'm now cross-posting to
microsoft.public.sqlserverconnect and microsoft.public.access. If the
message does not explain the problem adequately or is sent to the wrong

Hi...I'm a newbie when it comes to the net and working with databases.
I cut my teeth on Rbase for Dos, then moved to Foxpro 2 Dos then
Foxpro 2.1 for windows.  Access of course is a new ball game for me
although I did use it in my work about 7 years ago simply by trial and

How do you set the switchboard to automatically open when the database opens?

I have a large continuous form filled with a bunch of fields containing text.
The user would like to be able to type in the contents of one of the fields
and have the form scroll to that point.
My first attempt was to put an unbound field at the top, when you type into

HEEELLLLPPP! How do I get a textbox to reflect the username after a login on
a  different form. I have five forms and I need to have the username name
reflect on each. NB I have a table called users and another called login
which records the user logged in

I'm new to Access and need to increment a long number field.  I built a test
database called Order test with two fields, Key name and Next seq and have
been trying to increment Next seq by using the Expression builder.  I put in
the following:

hi all, i couldn't find an answer to this one, and i was hoping to run a
small phone no. database on my desktop, that is, without the Access Program
window in the background. So my 2 small forms would appear on the desktop
itself. i have Access 2003 and WinXp Sp2

In Word, I can make one mailing label or one sheet of the same mailing label
but I do not know how to make a sheet of various addresses. I do not want to
use excel if I don't have to.

Hi
I have a value that is less than 0 in a query and would like it to round up
to 1.
Please advise and thank you in advance.

Please give me link from i can download a payroll ms access file which i
will alter according to my official needs..
Shakeel