Search results

Hello everybody. I have a table that lists the serial number of a device along with a dozen or so different tests this device undergoes before being shipped to our customer. How can query a device by Serial Number and only have it display the field representing the latest stage of testing...

Ah I guess I should have been more specific. I have a table with a field SN (serial number), Date, and and ten other fields, TEST1, TEST 2,....TEST10. On 8/12/08 the SN may undergo TEST1 and TEST 2. On 8/13/08, the SN may undergo TEST3. I want to run a query that shows the the SN and ...

Hi all, I'm still learning so please be gentle lol I have a few tables, lets say X,Y, and Z each with 10 fields associated with a yes/no checkbox I want to run a query that will only show show the fields in tables X,Y, and Z that are yes (true). This seems so easy, but I'm not getting it...

Company is still using 97. I could not open the file, it said it was not a valid database file type.

Good point. I was trying to avoid this problem then. Assuming I had a date associated with every checkmark... How would I run a query to display only the latest stage associated with a unit. For example, if there are 100 stages of production broken into 5 separate tables, can I have Access...

Hello all, I have a new project and am running into new problems. Thanks in advance for any and all help. BACKGROUND I have 5 tables, each with an identifying field "SN". Each table contains multiple fields represented on forms by checkboxes (yes/no) that mark manufacturing progress for an...

Can anyone suggest an idea for how to organize this data: I have 700 different variations of the same type of electrical component. Each one of these has about 100 specifications, eg, power consumption, heat dissipated, voltage, etc etc. The categories of specifications are going to be...

I have two textboxes in a form ARW and ARW2, they are both numbers and they are both doubles. I also have a checkbox called Check1. What would the code be such that if either ARW or ARW2 is greater than or equal to 5 then the checkbox is true. Thanks, I apologize for my lack of coding skills

I need to conditional format in 97. I searched some old threads and even downloaded Ken's sample database to see how it works but I dont know VBA enough to make it work on mine. I have a form with a bunch of specs. For example, one field has a number that needs to be between 100 and 200. I...

Excellent! Thanks

I have a database with hundreds of fields that are defined in tables as long integers. Is there any way to easily convert all number fields to doubles? Thanks

I tried creating user level security in Access 97 and followed the advice of the help menu and created a new Workgroup information file in a new location. How and where do I go back to the original default. Now if I delete this new Workgroup information file "WID" all my databases wont open...

ken, thanks again. Do I put this into a new module?

Hey, is there any way in some sort of module or macro to remove the intitial value from every long integer in a table or all tables in a database:(

Thank you :):):) Cant thank the wonderful people of this forum enough. Where do I send a check lol?

I am getting a compile error? when I copy and paste pass = Nz(DLookup("[password]", "tblUsers", "[username]='" & & Me.username & "'"), "") at the marked point. I'm not sure what to do. If you recognize, this code is from someone else you previously helped. I'm just a newbie trying to scrap...

Noticed a prob in my password checkingform. Example, in my tblUsers, I have Username and Password. Lets say one Username is "John", and his Password is "Blue". Another username is "Bob" amd his password is "Red" In my form, if one enters Username = John and Password = Red, it still works. How do...

I did this Forms![Spec Form]!chkapproval = True Forms![Spec Form]!chkapproval.Visible = True Forms![Spec Form]!chkapproval.Locked = True Is there a way to lock the check box permanently once it has been checked by entering the password. Its locked as soon as the person enters the password...

Its located on Spec Form

You ARE Amazing! I cant thank you enough, but if you woudlnt mind can I ask just one tiny more question hopefully. The user enters a password on form "Login". The password is checked against a table "tblUsers" when a command button called "SignIn" is clicked. This then takes me to the form...