Search results

no joy, it gives me the "invalid syntax" error message. can i just make [qty on hand]=[expr2]? if so where?

ok, i'm getting there: Expr1: [quantity checked out]-[quantity returned] Expr2: [qty on hand]-[expr1] now how do i make [qty on hand] save expr2 as it's value?

My database tracks an inventory of Haz-Mat, so even when someone uses all of a material they have to check the container back in. So what I'm trying to figure out is how to make the database do something like this [qty on hand]= [qty on hand]-[[qty checked out]-[qty checked in]] does that...

I actually do need to store it. I am the Hazardous Materials Coordinator for my squadron (I'm in the U.S. Marine Corps), and all of the information is required by the department of defense to be on my check out logs.

i have a combo box that on "after update" should fill in two other text boxes from a table, but I don't know how to seperate the two pieces of code. do i need a ; or : in there? Private Sub Location_AfterUpdate() [Material] = [location].Column(1) [NSN] = [location].Column(2) End Sub

OMG, that was it! I can't believe I overlooked it. Thank you so much. jim

I just realized that it's putting " around 90 after i enter the criteria, and if i take them out, they just come back again. Do I have a setting wrong somewhere?

It's deleting all records now, not just the ones older than 90 day . Should the dateadd function be used? If so, how? thanks again, I'm such a newbie :P

even though i used now() for the date field that that is being queried? should i go back and change it to date()?

i want to set up a query that, when run, deletes all records older than 90 days...I created a delete query, and under my field that is associated with date the criteria is "<now()-90", but it didn't work. did i do something wrong?

Each location has only 1 item assigned to it (I have a seperate form that I use to enter the data for those two fields). In the form I want to use to check out items I have several fields: Name, Date, Item, Location... I want the field for Item to look at what i selected/input into...

it didn't work for me the combobox itself doesn't have both values, it is pulling the data from a table that has both values in 2 fields. The first field is "location" (that is what the combobox is retrieving), the second field is "item", and I want to be able to select a location, and have...

i guess i don't understand. my combo box is named SerialNum, it is getting it's data from a table named Location. Table Location has two fields, location and item. when i select an item on the combo box, i want the corresponding field data to appear in a seperate entry in the form under...

i have several comboboxes, is there a way to turn on an "autocomplete" function? If we have to scroll through 400 items, we might as well type it in. :P

1. How do I put a button on a form that will put =now() into a field? 2. How do I have a field retrieve an entry automaticly when another field's combo box is filled. For instance if someone checks out a tool from location A, I want the nomenclature for that item to fill the appropriate...

that did it! thanks a lot

ok, that worked, but now it only looks at the first "is null", i have several fields i need it to look at and report on if any of them are blank...do i need a seperate query for each of those fields? thanks for the patience

i tried "is null" and "=null" in the criteria, but the report keeps coming back empty. i have the report pulling data from the query. any other thoughts?

i want to print a report that shows me only incomplete data(any field blank). I run a tool check in/out room, and i need to be able to see what items are still out. thanx in advance for the help

is there a way to have a date/time field fill on "click" or "enter" and then remain static? I need to view the form many times, and can't have it change constantly