Search results

I have 2 fields Field1 = Start Date and Time Field 2 has the End Date and Time. How can I calculate the difference between them and display the difference in a field in the total Hours and minutes? jom

ya figured out what its doing but do not know how to fix it. So it would appear that if you use conditional formatting to change the field color based off its value then the code enable / locked will lock is so you can't enter data but the tab control will still go to that field. I really want...

I think I may have figured it out. let me check something.

How did you get it working?

sorry, having trouble with attaching

The code does work as far as stopping a user from entering any data. So I have a box that covers a couple fields that is visible if data from another field makes it visible. So if its visible I want to stop the tab control from going to those fields to avoid what you see in the attachment.

I have tried the (me.field. locked = true) with the me.field.enabled = false and its still allows to field to get focus using the tab

I'm trying to stop a couple fields from being able to tab to based on other field value in a form. I have the following code but this didnt work. Private Sub Step42_GotFocus() If Me.Step42.Locked = True Then Me.step43.SetFocus End If End Sub I then tried this. but it still allowed...

I'm trying to use field valuse to determine certian error msg. I think my code is good when all fields have data but if some are not filled in yet and are Null then I think its causing me trouble. If you look at my code Fields dat100 - dat106 all have data in them the user will enter data in...

Yes I was over thinking it. thank you that helped jon

sorry I will try this now

I'm trying to use setup if the field value is within + or - 0.1 so in the conditional format I have field value is Between (([dat100])-(0.01)) and (([dat100])+(0.01)) Then I have the came this for field value Not Between. The not between turns the field RED the Between should be Blue but no...

Still having problems. This time I do not get errors but the combo box is empty. Just to confirm this is the code I pasted into the Row source of my combobox? SELECT [Tble-PartsLookup].PartID, [Tble-PartsLookup].PartNumber, [Tble-PartsLookup].Description, [Tble-PartsLookup].ProcessKitPart...

Still can't get it working. If I build a query the where statement puts a expr1 in front of the where? When I put the where statement on the row source of the combo I get an error "the record source 'where statement' specified on this form or report does not exist.

So the combo box is on a sub form and the partlist is on the main form

Where do I put this Where statement? In the query? jon

Ok please dont tear me apart to much, I will try my very best to explain what I'm trying to do. I have 3 tables "Tble-PartProductCodeID", Tble-PartsLookup", Tble-ChamberCodes" The Tble-PartProductCodeID hold the PartID and ChamberID. The Tble-PartsLookup holds the Partnumber, description...

You know, I agree. More control I know how to do that. Works great. Thank you for the advice / input

When this query runs I want the popup parameter to open and ask for an ChID number. User enters that number and it deletes that record. I cant figure out what to enter on the criteria line. I have [ChID] and that wipes all records. I tried = [ChID] and it does not run. jim

SOLVED thank you