Search results

Hello, I'm trying to process some reports, and need to be able to create a recordset from a variable recordset created in my code, and keep getting the following error: The Microsoft Office database engine cannot find the input table or query 'Rs2'. Blah, Blah, Blah. Rs2 is a variable in my...

I have a form with various TextBoxes. The code should convert the form entries into variables, and use the variable values for the DoCmd.RunSQL statement. I've tried typing in the variables with single quotes, and no quotes, but TextBox values don't seem to be passing to the SQL statement. Am...

I've been trying to get this to work, and I'm beginning to think it's impossible. Can anyone tell me why I continue to get: Syntax Error (missing Operator) for this statement? I've checked all field/object names, and nothings mispelled.:confused: Am I not suppose to put all these IIf...

Hello again. I have a small module, that is suppose to send a group of sales reps their monthly reports. I thought I had everything in the right place, but I keep getting the following error: Run-time error '91': Object variable or With block variable not set What does this mean? The code...

I'm having trouble finding the syntax error in my statement. Any help will be greatly appreciated. Set Rs = CurrentDb.OpenRecordset ("SELECT [rptQry-CMvsCYTD-RepGrpCat].SRNum, [rptQry-CMvsCYTD-RepGrpCat].SalesRep FROM [rptQry-CMvsCYTD-RepGrpCat] GROUP BY [rptQry-CMvsCYTD-RepGrpCat].SRNum...

Hello all, I'm back for more help. Any assistance is greatly appreciated. Currently; I have a sales report, that has 10 markets. In the report footer, I have the total numbers (wow, real complex isn't it). I have a small piece of VBA written, that will run the report, and export to PDF each...

I have a form that is called MainMenu. It is basically my switchboard. My problem is; every time I compact the DB, the form expands out. I then resize it to the size it should be. Next compact, form expands out. What I mean by expands out is that it has black white space to the right and...

Hello All, I have a standalone DB (2007) that I typically import, compact, ZIP, and email to several people every morning. This is NOT a frontend/backend DB. Everything is contained within one file (InvoiceAudit...accdb). I have searched far and wide for some code to automate this process...

I currently have a report that consists of ~30 sales reps. The report is opened & exported to PDF in VBA. I am needing to create the same report, but need each rep to have a separate PDF. Can someone give me a loop procedure that I can use to produce the report from a dynamic list? The reps...

I have a monthly report that I export to PDF. Once exported, I distribute them to my partners. My parntners then review the graphs on the report, and forward their comments to be inserted into the final meeting reports. Is it possible to have Access create the report with user input boxes...

Hello All, I am working on an export module, that I can't seem to figure out. My project:' I have a form that has 2 combo boxes, and one "Go" button. Company, VolCat Within the VolCat combo box, I have eight unique items, and an "ALL" item. The ALL items references a "*", so I may grab all...

I need to merge several fields across a table into one field. The table was created from a XtabQry that has several blanks across, that I would like excluded. I found some function code on the net, but can't seem to get it to work. Can someone please provide some assistance?:confused: Here...

I am only a beginner... I have the following code running on a report, and am wondering how I can auto increment the exports (Example: : 001, 002, etc.). Any help is appreciated. Private Sub Report_GotFocus() If Forms!SelectReportType!Combo6 = "Normal" Then MkDir "C:\Documents and...

Hello, I am curious to know how difficult it is to create a access DB, and convert it to HTML for use on an intranet. I have been told that the best way is to create a SQL DB, and write some ASP code to link the HTML file to it. I don't know ASP, nor SQL. I am very intelligent, and have...

Hello All, I am average when it comes to VBA, and I am mostly self taught. What I need to do is automate a daily import process from daily DB exports. Here is what currently happens: I receive daily exports of several different DB grids (3 total). These exports are in CSV format, with...