Search results

I need help with this code. I have an excel worksheet that I will import into an access table. The range to be imported will change with each sheet. I'm 90% of the way there, I just need help getting across the finish line. My problem is this: the code below is supposed to find the last row with...

That worked perfectly. Thank you!

I can't seem to make it work. Here's what I did and I'm getting an error message. Private Sub cmdSpendDOMPrint_Click() DoCmd.Close Dim db As DAO.Database Dim rst As DAO.Recordset Dim qdf As QueryDef Dim sBasePath As String Dim sPath As String sBasePath = "Z:\Utilities\Real Estate Database...

Unfortunately the DB is too big to post and contains data that my employer considers secret. Basically the code above runs from a button. It pulls 2 reports at the same time. The 1st report is Summary graphs for each District Manager. The 2nd report is the granular data for each property...

The whole thing is designed to allow me to run a report based on a query that takes an input from a combo box, then chop that up and save it as a pdf. If I don't put an input in the combo box that the full report generates. If there is a way to do this, where nothing previews and the report just...

Pbaldy, Thank you very much for your help previously on this. The code has been working fine since the last time I posted in this thread. Recently I tried to amend this code to save two reports at the same time. I must not have coded something correct, because I get stuck in an infinite...

To everyone who might read this in the future. After all the help in this post, I felt it would be proper to post the whole code. This is now a modification of the code on the allen browne website. It will check the files in a folder and load them into a table, but will also remove any...

That worked perfectly. Thank you sooooo much! I was beating my head against a wall and you kept me from being a bloody mess.

:banghead:So I've been trying to get the DCount to work for the last 3 hours or so and I can't figure it out. Not matter which way I try it, it doesn't prevent the code from uploading duplicate files. Is there a simpler way to do this thanthe Allanbrowne code? I really don't care about listing...

The solution makes sense in theory. When I implemented it though, it appears that the dcount is not preventing the the duplicate files from being loaded into the table. Is there something in the Dcount that I need specify that I'm not? All I did was copy and paste your solution above, so I'm not...

Eventually I will connect this table to a query in order to generate a list box on a form. The query will link the files in this table with their "master records" in a different table. Because of this I can't delete the records each time. In the long run, the query based on this table will power...

So I'm attempting to do something I'm not really sure how to accomplish. Essentially I'm adding file names from a folder to a table using the code found here: http://www.allenbrowne.com/ser-59alt.html In this code, I need it to check against the table for duplicates before adding records and...

I don't think that's it. I specified a location that I know has records attached to it and it didn't work. So I saved the code in a word document, deleted the code from access, closed and saved, reopened and pasted the code and it started working again. It's all very odd. I'd hate to have to do...

Last question for a while... I promise:p. At random intervals I get an error 2501 (OpenReport Action was cancelled) Why does this error occur every so often?

So I have a new question. I've gotten this code to work and I have several different iterations that save reports in their own locations. In addition, this code also emails the report to the email linked to the record. The problem I'm running into is that the email opens up in a draft window in...

Thanks foe your help!

I don't know what happened, but as soon as I put the DoCmd.Close in, everything runs perfect. I don't know about referencing to a single ID, but here's the code.

Ok, so I've applied the changes you recommended and it does work... kind of. It will open and it will save individual pdf files (yay!) However, each file is the same record. Below is the new code and from what I see there are two potential problems. 1. The recordset is not moving to the next...

10-4. I'll try it out tonight when I get home. What I'm trying to do is a modified version of the code on page 2 of this thread. http://www.access-programmers.co.uk/forums/showthread.php?t=206372&highlight=outputto I wouldn't have started a new thread, but the last reply on that was so long...

Ok, I fixed the syntax error and got the code above to work. It opened, exported, and then closed the file. However, It exported one big PDF file. I need it to open the big pdf file, read it, and separate the big pdf file automatically into smaller pdfs by location.