Hello experts,
I'm attempting to update a record in a table by running a quick SQL statement behind a button a user clicks on a form. For some reason, I'm getting a "syntax error in criteria expression" error on the below. It looks perfectly normal to me and I am stumped as to why I'm getting...
Here's screen shots, so you can see what I'm referencing. Shot #1 is the whole team; shot#2 is the single employee. You can see the math works fine when the query is drilled down to one specific record. Hope this helps clarify what I'm up against :)
There are 300 employees in the table. That number is just an offhand number I typed as an example :) What is really boiling my noodle is the fact that if I run just a single employee, the math works; if I pull all records, that same employee shows a huge negative number.
Thank you, but that won't work. I have days where the supervisor may be out, but the employee is in. The variable can't be zero in this case, because there are 8 hours in that day when the employee does not have a supervisor present (there is no overlap that day). Hope that makes sense.
Hello experts:
I have a report I'm creating that calculates the overlap between an employee's schedule and their supervisor.
I have the report grouped by supervisor in a group header and the employee info in a detail section. I'm using VBA to calculate the overlap on the FORMAT event of the...
Hello experts:
I have a user form on which I need to provide a spot for pasting a screen shot.
I am aware of the process of allowing attachments of a saved file to a form connected to the table; however I am wondering if there is a method that allows the user to copy directly from the...
I tried this in both the header and the footer section of the group, but it does not work. txtStatus is not in the detail section, because it would repeat for every record in that section, and I only want it to appear once for each employee.
This looks promising, but I'm getting a "The expression you entered has a function containing the wrong number of arguments" error when attempting to set this as the control source for my unbound field....
Hello experts.
I have a report that I am trying to create that shows someone's work status on a weekly basis. It is grouped by employee and the query pulls all records in the associated table based on a date range entered by the user.
I have two text boxes in the group footer that display a...
I actually changed it to be a text box, trying to solve this issue. It doesn't seem to have resolved the problem. There is a DLookup behind the scenes that populates this text box when the employee# is chosen from the dropdown.
The data type on the field is Number, so I set the format of this...
Sure, here it is.
INSERT INTO tblLeaveChart ( LeaveDate, EmployeeNumber, [Team Number], Division, TypeofLeave, Hours, SubmittedBy, LeaveForm )
SELECT tblCWSRecordsTEMP.LeaveDate, [Forms]![frmEnterCompressedFullYear]![comboEmpNo] AS EmployeeNumber...
That works well up to one point. Some screen shots attached. Snip 1 is the user form. Snip2 is the records that are pulled in the append query.
For some reason, the "Team Number" info from the user form is not making it into my query results. Nothing jumps out at me that might be causing...
Maybe we can get at this another way.
I've got my temporary table which has all the dates this employee will be out of the office. That part is already done, I don't need help with it.
What I need to figure out is how to take each date in this table and append it to another table along with...