A couple of questions

  • Thread starter Thread starter Vel
  • Start date Start date
V

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
 
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
 
Back
Top