Search results

I am using 2007. The problem doesn't seem to be happening since I uploaded it to the shared drive at my job. I will keep you posted as to what happens moving forward.

Here are the relevant properties. AutoCenter = Yes AutoResize = No FitToScreee = No BorderStyle = Sizable (Have tried Thin with no success also) All buttons have been disabled (Close, Min, Max, etc.) Moveable = No

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

With all of the messages flying around, I'm not sure which example this line pertains to. Hello, Thanks for following up with me. I actually figured it out a couple of hours ago, and just haven't posted back yet. I seem to always look into the hard things before looking at the obvious...

Ok, I have exported/imported all of the modules from the ZIP DB into my DB, and added all of the form code from the VBA window for ZIP DB to my DB. Here is the code for my form. Option Compare Database Private Sub cmdEmail_Click() Me.lblMsg.Visible = True DoEvents If...

Ok, I tried Private Sub cmdEmail_Click() Dim dbPath As String Dim dbname As String Dim zipname As String dbPath = Application.CurrentProject.Path dbname = dbPath & "\InvoiceAudit-Ver1(3).accdb" zipname = dbPath & "\InvoiceAudit-Ver1(3).zip" If MakeZip(dbname, zipname) = False Then...

Hello Mike375, Thanks for the input, and it works perfectly. Although; I prefer not to have the extra form. Is it possible to just use the MakeZip command without the form? I tried to use the following, but to no avail. It results into a syntax error on the MakeZip line. Private Sub...

jal, I added the Jet Ref, and your code, and get the following: Compile Error: User-defined type not defined. The only thing I changed was the file extension from mdb to accdb. Any ideas why this is? I will try some of the other suggestions in the meantime.

Hello, Thanks for your reply, but that method can't be performed on an open DB. http://www.blueclaw-db.com/compactrepair.htm

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 finally go my code to work, but now I've added an additional variable so I can name the PDFs after their respective RepName. In the following code, the strRep variable could have a variety of illegal characters in the result. Examples: US JAN/SAN - TODD SPENCER NSM US NAT'L ACCT - NATHAN...

I have tried everything that I can think of, but can't figure this one out. With this code, the process runs, and exports the separate PDFs, but no data. Private Sub Command50_Click_WorksWithNoResults() Dim Rs As DAO.Recordset Dim strRep As String Dim strRepID As String Set Rs =...

Thanks for the response, and it did help some. Currently the process runs without errors, creates the seperate files per Rep, but the reports are blank. The headers only appear. From what I can tell, it doesn't appear to be applying the criteria to the report. Here's my current code...

Ok. I gave it a try, but must be doing something wrong. I've attahced a screenshot, and explained what i did below. The field contains the "&" character within the reps name. Could this be the problem? I setup a test table using the rptQry, so the rptQry & tbl show same results. I used the...

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

Hello, Thanks for your response, and I believe you are correct. Basically I was trying to create a report that had ~15 user input boxes (with various charts/graphs), and export to PDF for the director's to review. I wanted the user input boxes to carry over to Adobe, so the director's could...

Can anyone help me with this, or am I in uncharted territory?

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, I have not tried your new suggestion, for my code has changed many times since your first suggestion was originally posted. I currently have my tool working, and will have to modify your code to work with the current code that I have. I have posted a 2003 DB for your review.

Hello, Here's a sample of my DB. I stripped out everything not related to this procedure, and disabled the Print Preview button that I have on one of my form because it runs off a query not included in the sample.