Search results

very good part on the space mention....and thank you so much for the help

i look up a light bulb it opens a form. on that form i hit a button to get more info on that same lamp...but i get the error SYNTAX ERROR (MISSING OPERATOR) IN QUERY EXPRESSION 'LAMP ID=95' Here is the code i am using Private Sub AddDeleteSuppliers_Click() On Error GoTo...

never mind all worked wonderful!!!! thanks

I have a form whos control source is BULB MASTER TABLE. When I am viewing a specific bulb I want to hit a button and view a report on the that same specific bulb. The reports control source is also THE BULB MASTER TABLE. Heres the code im using on the form button to load the report…the problem I...

I have a querry that totals all my light bulb orders. Every month I do an inventory of whats on the shelf…(keep in mind that number doesn’t need to be stored it is just inputed on a form) I want to take that number (we will call it shelf number) and lets give it a value of 50…can I subtract...

If I had 2 master tables…the light bulb table (lamp name, instock now) and order table (lamp and amount and complete[yes/no]). What would be the best way to accomplish when the user checks order complete then the database takes [amount ordered]+[instock now] but if the user un-selects [complete]...

ok...that sounds great...i have a problem still.... relamp date field is 12/1/09 expectency field is 24 the querry is thinking expectency is 24 days...how can it be months

if i have a field called "relamp date" and another field "expectency" i need to write an after update code so when the user inputs 8/17/09 into the "relamp date" and the expectancy field is set for 24 (which means 24 months) i need 8/17/11 to automaticaly be put in the "next relamp" field can...

compile error: expected end sub

Private Sub COMPLETE_AfterUpdate() If Me.COMPLETE Then Me.[DATE_ELEC_LUMA_FIX] = Date Else Me.[DATE_ELEC_LUMA_FIX] = Null End If i tried this and its giving me errors

so if the database (which is 50mb) is on the network drive it runs slow...if i run it on the pc i am using it runs fine...any suggestions...side note it runs the same slow speed on a thumb drive

i have a combo box and when the user checks it i want todays date to appear in another field. i wrote the following expression in the "on click" field of the property for the combo box iif([complete]=true,[date completed]=date()) this doesnt work can you tell me why

what would i add if i wanted the date removed if unchecked?

i want to create an event procedure when a box is clicked but have had no luck...something like if [relamped] is true then [date relamped]=date() can someone give me a code for this

if [complete] is true then date() whats wrong

how do you create a query that will select a certain field and all its records and put those values in another field in the same query. THEN (and this might be another query) i want to put todays date in the date field of every record in this query.

i want to have a report that prints up all the lights in the kitchen on the first page and then the diagram on the second. i dont want to bog the DB down by having 30+ 8x11 BMP pictures. so i thought if all the pictures were in a folder on the network or another DB it would help...can i creat a...

if i wanted a button to represent a value so when i pressed a certain one it would use that value as an id used to combinde a report. example i have 100 different locations in a building which are each represented by an id...i have a form with the floor plan and then place invisble buttons...

i have a form that tells me all the lights used in 1 area when i input a record some of the data will be new (the type of light) but one field will be the same (the area im documenting). what is the code or expresion and/or event

Has Any One Seen A Template For This... All My Equipment Is Listed In A Table I Want The User To Be Able Select Numerous Peices Of Equipmet And The Quanity And The Data Is Saved In A Seperate Table