Search results

I don't know how to do it, I just want when user enter data, and want to verify that all the numbers are correctly enter. What I was trying to make query and add button in the form when user finishes data entry, hit that button and enter Date, Product Code and Table number the query bring the...

I use the following formula but its not working Sum(IIf([Table]=[table_number] And ([Date]=[Date]AND([Product]=[Product_ID],[Lbs_produce],0))

How will I make a IIF formula with sum if 3 conditions are are true. I am trying to make a query which sum the Lbs Produce if date, Product Id and location met. Thanks in Advance

Thanks for reply, the data in tblemployee are as follow Employee ID Last Name First Name Sizer ID 123 Smith John 1 tblProduct Product Code Description Rate 5011 Chunks 0.10 and...

Any help guys

Hi guys, I have been away for Access for a long time and having issue with making a query. I have 3 tables. "tablEmployee" has employee ID, first name, last name and sizer ID. "tblproduct" has product ID, Description and rate. I made a new table called tbldata which has date, product code...

Yes Sir, I want to use this database till certain period e.g. 03/15/12, and after this date, when someone try to open the file, its delete the file or corrupt the data. I used a following VBA code for excel, and tested it works for excel I want same kind of code which works for Access...

I am new in Acces and do not know much about VBA, will you please explain what is Load event and where i will test the above code?

Is there any VBA code which delete all tabel, or run delete query after certain period of time? any help will be greatly appreiciated