Search results

Thanks all who have given suggestions. I've decided to use a seperate subform for each hour. It's more forms to manage but I have better control over what becomes active during each hour without regard for which tab the form is on. In cases where the forms are virtually identical, I just need to...

OK, I see that a flag is just a variable that is set in VBA. Can I set a variable that changes with the OnClick event on the individual tabs? I could then use that in the subform to determine which tab was clicked as long as the variable changes before the subform opens.

Flags are a new concept for me. I don't see it as a property on a form at all. I'll have to research how to use them.

Thanks Simon, The SourceObject is the same for all the tabs. Each tab simply opens a different record (either a new record if there isn't already one for that hour or an existing record if that hour has been filled out). I've got that part working OK but I'm having trouble making sure the user...

I may have found a solution but I'm not sure if it is possible or how to do it. To repeat the issue: I have a tab control with subforms on each tab. Each tab represents an hour during a shift (Hour 1, Hour 2, etc). To simplify things I'll just say that the subforms are the same on all tabs...

Thanks Spikepl, I had high hopes for that but it still doesn't work. I tried it in the OnChange event of the tab control and also in the OnClick event for the tabs. I've got a timed refresh that runs every 15 seconds. The initial tab that opens has the correct tab number in the form but when I...

I have a tab control with 8 tabs, one for each hour in a shift. There is a subform on each tab. Some of the subforms are re-used since they are identical to each other (there is a 1,5 form, a 3,7 form and a 2,4,6,8, form). I'm looking for a way for the subform to know which tab it is in when it...

I think I've solved the problem. I think it actually works when using "Locked" instead of disabled. Just to be sure I'm putting BOTH into my loop: Dim ctl As Control For Each ctl In Controls If ctl.Tag = "ControlGroup" Then ctl.Enabled = False ctl.Locked =...

I've got some forms that I've set to lock controls based on an added tag. I have a loop that goes through the entire form and disables (controlname.enabled = false) or locks (controlname.locked =true) all the controls with that tag. This appears to work fine when the form is on a blank record...

Thanks Namliam, sorry I forgot to attribute the suggestion to you... Yes, I want to "pretend" the date is the next day when they are entering records between 11 PM and 12 AM. The users have been complaining about this issue for a while. They consider any time after 11 PM to be the next day on...

I'm creating a new thread similar to one of the same title that is a bit old. I have a date/time field on a form that has the default set to "=now()" which puts in the system date and time. I need to change it so that the date changes to the next day any time after 11:00 PM (instead of...

I have a similar problem. I have a date/time field on a form that has the default set to "=now()" which puts in the system date and time. I need to change it so that the date changes to the next day any time after 11:00 PM (instead of midnight). This is because our third shift starts their day...

I didn't figure out why the original solution doesn't work but I did come up with a way that does work. Now I have 2 queries. The first query (testCompressorRoundQ) finds the latest date/time for each equipment number: SELECT NorthCompressorRoundT.CompressorID AS ID...

Well, I thought it worked until I looked at the results a little more closely. The machine names are correct, the dates are the latest dates but for some reason the CompressorIntegrity field is incorrect. I've never seen this before because the actual record in the table doesn't correspond with...

That's exactly what I needed! I've always had trouble with the totals thing in Access. I should be able to customize this from here though. Thanks a bunch!

Thanks for the quick reply. What I need is a way to get MULTIPLE maximums (one for each machine number) from the same table of data. I need it to return the newest record for Machine 1 AND the newest record for Machine 2 and so on.

I have a table that contains readings from several pieces of equipment as well as the status of each one. Each record has a timestamp, equipment number, status, etc. What I want is to create a query that will return the latest record for each equipment number. Simplified example table...

I've been working on the same thing and I just figured it out on my own. It's a miracle because I don't really know what I'm doing. This has worked on my test tables so far so your mileage may vary. I haven't tested it fully yet. I have two test databases (KeepUp1 and KeepUp2) with a single...

I have a similar situation. I wondered if I should have started a seperate thread instead of replying to this one??? I have several tables that will be updated by operators using forms. When I first started working on this database I noticed I was inadvertently creating lots of blank records...

I came across this in a search. Even though it is over a year old it still did exactly what I needed! Thanks! Steve