A couple of questions

[Vel]

Hello,

I have a couple of quick questions, and any help will be
appreciated.

1. Is there a simple way to set up a laptop so I can
pull data that is entered into it back into the main
database? i.e. the database is located in
//DBServer/Backends or something along those lines.
Could I make an append query that takes the new data from
the tables stored on the laptop and places them in that
folder even if the laptop isn't always on the network?
If not, what is the best solution?

2. How do I give access a command to print a report to a
file? This is necessary for the import of data into some
billing software where I work.

That's it.

Thanks,

Vel

 

[Casey]

Vel,

Can create a new database or use a copy of an
existing one your laptop, and use the transferdatabase
method in a macro to import the tables that you are
interested in into the main database. From there you can
use delete, append, or update queries to replace the data
in the tables of your main database as needed, applying
the queries using a macro.

If you want to save something as a print file, when
you use the File - Print option at the top left of your
screen and select Print to file during that process, or if
you are in the Print Preview of the report mode, right
click, select Print, then select Print to file on that
screen, and it will do it.

Casey