Search results

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

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

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 am attempting to create a routine to do the following: 1) Create a temporary table with records that match user entered criteria from a form 2) Insert records into a table that includes some data from this temporary table and some data from an existing employee table I am reasonably new to...