Search results

After taking a closer look at the IW output, it looks like the SQL is translating the form objects to their values. Therefore; causing the IIF statements to look wrong. I've illustrated an example below. Original SQL segment: "IIf(" & [Forms]![frmDataColl]![txtCustCountry] & "='US' And...

You will have to excuse my ignorance, but I'm still pretty new at this. I thought I was doing the calculations in the code. Do you mean that I should: create variables for each frmDataColl object set variables to frmDataColl values Do the calcs with variables, instead of...

Background: My project is basically a margin calculator for the sales team. Reps make various selections, and input text into frmDataColl. The first part of the module should retrieve 2 frmDataColl values (txtBPNum1, cboItemSKU1), and create a unique ID for SQL. SQL statement should retrieve...

I added a space before the FROM in the statement, and now I get a "Too few parameters". Do the formulas need to be at the end of the SQL? Not sure I understand the debug.print thing you suggested. My code looks like this, and I don't get any out put to the immediate window you refer to...

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

Correct, PDFs don't compress much. Although; my tool exports/emails 6 PDFs per sales rep, and they prefer to receive a single file. I also use this code to Backup one of my other DBs, as you have stated.

The original author responded to my email, and informed me that he has updated the program with the modifications completes. You must redownload his example, and replace your existing modules for it to work. Now my ZIP files contain only the PDFs, instead of having 10 subfolders, and then the...

I went to the authors websiye, and sent him an email requesting some help, but I'm sure he is far to busy to help me. I figured it couldn't hurt. If anyone has any more suggestions, please let me know.

I stand corrected. Didn't even see that.

Is there an error? If so, what is the error? The word "User" may be a reserved word in Access. Try using envUser or something more unique. I've had a similar issue with reserved words before. I'm not a professional by any means, but figured I try to help.

Hello, Does anyone know any switches for this method, that will allow me to eliminate the subfolders from the archive? Any help is appreciated.

Never mind, I had my Loop in the wrong spot. Should have been as follows: Public Sub EmailReports() Dim olapp As Object Dim olns As Object Dim olfolder As Object Dim olitem As Object Dim olattach As Object Dim dbPath As String Dim Rs As DAO.Recordset Dim strRepID As String Dim strRep As...

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 was able to get this to work with my code, but how do I eliminate all the folders it preserves. For example: When I double click the ZIP, it has all the original folders from my Documents & Settings/user/desktop/etc... I would like the ZIP to open up to the files only, not a directory tree...

Thanks guys. My original query was just eliminating null values (which I copied from SQL View), so I didn't have any quotes. When I added the additional criteria and copied from SQL View, Access added the double quotes. Therefore, that's what I pasted in to my VBA window. Is there a reason...

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

Ok, I get it. Thanks a million. You guys are all so helpful, and I appreciate all your help.

I'm not sure what you mean by "pass the report an appropriate openargs value". I'm still new at this, and have only passed field values to my reports. Not sure what an open arguement is. Is this what he means? DoCmd.OpenReport "rpt-Grp", acViewReport, , "ProdGrp = '" & strProdGrp & "'"...

Thanks BL. This appears to be code use for an OnOpen event of the report (me.section). I will be executing my code from a command button on a menu. Here's a better explanation, and some sample code. First; I will process each individual product group without the footer. Then I will process...

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