Recent content by Frank123

Hi, I'm new to VBA and can use some help. I hope my explaination is clear. By a press of a button on a form, information in an Access table gets inserted into a Word table in a Word document at a bookmark. But there are times the Access table may need to be revised where information is...

Hi, I'm a beginner with VBA and could certainly use some help. I have an Access table that a user inputs information. That information is inserted into a Word table in a Word document at a bookmark by a push of a button. I use the code below to insert the information into the Word table...

Sorry for the delay, I was on vacation. Thanks for your replies. I used a combination of both your suggestions and it worked great. Thanks again.

Hi, being a novice to Access, I'm not sure if this can be done. Our company transports various items each month. I have an Access report that is set up to group by month. There is a text box on the report with an expression in the control source that sums up the shipping weights for each...

Hi, that worked...thank you!

Thanks for your help. I'll try to find way around it.

Thank you for your quick reply. Unfortunately, it did not work. I got the following error message: "The expression On Click you entered as an event property setting produced the following error: Method or data member not found."

Hi, I'm new too access VBA and this may be easy. I'm using Access 2010 and I have a form with a button that opens up a Word document using the code below. The code also has a message box that pops up on the form that asks the user if they want to save the prior document version before making...

Awesome!!! Thanks Minty and arnelgp. Both suggestions worked great. I appreciate your fast reply. Have a great day.

Hi, I'm new to VBA and I have an issue opening up hyperlinks. I have hyperlinks stored in a table and have a button on a form to open each one. I have used the code below on other forms which works great. But now, no hyperlink will open on the form I'm using and I get a run-time error '6'...

Thank you both. I appreciate your fast reply. I'll just make the pdf document visable and the user can select from there what to do with it. Thanks again...

Hi, I'm fairly new to access and vba. I'm using access 2010 with a button on a form that merges multiply word documents (reports) into one single pdf document. The pdf document is then automatically saved to a folder on a shared server. Now I'm wondering if there is any vba code I can use to...

Hi Dave, I just got back from vacation. Thanks so much. I'll give it a try.

Good question...Yes, now and then the company sites do use a different recycling facility other than the primary one. The reason I would like to show the primary recycling facility in the combo box on the subform is because the primary facility sometimes changes. By showing the default value in...

Sorry for not being clear. Each company site uses the same primary recycling facility. Therefore, when the combo box on the main form changes to a different company site, I would like the combo box on the subform to change to the primary recycling facility (i.e., the default value).