Search results for query: *

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...

I have a formula: TPUnit=(Units/SumofUnits)*10 The point of the formula is that truck pay can not exceed 10 hours per day even if the labor does. The problem is rounding. It need to round the TPUnit total to a factor of 0 decimals, but in the case where the employee worked 11 hours, it is...

I figured out another avenue. I created a report that tied at the activity code level and one that tied at the phase level and then used an if statement in the code to determine which one opened/ printed based on the form. Thanks for the info anyhow. I really appreciate you guys!!!!!

The issue that makes it so hard is that they have two separate tables they pull the "Activity Code" from. The combination for entry of what they call a job code is: Jobnumber-phase-activitycode" The activity code could come from two separate tables. If the activity code is enter as part of...

The link between my master form and sub form is as follows: (Master) JobNo = (child) TmProjectNo (Master) PhaseNO = (child) TmPhsNo (Master) WorkDate = (child) TmWkDate I need a forth field that also says... If (field from Master) COR <>0 (Y/N) field, then ignore the (child) "ActivityCode"...

To throw in more confusion, I will have multiple employees. I have no idea how to do this. Thanks, Bailey11