Recent content by bailey11

I don't want to disable the "X" from closing the database, but I do want the user to have a chance to say yes or no if they click on it.

I have several people who accidentally click the msaccess program close button "X". Is there a way to pop up a yes no warning before closing down access? Thanks, Bailey11

You are GOD SENT!!!!!!! I have been self teaching this stuff and I can't tell you how frustrating it has been and how much I appreciate you guys. THANK YOU!!! THANK YOU!!!!!!!!

I have the form forcing them to enter all fields. And no, Description is not EQHours, I have Me.Units as EqHours. (at the end of the 2nd line of values) Do I not have that line formatted correctly? Thanks, Bailey11

The added single quote. Yes, EquipNo is a text field. It seems to be the one causing me the most trouble. I designed a similar form, but the leading field was a numeric field and everything went smoothly, but this I can't seem to get correct.

Sorry for the delay in reply. I obviously can not figure out how to tell it to print to MY printer only. I have been trying for days and still get multiple pages on other printers. Can you help me with the code? Thanks, Bailey11

Thanks to all, I can get past that now.

I took that out, but it still doesn't write to the table.

TABLE TO WRITE TO: TblTimeEquip FIELDS IN TABLE: EquipNo (Text field) JobNumberEq (Text Field) ActivityCodeEQ (Text Field) EQDate (Date Field) PhaseEQ (Text Field) EQHours (Number Field) EqComments (Text Feild) TruckYNEQ (Text Field) If Me.Units >= 0.01 Then SQL = "INSERT INTO tbltimeequip...

I have a form for equipment time entry that I am having a problem with. I can't get past this code: Set rs = DB.OpenRecordset("SELECT * FROM tblequipcat WHERE EquipmentNo = " & Me.EquipIDTE, dbOpenForwardOnly) "tblEquipCat" hold the master files for the equipment we use. "EquipmentNo" is...

Sorry, I couldn't reply ealier. We are in the pipeline industry and the normal workday is 10 hours I already have code that puts in the truck pay hours as time is entered. As I have thought about it, all I need is code on the form exit that would put in the remainder if the employee didn't...

I have written code that takes the work time entered and distributes 10 hours of truck pay based on the hours entered. If they get truckpay it is always 10 per day no matter how many hours worked. i.e., Job 1, Employee 1, ActivityCode "09000", 3 hours worked, the code puts 3 hours truckpay to...

I ahve built a database that is used in field operations and I have the margins in page setup set (obviously to my printer) so when we deploy the database to users using different printers, it pushes what is one page (printout is actually a SNP file) on mine to two pages on theirs. Is there...

THe result would be a number with no decimals, the total for the day not to exceed 10. 3,3,4 or 2,2,6 or so

Sorry about that. THe units are the number of hours the employee has worked on a particular job on a particular day. The SumofUnits is the sum of all the hours he has worked for a day. In the case above, Joe blow worked 3.00 hours on job 1, 3.00 hours on job 2.00 & 5 hours on job 3 If an...