Search results

try changing it to this (make your selection range how you want it): .Range("A1:Z100").Copy .Range("A1").Select .Selection.PasteSpecial Paste:=xlPasteValues Range("A1").Select Application.CutCopyMode = False

Why don't you just make a query and tie the report to that. You can also add a user input [] so when you open the report it will ask the value you need to filter by.

Good morning people, I have some reports that I run on a weekly basis and that I am trying to automate. I have a make table query that is tied to a SQL Query (which is on the code below). I was successful in changing the SQL Query code using VBA to my needs but I am not able to connect...

I am having trouble saving an outlook attachment to a folder using VBA. It was working before when I was saving it to a network drive folder but now I want it to save to my documents folder and I am getting an error that says: Run time error '-2147024891 (80070005)': Cannot save the attachment...

Hello guys I am having trouble with a If statement. I am trying to save a record into a table when an item is Selected (highlighted blue) in a list box. Keep in mind that my listbox is set to multiple selections. I have the following code but sometimes it works and sometimes it doest. Please...

Never mind guys I got it to work. Maybe I didnt explain it well enough but I figured it out. I changed my form audit to single form and works as I need it. Thanks I have attached a screen shot of the progress I have made since I got it wotking.

Hi everyone Iam having a problem starting my database... I am trying to do some data entry using 2 tables in a form. Here is what I have: tableUser tableAudits formUser formAudits (set as datasheet view) My main form is formUser and I have added a subform linked to formAudits using ID field...