Search results

I have the below code (borrowed) that reformats a query that was exported to excel. I need to define a range that would be all the data on the spreadsheet. Each output of this query changes so it needs to find the range. Can anyone help me adjust my Set of "myrange1" since all the definitions I...

Hello everyone, I have tried using a lot of different people's codes to complete this but I am not too familiar with looping. I have a form where once the user puts the data parameters in the combobox is populated with a list of dental office names. After the user selects the dental...

Hello everyone, I have the below code I recently snagged from a posting. I thought it was working until I saw that on cases where the start time , for example, was 05/06/2015 5:09:00 PM and the end datetime was 5/7/2015 8:15:34 AM if gave a value of 00:08:00 instead of 00:15:34. Public...

Currently in an access database I have a query that runs off of a parameter form. The parameter form collects the [Start Date], [End Date] & [Office Name]. Once a user enters the [Start Date] & [End Date], the [Office Name] combo box auto populates with list of Office Names that were entered...

Hello everyone, I have this query: INSERT INTO [DN11 (AP) County Counts] ( [Data Month], [Data Year], State, County, [General Dentist], Endodontist, Orthodontist, [Oral Surgeon], [Pediatric Dentist], Periodontist, Prosthodontist, [Total Providers] ) IN '\\cifs04\NetworkDevelopment\Provider...

Hello all, I have a table which has each claim as a single record. A client wishes us to provide the data in a format that lists the each procedure on its own line. I have attached a highlevel example of what the data currently looks like and what the query results should look like. So I...

Hello everyone, I have been searching this forum as well as several others for a solution to my problem. I have always used parameter forms for inputing query/report criteria. However, they have always been for one query or report. However, all searches I have done for trying to use one...

I have a query pulling from two queries. I have to be able to pull all the active employee names from the first query and even if they do not have any data for that day in the second query. My query works fine until I add a date parameter that is directed at the second query. When i tell it to...