Search results

Hello, is there a way i can print an excel document from access? using VBA Andrew

I have not used queries or Access for a few years. I have a query set up to search for a tag number which the user enters in. How do I incorporate the * function in with it? This is what i have tried: SELECT * From Bags_Recieved WHERE Tag_No = *" & [Which Tag?] & "* I am trying to get it so...

not sure how I am still very new to Access. I am not very good at queries and do not know how to do the one you recommended. If you could help or send me to a link to help me understand them more that would be great. Thank you for all your help up til now, its been very helpful.

I have a table with 3 columns. A crew column (user name), a password column, and an admin column (yes/no). I have made a form so the user enters in a user (which is stored in a public string) and password to get to the main form. I have made a form so the user can change the password if they...

thanks Thanks for the info.

works Works awesome. Thanks a lot

kinda works thanks. it works when i enter in a umber but when i enter in a string it gives me #name? on the next line

I am using a form in the Tabular format. I have 7 columns in the form. Some of the info is the same on the next line. Is there a way to bring down the same info onto the naxt line without having to keep entering it in. For example I have a Time column where the user enters in a time, usually...

table structure I have 8 columns in the table. I have an autonumber, date (which is auto), time, can number (integer), Tag number (integer), handlers (text) and a memo. I was originally going to use the autonumber and store it in an integer when the user signed on and when the user sent all...

I am not sure how to do this. I am trying to do up a password form where there is a user name and a password. There will only be 5 user names, one being an admin. I seen it in the Running Microsoft Access 2000 book (it's just a reference manual) but could not figure it out.

I am working on a database for work. It is a processing plant and once a product is complete it is entered into a table. At the end of each shift the workers will be logging out. What I need to figure out is how to just get a total product processed a 12 hr period. The periods will always be...