Search results

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

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

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

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:

Hello Everyone, I am currently stuck in a predicament and need help. I am a new acess/vba programmer and I am currently working on a Shift Turnover DB for work. I am at the part where I am using a form (tied to a "Tasks" table via VBA). This form has two sections; 1st section is where the...

I am working on a project for work that involves Service Tickets and Shift Changes. I have created a Shift Turnover Database using Access 2013. I have numerous forms along with tables and queries thus far. My challenge is when I update the tables with information from the forms. It seems...

Hello, I am just getting started with Access 2013 for work purposes. I am not that skilled in the programming arena. I am more comfortable with Networking. However, I have tinkered with programming in the past. I have been taking some online courses for Access 2013 / 2016 and VBA as well...