Search results

Using Office 365, I have an Access database that generates an email. Currently it loops through a recordset to determine if any records are greater than 30 minutes in duration. If they are, they appear in red font in an HTML table in the body of the email, if not, then black. The database is...

Hello, I am using Office 365 and am trying to create an email from my Access database in HTML using two linked queries. The email generated looks like this: But my preference is to look like this with each CM following after each issue: Below is my code... can anyone point me in the right...

This one has me stumped. I am using Access 2016 in Office 365. I have a database where a user has an input form to collect data and, if they wish, add a picture to the record. This works just fine. The user can then send an HTML email of the record out with the picture embedded. This I got...

I am hoping someone can get me over a hurdle. I have a workbook with a dozen worksheets and each worksheet contains an image and several textboxes. I need to be able to loop through each worksheet in the workbook to find specific text in a textbox and once found, change the background color to...

Good afternoon, I am working in Access 2016 and I am trying to build a query which will return a week number, starting at 1 between two dates. So I do not want the standard or ISO Week number. If I choose a date range between 08/01/2018 and 02/28/2019, I want it to number from week 1 to week...

Hello All! I am hoping you can help me with a looping / querydef problem. I am trying to send an email to each supervisor who has an outstanding follow-up on an audit based on the results from this query. I am using Access and Outlook 2016. SELECT Audit.GroupID, Audit.TMName, Audit.Process...

I have been searching for an answer and have had no luck. I am using Access 2016 and I am trying to build an aggregate query that will pull results based on two scenarios. I can get one to work, but not the other and I don't know where else to look or try. I have a table that stores audit...

Good morning, I am using Office 2016 and have several databases that I have used an auto-close method if idle based on this post: http://www.utteraccess.com/forum/TimeOut-Forceoff-re-edit-t672964.html When I open these databases, I have a main form and then a Hidden Security form that...

Good day all! I am hoping someone can help me out with the following problem I can't seem to resolve. I am using Access 2016 where I have a form with a combobox that contains all of the jobs in our plant as it's Row source. The table, Jobs, contains the following fields: JobID, JobName and...

Good afternoon, I am struggling with this one... I am trying to create a query to support a subreport and am drawing a complete blank. All of the data is contained in one table called "CheatSheet"... The table contains purchasing quotes for supplies. We have created a report whereby the main...

I have been trying to figure this one out for several days and I am no further ahead. I am look for help in pointing me in the right direction. In Access 2010, I have a table with employee information (employee ID, Name, area) and I have a table with jobs (job ID, job name and area). I have...

I have been reading until my eyes are blurry and I can't see what I have missed on this... I am using Access 2010 and trying to get the following statement to work in VBA: strSQL = "SELECT * FROM qryByTimeEmail" & _ ' " WHERE qryByTimeEmail.ShiftDate = Between #" &...

I have been trying to figure this one out all afternoon and I'm getting nowhere fast. I am running Access 2010 and I am trying to create a crosstab query that will populate a form. I have a table of employee names with their corresponding group name. I also have a table that lists all the job...

Hoping someone can help me out with this one. I am using Access 2010 and trying to create a query to show the last records for 12 unique foreign keys in a table. I am tracking sealer inventory for 12 pumps in a shop. Each pump can be changed multiple times in a week. I need a query that...

I am using Access 2010 and trying to create a query to count records by hour. The fields in the table include: EnterDate, EnterTime, ExitTime, Type I need to count the number of vehicles that enter and exit per hour on a given day and show by type. My SQL is as follows: SELECT...

I am trying to find a way to count unique values in non adjoining columns in Excel 2010. I have 8 columns (AF, AN, AV, BD, BL, BT, CB, CJ) containing employee IDs and I want to be able to count only the unique values across all 8 columns. Any thoughts / suggestions?

I am using Access 2010 and for the life of me can't see why I am getting this error message. I am using the following to filter a subform from my main form: Dim rs As DAO.Recordset Dim frm As Form Set frm = subfrmCharityDetail.Form Set rs = frm.RecordsetClone...

I am hoping someone can point me in the right direction as I have had no luck searching for an answer to this.... I am using Access 2010 and I have a subform that contains a picture control. The image in the picture control is added to the form as follows: Dim a a =...

I am hoping someone can help me out here.... I am trying to write an append query to track employee attendance. I have a table with the EmployeeInfo and another table where I am tracking Attendance records by date. I tried and was successful with this query: INSERT INTO Attendance (...

Hello, I need some advice / critique on some code I have written that opens a form. I wrote it so that if there is a current record (i.e. same date and shift) then to go to that record. However, if there is no record, then go to a new record. It seemed to be working fine for the past two...