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...

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...

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...

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...

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:(

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...

Hi everyone. First off, thanks for any help. I have an input box that asks for a password and then checks and locks a checkbox. Its on a bunch of forms that Quality Assurance is going to use as their digital signature to sign off on forms. I asked this yesterday, how can I mask the password...

Hey everyone, I THINK I am almost done with my database, thanks large in part to everyone here. I have one last question (I think). I have a password protected command button that has the user enter a password. If correct password is entered, a check box is marked off and locked, if not, its...

I am making a database for my company that includes build sheets for items we manufacture. During each part of the bulid process (and on every form) there is a textbox where the Quality Assurance officer's name who is overseeing the manufacturing will be entered. Is there a way to have this...

Hello. I am having a bit of a problem. Some of my forms contain textboxes which perform calculations. For example, one textbox performs a calculations such as = [Text10] + [Text20] This textbox takes the values stored in Text10 and Text20 and sums them. However, I want to hide or remove...

I have a form that has a combo box that contains every query in my database. This worked fine until i started having to create cascading queries to return the data I want. How can i populate my combo box with only certain queries in my database. This is the code I was using to put all...

Below is an example of my table "Current Status" Manufacturer ID___SN________Current Location__Status Date______Time A________________1____________Area 1________1/6/2008_______3:15 A________________1____________Area 2________1/7/2008_______2:10 PM A________________1____________Area...

I have a form titled "Run Queries" and on this form I have a combo box "Combobox12" that is populated by all the queries in my database. As of right now, its hard to find the query I want becuase its all in random order. How can I sort these queries in a combobox from A to Z. Thank you in...

I want to have users be able to choose query "x" "y" or "z" from a listbox. Upon selection of query "x" "y" or "z" from the listbox, I want the query to run? I want to run this query from form "RunQueries" Does anyone know how I can do this? Thank you in advance for any suggestions, I...

The boss believes I can help him with access, im not too sure, i dont really even know access. There is a table with fields for each month of the year for 3 years Jan 06 Feb 06 .......Dec 06....Dec 07....Dece08 Can i have a query that prompts the user to enter the month, and then...

Hello. I created two databases on my personal computer at work. One is called "Main" the other is called "Link". As you might have guessed, I linked the tables from "Link" to "Main" and imported the forms that were in Link into Main. On the opening page of Main, users click either a button...