Recent content by Dnphm

Hi, First let me say that I did not create this database but rather inherited from someone else. I have two tables, "tblProductCurrent" & "tblProducts" which store information about our products and their policy numbers. Both tables have the same fields, "PolicyNum", "ProductName"...

I am using Access 2003. Essentially I would like to take my Departments report, apply a filter that will display only certain departments, and then print the resulting report to a pdf file. Accomplishing this through a command button and code would be ideal. Thanks

Hi, I am stuck on something regarding reports. I have one report that displays contact information of different departments of our company. How can I sort and print by Department and send it to a pdf? I am looking to create this functionality through a command button on a form. Thanks!

Hi, I am exporting access tables one after another into one excel workbook using VB coding but when I export, it would open the same excel workbook but in a different window. How can I keep it to just the window that is already open from the first export? Thanks

I figured it out how it works, but I have one more small question. I will be running this for multiple queries, how can I not have it open the excel workbook in a new window. So, I want it to update but have it done in the same window that is open. Thanks!

I think I fixed the Range Class problem by inserting xlWsh.Select before the range code. But it seems to still do everything except overwriting the worksheet and changing the data.

This is the line: strPath = strFilePath Set rst = CurrentDb.OpenRecordset(strTQName) Set ApXL = CreateObject("Excel.Application") Set xlWBk = ApXL.Workbooks.Open(strPath) ApXL.Visible = True Set xlWSh = xlWBk.Worksheets(strSheetName) xlWSh.Range("A1").Select For...

There is no Debug. It runs the code, opening up the excel workbook but the worksheet isn't updated. The error message appears in Access.

Okay, it seems to be going through the process but I get an error message that states, "Select method of Range class failed." The range of data on the Excel worksheet that I want updated is A2:A348.

If I were to create a command button, how can I run this code? Thanks

Hey, Here is my situation. I have queries that displays email addresses of our employees in each department. Due to employees leaving from time to time, these queries are updated regularly to accomodate for those changes. I also store these email records in a large Email Contact workbook in...