Recent content by pmullan

Hello Everyone. I have been working on a Form / Subform issue. Scenario is as follows: I have a main form called "frmShiftSummary". I am working on placing 3 sub forms into this main form so that the techs working their shift can obtain a summarized view of what transpired during the shift...

Hey Arnelgp, I want to thank you for all your help. I used your code you posted earlier along with some modifications that I made and I now have the Form Load and Form Close modules working. I will look at the new code you send and see if I can put any of it into action. Thanks again. Here...

Arnelgp, Thank you for your advise and the code you provided. I will give it a try and let everyone know how it works out. Patrick

Mark, This table holds the following information; Day, Date & Time that the tech signs in. There are two techs per shift so there are two combo boxes, one for each tech and then there is a combo box for the shift. When the form loads, the day, date & time are preloaded. Then one of the techs...

Markk, Hi, the table I am using is called tblShift. There are 6 columns titled: ShiftDay, ShiftDate, ShiftTime, Shift, TechIIEmp, TechIIEmp. Since each shift is 12 hours, there should be 2 records per day. I am basing my code on the ShiftDate column using the start and end times of each...

Hi Gasman, My apologies, but you have me confused as to what you are saying. I attached the Form load module to this post with the code. Please review it. When the form loads, it does a check back to the tblShift table to see if any records exist (using dcount with the criteria being the...

Hello Everyone, I have a situation where I am needing to create a couple of Constants to use in my code. I need to create a "Dayshift" and a "Nightshift" constant (one each). Dayshift = Current Date from 6:00 am until current date at 5:59 pm. Nighshift = Current Date from 6:00 pm until the...

Thank you for you help! It is much appreciated.

Greetings Everyone, I want to thank everyone for their input. I do have a question though. In my code when I debug it (I set up Watches for the variables "myDate & myTime". They do show only the date (9/27/2017) or (10:15:00 AM). When Missinglinq mentioned what the Access gnomes do...

Hello Everyone, I need some help with the following code. The "IF ... Then" statement does not work. I set the time in the myTime variable to 8:15 PM and when I step through the code, it just skips over this section straight to the End IF line. I believe the code is correct. Please advise...

Hello ARNEIGP, Thank you for your input. I appreciate your help. I attempted to use your code. Unfortunately, it errors out at the "docmd.GoToRecord acActiveDataObject, , acNewRec" line. I get the "Run-Time error '2046'; The command or action 'GoToRecord' isn't available now. Any ideas...

Pat, unfortunately, after the splash screen, the main form loads and this is where the user selects the shift being worked and then populates the two tech fields and then moves on to the command buttons for whatever needs to be done. When the Main form loads, I have to check the Shift Table...

Thanks for the tip about the column header. I will change it tomorrow at work. I have been working with Recordset method. I am trying to do something like an If... Then... Else statement. If tblShift.datefield = now then main form will load the record in appropriate form fields else set...

Hi Everyone, I have been working on a Shift Turnover DB. When the Main form loads, I need to search "tblShift" to see if a record with the current date and shift type exist. If the record exist, it needs to load it in my Main Form. The tblShift fields are titled "Date" and "Shift". I am...

Hello All. I need help with correctly using the mousemove events without getting an error. I have attached a Word document explaining what I need to do and would appreciate the help. Thank you, Patrick:banghead: