Search results

Here is the rest of the database. I couldnt get it to post all together

I have the following database that is needing login/security for different levels of use. I have a startup form that the user can select their name, enter their username/passowrd. I have a table for the information that is entered on the form. If the user enters the wrong information they are...

When I try to create the repoort it tells me that I am selecting too many fields. Sir if you could send me back a sample from the zip file of how you would do it, that would be much appreciated.

Where in the query will I need to place this function? Forms![YourMainForm]![SSNField]

Well do I need to try to make the report in design view only? Or will I be able to ues the wizard, but I must take in the fact that it is a fairly large query?

gotcha as always ur the man!

Are you talking about a make table query? If so can you do that in access 97?

I don't really know alot of sql/vba and i'm fairly knowlageable about access. I am thinking that a union query will help me display all the data for a particular patient. I have enclosed a few tables and forms. If you could break it down to really simple terms I would appreciate it. What I need...

thank you for the info. right now i have in the lable box for that text box for the user to use that format. it isn't a required feild so its not going to make me lose any sleep.

On a form i have a text box for patient name. i also have input mask for other things like date and ssn#. What i would like is for the people using the database to have to put the name in as lastname,firstname. how can i do this and will i have to do it in the table or on the form?

if you could let me know what is the thred name or where it is located i would definately be thankful. but i still would like the same effect.

Could someone give me some advice please.

help please:)

Im enclosing the database to give a better understanding of what I'm trying to do. I have four main forms that have subforms on them. What I want the queris to display is all the info for the main form and also all the choices that were selected in the subform. Also will be making queries based...

im sorry i was talking about in the main form.

thank you. also i am wanting to set the combo boxes to when i chose surgical for area it will display only the units that pertain to that area?

Could someone help me please?

Could someone help me please?

ok i can send the database now.

well it cant zip it up right now but ill try to later but all suggestions will be greatly appricaiated.