Recent content by DB_Queen

  1. DB_Queen

    Syntax Error in SQL expression

    As an update, changing the double quotes to single did the trick. Thank you :)
  2. DB_Queen

    Syntax Error in SQL expression

    Hi, Here is the specific message I'm getting. It has a problem with the record ID I'm passing.
  3. DB_Queen

    Syntax Error in SQL expression

    Hi, I have already tried that, and nothing jumped out at me as an obvious issue 🤷‍♀️
  4. DB_Queen

    Syntax Error in SQL expression

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

    Calculating Work Hours Overlap

    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 :)
  6. DB_Queen

    Calculating Work Hours Overlap

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

    Calculating Work Hours Overlap

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

    Calculating Work Hours Overlap

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

    Pasting Screen Shot Into Form?

    Ah, too bad. Thank you for your prompt reply! :)
  10. DB_Queen

    Pasting Screen Shot Into Form?

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

    Conditional Formatting Based On Multiple Possible Conditions

    Update - when I put the report in Print Preview, this did work! Thank you so much!
  12. DB_Queen

    Conditional Formatting Based On Multiple Possible Conditions

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

    Conditional Formatting Based On Multiple Possible Conditions

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

    Conditional Formatting Based On Multiple Possible Conditions

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

    Inserting Records Into Table from two unrelated tables

    FOUND IT! This is what I put in: TeamNumber: CInt([Forms]![frmEnterCompressedFullYear]![txtTeamNo]) and now it shows up. Google for the win :)
Top Bottom