Search results

You can't do this with Functions in Access, you would need VBA to do this.

I have no additional references checked, you shouldn't need to add any with this code. What happens if you remove the reference you checked.

I have just simulated your code in Access 2003 and it worked fine here is the copy of the code I ended up with. I placed it in a module sheet and used the same table name as yours but didn't see why you did a second objOthersTbls.Add which might have overwritten the other. Sub expXml() Dim...

Have you tried to append the datasheet into a temp table and if that shows the data in the correct order you can then use the temp table to export.

Does your code actually have speech marks, if so remove them, else post all the code you are using, I can check it with a 2003 machine.

You shouldn't need to add any additional references. I would ask which version of Access you are using. Can you show your complete code. An example is shown below:

Welcome to the Forum, Here is the first part of the code you need. You would have to alter the textbox name to the field name you are using on the form.

How have you designed the table? I assume you mean about the umlauts

Please be aware Microsoft have Auto Updates plugged into Windows 10 so you can be working on something and it Auto Updates without you knowing and then reboots. At work this can be annoying and if like me training people it disrupts the session. My only option I found to do something about this...

Have you tried the append query approach rather than in a macro and if this works then use the macro to run the query.

Have a go with this code which I wrote in another thread:

2 options that I see. First Compact the database. Second consider splitting the database so the tables are in one database and the front end is in another. Does the database reside on a Network drive?

Welcome to the forum you would need to explain how the Excel workbook is set out and how you identify the latest 100 records before you will be able to find a solution that meets your needs.

Welcome to the forum, can you show all of the code so someone can help.

I don't see any mention of looping or the other workbook names. Where are the names stored. What code are you using to export the queries.

Happy to help and thank you for letting me know you have a working solution.

In the VBA screen (Use Alt + F11) select the Tools Menu and References and then search down for Microsoft Outlook 12.Object Library and click the box save your changes and it should work for you.

Look to adapt this as I have tested and it works fine.

Welcome to the Forum, you would need VBA to do this. Indicated below is an example. On your Access Form go into Design View add a Command Button and then stop the Wizard 9Press Escape), open the Properties of the Command Button and change the following: Name change to cmdOutApp Caption...

Although its not referenced in VBA select the Tools Menu and References and search down for Microsoft Outlook XX . Object Library XX being the version number and click the option. Test the code again.