Search results

see my first post for a description of what is going on

should that query be used off of the table or should I base it in the Form?

yes they can have more than one customer number. That is what I don get. But I will try your suggestion of a query. Thanks!

I looked at the Northwind DB. See I understand how to use lookup tables fine by just picking data from a table. However I dont understand how to only get the customer numbers associated with a specific customer Any help?

I know this is on the forum somewhere but not sure where. try this

cool thanks that worked. But I thought there was some character to put infront of it to make it print the following character

How would I be able to print out If MsgBox(""" & Me.CustomerID.Text & "" is not in the list!" & vbCrLf & "Add it?", vbOKCancel, "Add New Customer Confirmation") = vbOK Then I want to put the CustomerID in quotes

try this

i didnt have the full version installed. I had basically samples. Now I have the full version and it makes it much simpler. Thanks!

can you post your DB?

:D HAHAHAHAHA ooops. Yes Shift

Hold down the shit key as you open the DB and select Tools > Startup and uncheck

try this Private Sub Report_Close() If IsLoaded("InvoiceList") Then DoCmd.Close acForm, "InvoiceList" End If Call NewRecord End Sub

i would imagine it is on 2000 as well

would this work? me!yourSubformName.form!yourTextboxName

there is a student db in Access 97 wizard

not sure what "package" I have. I have it at home and I am at work. Thanks for the tut

it's strange because I installed 8.5 and all I saw was a folder of Examples which had VB source code in it. Maybe I just didn't look in the right place.

so is this a standalone application? Or do I need to run it through VB or something? And if so what is it generally ran through?

thanks! Anyone else have any more info?