Search results

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...

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, 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...

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'...

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, I'm new to VBA and Access. I need help with showing the default value in a combo box on a subform. I have a main form with a combo box that is linked to a subform. The subform also has a combo box. Is there a way to have the default value show in the combo box on the subform when the...

Hi, I'm new to VBA and I thought this would be easy :mad:. I have subform with an unbound combo box. Upon selection, the combo box populates certain text boxes on the subform. I would like the combo box that is set to a default to automatically populate the text boxes when the subform is...

Hi, I'm a novice with VBA. This seems to be simple, but I cannot find an answer. I have a subform with a button that runs code after the "on click" event. While the code is running, a pop up form is triggered that pauses the code until the user makes a selection on the pop up form. Once the...

Hi, I'm new to VBA and struggling. I'm trying to copy an existing Word document in a SharePoint folder, renaming it for use as a backup, and same it into the same SharePoint folder with the existing Word document. In other words, I would like to have the existing document and backup document...

Hi, I'm new to VBA and this sounds simple (I think). I have a pop up form that is opened in dialog mode by a macro in Access 2010. The macro also performs other steps after other buttons on the form are pressed. I then placed a "cancel" button on the pop up form to close everything out...

Hi, I need some help. I'm using Access 2010, and I am looking for vba code that will insert a date that is entered in a pop up form into a specific cell in a table in the db. Specifially, I would like to have the date inserted in the the field entitled "Accumulation Date" in the table, but...

Hi, I am a novice with VBA and can certainly use some help. I have been losing hair with this. I have a button on a pop up form that merges two Word documents into one Word document. The formatting in both documents are exactly the same. When merged together, the formatting somehow gets screwed...

I'm a newby to Access. I have struggled thru developing a small Access database for work, but I can certainly use help with VBA.