Search results for query: *

The database is shared. It is being used by our whole company for lab data collection. Is it the Query that the report is based on? Can that be opened by more than one user? ARG! Mickie ~:)

RunTime error 3262 Couldn't lock table. Currently in use by X on machine X. Mickie ~:)

I am running the following code on a button. This runs 2 queries that combines two tables into one. Then a report opens. However, I guess 2 people can't use this report at once because whenever you try to open it when someone else is looking at it, you get an error message. NOT the error...

This is not covered in HELP. I have a form for making a reservation. 4 fields [name] [organization] [numberoftickets] [Price] I want [price] to be auto-calculated based on [Numberoftickets] * $48.00. I can't get this to work. Any help appreciated. Thanks! Forms newbie..........

We have a homeoffice (MS ME) where the "server" is kept. The server is Connected via a SMC wireless router to another desktop (MS ME) and a laptop (Win 98). I have Earthlink DSL...with NO static IP available in my area. So it is dynamic. We just rented a business location. I want...

Ginger is a GODDESS!

right! I just want to match it. Yes they are entering results into a form. thanks!!!!!

Sorry it isn't clear. It is a bit confusing. I'll try to give an example. Table: Spec Custspec ID--text testID--text Low Limit--text High limit--text Table: Results sampleID--assigned when sample is logged in testID--text--related to above Custspec ID-related to above Result--text (these are...

Professionals! Take this one on. I have a field "results" on a form that is a TEXT field. In this field, lab techs enter in their test results for a test. All test results are saved in the same table....regardless of the test type so the test results field MUST be text to account for...

Don't know if this will work but.... Are you advancing to the next record by hitting the record selector button or did you make a button to move to the next record? If you made a button, try to make the "on click" command of the button do me.grandtotalbox.requery Maybe that will...

ARG. It is now halting but Now I can't get the variable to pass back to the main form. Here is my code. Private Sub SignAllreq_Click() Dim mypass As String DoCmd.RunMacro "masssignI" 'a macro that opens the 'Password form in dialog mode. 'password form...

Oh my God. Is it THAT easy? Man, I'm gonna kick myself in the knee! I guess, it's all in what you have experienced... THANKS!

I need some help passing variables. First. I do not have my database Protected using Access Security. I have a MAIN form that has about 20 different fields that will have to be "signed off" by various people, so I need field-level security. I have some code in a MAIN form (on...

ON the MAIN FORM, I have about 18 different sign-off fields. When someone wants to sign off, they click into their sign-off field which opens the PASSWORD FORM. I need to assess the input of the PASSWORD against the field they are trying to enter. If I move the assessment code to the PASSWORD...

Well, that WOULD apply, but.... I guess I left out an importamt fact. I want to use this password form on my different "secured" fields (sign-off fields) in my MAIN form. So, the password form need to assign it's input to a variable. And then my main form field will then assess the...

First. I do not have my database Protected using Access Security. I have some code in a MIAN form (on click of a button) that says: When this button is pushed, open the PASSWORD. In the PASSWORD FORM I have the string that is typed in assigned to a variable X and close the password form. Now...

I have a question I haven't been able to find the answer to. I have many databases that I have written that people all over the company use. There is one (and ONLY ONE), however, that I'd like to place security on. I DO NOT want to make everyone in the company log into Access every time that...