Search results for query: *

I have tried two different ways to create a query to run to load an Excel spreadsheet. One gives the Run time error 3061 or asks for a list separator. This is the code: Set RS = DB.OpenRecordset("SELECT * from qryRTRACK_EMP Where" _ & "([SDate] Between #" & Forms![frmReports]![Text0] &...

I hope someone can help. I have tried eveything that is posted here and on other sites. I get the runtime error 462 a lot especially on the LRow line of code. But I have the Ghost Excel which I can't get rid of. Below is a sampling of my code where I use code pointing to an Excel spreadsheet...

I have loaded data from a query into an excel workbook with multiple sheets. The load worked fine. Then I reuse a table with the sheet names to try and access the sheets to hide unused rows. The code errors out on the "Hidden" line of code. I do not close Excel before I run this loop so I did...

I have an Excel spreadsheet already created with Names in column A and then Thursday's date in Column D, Friday's date in Column E, and so on... with a Total Column with formula in Column K, then Rate of Pay in the next column, and calculated Payoll in Column M. I have the data in Access where...

I am currently using MS Access and Visual Basic coding behind. I have a form called Calendar which displays the month with a Cancel button and a Set Date button. When I run the form that uses the calendar, I have a button to call the calendar form. But when I first click the button a completely...

I have a report that prints the employee hours for each day and then sums the hours for the selected period. The Detail section of the report when it reaches the bottom of the report splits with some days on the first page and the rest of the days on the next page. Does anyone know a way to stop...

I looked through the Threads and found bits and pieces of some code for passing parameters to a report but it seems I still don't have it just right. The problem is I am using two textboxes for a Start Date and an End Date and a combo box for employee names. The report should only show the...

I am currently working with Access 2007 on a laptop with Windows XP. I wrote a macro and then converted it into VBA. I have a screen with just buttons on it. Each button performs a VB module. I have tried the Application.Echo False and the DoCmd.Echo False to shut off the action query messages...