Search results

You could look to convert the form button macro to VBA and then you can add the code to apply the filter no problem. Do you look to open the excel workbook when you run the macro?

Have you tried to use Mail Merge to populate your document?

You would need to use VBA to accomplish this.

Is the database created from within 365 as a new app? if so in the design of the table create a number field, in the properties you should see in the drop down Number Subtype: Floating-point number (variable decimal places) Display Format: Fixed (3456.79) Display Decimal Places: change to 4

Why not consider running a duplicate query so you can identify the duplicates and deal with them in access.

If you can place a copy of the database into your thread then you have more chance of someone identifying the issue. Strip away any sensitive data make sure it is 2mg or less when zipped.

To make it easier for the code to follow correctly it would be better to have the Column Headings to be laid out the same.

Read this thread it provides the code you are asking for http://www.access-programmers.co.uk/forums/showthread.php?t=184723

The code you have found is copying a sheet not a row, if you can supply a little more information then you get a better response. Questions: Which sheet is the data to be copied from Which row is to be copied Which workbook is to be opened and its file path to be included Which...

Hi Nicole what method are you using for your transfer? Do you have Office 2007 on your machine?

I would suggest you have a One to Many relationship so when you add more to the employee record you can use the Many relationship then you can run queries, forms and reports from there for each employee and the data entries you add.

Check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=257440

Either from Word you would use Mail Merge or from Access in Reports same thing.

Please don't cross post on other forums without complying with rules of the forum. http://www.mrexcel.com/forum/microsoft-access/895242-print-report-based-checkbox-selection.html

Create a form and add a textbox name the textbox something like txtPath and then refer to the txtPath in your code and it will work.

Excellent news, well done indeed. Thank you for the kind comments, and also thank you for the final reply and sharing the code I am sure others will be grateful.

First you can always record a macro in Word to provide the code and then take that code into your VBA in Access. So having recorded a macro in Word to place bold onto some text it records as follows: Sub Macro6() Selection.MoveDown Unit:=wdLine, Count:=1 Selection.MoveRight...

What if you use the following at the beginning of the code; This is the same as using Screen Updating in Excel.

Can you upload a sample of your database it will be easier to help you with a solution that will work for you. Strip away any sensitive data.

Then the only thing I can suggest is strip down a copy of your database (remove any sensitive data) and upload a copy into your thread.