Recent content by VictorAtWork

Thank you for the snippet. We will try implementing it next week and will let everyone know the results.

Hello, We have tried several of the forum replies to no avail with outlook. Here is our scenario: We provide certificates of completion to attendees of a classroom course. We print these certificates using a loop based on the state they live in AND if they have additional certifications. This...

Hi Pyro, After attempting several times to have the report print, I changed the cmdReport_Click Sub on the Print List command button to: <code>DoCmd.OpenReport "rptMain", acViewNormal, , , acWindowNormal, Me.ListFolders.RowSource </code> I remembered that acViewPreview has problems with...

Pyro- I resolved this a little to quickly. When I try to print the report it allows me to pick my printer. When I click print I see the screen that says it is sending data, but no data arrives and no printout. I also get an error 9: subscript out of range at Else Me.txtDir =...

Nevermind - I found an answer. I added If Not IsNull(strDir_List) Then and now it works. Thank you all for your input! It is greatly appreciated and I will be resolving this thread.

Pyro - I ran your suggestion and when I attempt to print I receive an error - Run-time Error 94: "Invalid use of Null". Debug says strDir_List = Me.OpenArgs is the error producer. Any suggestions?

Thank you for your suggestions. I will review and let you know which way I go. Just as an insight - I have many people using this db to see if a link is already used in a website. Temp tables would be hard since it would have to erase the previous persons table to write a new temp table for...

Thank you! Makes me feel right at home. :)

I have pieced together a db that starts in a specific directory and lists all the folders. By double-clicking on a directory the value list displays the subdirectories. I would like a Command button that will print all the values (subdirectories) in the current value list. I am attaching...

My name is Victor and I have some experience working with MS Access. At work we are utilizing 2010. I get ideas and think that I can make Access provide my solutions, but I am not all that great at programming language. I follow forums and take bits and pieces from them and put a db together to...