I have a form were I changed the lock property to yes for every field to
keep Users from editing the data by mistake. The reason I locked every
field and not the form was to leave one field open to pick companyname and
bring up the record for that companyname. (I should also mention ...

I have a form with several unbound text boxes presented to ask users to input
common data to be passed to several controls in several related records on a
subform.  For example:
Main form

This is too weird.  This is pretty straight forward...assign an invoice
# and then append to the InvoiceMain table.  It assigns the # and runs
through the code with no errors, but it doesn't append the InvoiceMain
table.  If I do it through a query instead of Sql, it works fine.  ...

Has this happened to anyone else? I have a form which is
sort of like a switchboard form. The form contains 2 list boxes
which are populated with select statements. The form also has a
custom menu that contains the Make MDE File. Here's what happened.

Is an amphersand allowable in a command button caption?  While it shows okay
when editing the caption, as soon as I close the caption edit, the "&"
disappears.  I have tried: &, "&", and \&.
Any help will be appreciated!

I can't seem to figure this out.
I have a database where all the tables are in a separate
back-end linked file. There were some tables in the initial
version of the database that I want to delete.

We have a form on which the user can "Find" customers by first/last name and
phone number.
When the users enters their criteria and clicks "Find", the following code
runs...

I'd like to move from VBA to VB.
What would I have to use to build forms and reports? Would the MS Visual
Studio be enough?
Thanks

i have a default year variable defined in a public module.
i get the value from a table on login.
i display the value when i'm in the customer form so i know what year the
prices are for.

My cancel button is not working.  It's opening my add form even if I click
on the cancel button.  Below is my code.  Thanks in advance for any
suggestions......
Private Sub AddNewRcd_Click()

i have a form with a list of customers
for finding a name on the list user write's the name in a text box
the code i'm using is:
Private Sub TextBox_KeyUp(KeyCode As Integer, Shift As Integer)

How can we specifiy a printer in VBA code?..  The problem is that when I
print some report, I want them to print to PDF File instead of the Default
Printer
Thanks!

I'm using the folto prevent users from 'tabbing' out of a field.
Private Sub ControlName_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyTab And Shift = 0 Then
   KeyCode = 0

In my application I created a user login form with username and password.
Data is retrieved from a user table using listview control and Dlookup
functions.
So far so good.

The intent:
In a form, I have a data entry subform linked to a recordset.
In the same form a have a graph.  I want the graph to be refreshed based on
a query generated by the subform based on the click event of the control in