DB imports a txt file that is downloaded from a mainframe - all works well -
Unless the user FTPd the file in binary vs ascii
is there a way to check a file contents before actually importing it?
if not, is there a way to inspect a file after it is imported into access...

Split database:  ACC 2K
FE is mde, secured with workgroup, by-pass disabled
BE is mdb on share drive, with start up form and by-pass disabled.
What can I do to NOT allow someone to link to tables on the BE from a

Does the OnLoad event occur if a form is opened in a hidden mode?  Also, this
same form contains a commond button.  Is there a way to trigger that On Click
event via VBA on a different form?
I have a continuous form where users can select multiple items to export.  I

I have a submit button to send an email from access.  I have embedded a link
to the access database in the email.  Can anyone tell me why my link will not
go to the G: drive on the network?
It brings up the locate browser, but it doesn’t start with the G: drive as I

Here is what I want to happen.  I would like to use a list box, lstUpdate, to
change the visibility of subforms hidden on a page.
The list box is populated from a table, tblClickOpen, with 2 fields Title,
and Form.

Hi. I am trying to automate Mail Merge.  I understand it can be done using
vba (what can't if you only know the code!).  I want to kick of mail merge
using an query (qrySol) and using an existing word document (SolLetter).
Seaching Microsoft.com, I found a snippet:

The Access Command Button Wizard makes it very easy to add a "Find" button to
a form.  It uses this code in the Click event:
   Screen.PreviousControl.SetFocus
   DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

I have  a database on my computer which is shared by 5 users via lan
network.. I mapped my drive/foler/database path onto their system. works
fine. ok so far, I can say.
my question. I want to know how will I track how many policies been entered

I copied an mdb to a file with a different name. Now, when I try to view the
code for a form I get the "There are no registered wizards of this type"
error msg. Forgive me for complaining, Mr. Gates, but how is it possible to
get a MS error msg and find no reference to it whatsoever ...

I have a frmCustomer with a subform frmCustomerTour.  When the user selects
the tour for the customer, a customer price is calculated and saved in a
textbox "customerprice".  I have a form frmAccount with a subform
frmTransaction.  This form tracks all financial transactions for ...

I have a field where a title can be entered.
If the entry looks like:  "On Job Training" (without quotes) then I would
like the next field to show it as OJT.
Could someone provide me with a module that would accomplish this for me?

When "yes" is selected  the right subform opens. When "No" is selected I need
it to place the value of  "0" in  check box field then move to another field
in the main form.
is there any possible way to do this?  Below is a copy of the code that i

I have two forms, AllEmployees and OneEmployee.  If on the AllEmployees form
a user is at a record with the textbox, say "Joe", the user hits the command
button and OneEmployee opens showing Joe's record.  AllEmployees closes (so
only OneEmployee is open).  If the user goes back ...

How can I prevent the user from pressing Ctrl+P to open the print dialog
when on report preview?
I want this, because I must do some stuff when the user actually prints the
report, so it must be printed using my user interface.

Is there an easy way that when a report is previewed from within an Access
2000 app that some of the print properties can be pre-set i.e.  I would like
to set the number of copies property to a value of 3 - and maybe be able to
prevent the user from being able to change that...