Search results

LETS SAY I HAVE THREE PART NUMBERS FOR DIFFERENT MANUFACTORS. IF THE USER SELECTS GE MANUFACTOR THEN THE GE PART NUMBER SHOULD BE LISTED IN PART NUMBER. I GET ERRORS WITH THIS EXPRESSION IN MY QUERRY Expr1: IIf([MANUFACTOR SENT]="GENERAL ELECTRIC",[PART NUMBER]=[GE PART #]) HELP

i would like to create a button on a form that will open another form and a specific record...like record 19...if u tell me a code....i could write in record 19....

i would like to create a lable on a form where the user can type in a code and pull up information about that code. the problem is the code is not a record on the table that the form was created from....any help

what im making is a gui. i have a picture and on top of that transperent buttons a user selects a room in the house and the form with the room info on it pops up.

More Help That Would Be 118 Queries And 118 Forms. What I Need To Do Is Find A Way When I Press A Command Button That It Opens One Form At Record 100....when I Press Another Command Button It Opens The Same Form But Record 50....and So On

this will sound easy....i want to create a command button that opens a specific record in a form....how do i accomplish that.

I want to create a form where the user selects various options…these results find or create a record For example meeting room, 200, downlight, east…if the user selects those options the database either needs to find the record that fits or creates a new one….. Sorry this sounds stupid

i probably want to create a upddate querry or maybe some code but... i have a light bulb and i keep 300 on hand i just ordered 300 more when i check the box that the order is complete i need the "bulb on hand" feild to update to 600....please help

When The User Checks The Option Box True I Want Todays Date To Display In The Date Feild.....any Help Or Do U Need More Info

How Come When I Change The Page Setup To Landscape In A Querrie.. Then Hit File Save...when I Close And Reopen This Querrie And Go To Print Preview It Is Still In Portrait Mode

How do I fix this to specify each table Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note]) Description: [level] [level table] & " " & [room] [room table] DOESNT WORK HELP

if i imported every table to the querie How do I fix this to specify each table Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note])

How do I fix this to specify each table Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note])

i have a master table with various lookup feilds. i want to create a querie that creates a text expression feild called description and it is based on the info provided in the lookup feild. problem is when i create this querie from the location master it provides the id's from the lookup colums...

i have a master table with various lookup feilds. i want to create a querie that creates a text expression feild called description and it is based on the info provided in the lookup feild. problem is when i create this querie from the location master it provides the id's from the lookup colums...

if check box 1 is true then i want to allow the user to select true or false in check box 2. if check box 1 is false the user cant select check box 2 how do i do this:rolleyes:

lets say i have a table that lists every light bulb in the building. i also have a order table with date and amount of bulbs ordered fields and of corse one that links to the specific bulb what i want to do is create a report that lists all bulbs and accumalates the total amounts ordered what...

i have a report that lists all the light bulbs we use and the amounts purchased in 03,04 and 2005...however the report only shows bulbs purchased in all 3 years...how can i have the report place a zero in the year none were purchased.....for example in 05 the most bulbs were purchased the report...