Search results

Attached is the sample database. Look at the form in design view select the button and open the properties select the On Click Event.

Take a look at the attached. The code is behind the button on the form. The database isn't attached (slight issue), the code is shown below it is behind a command button on the form.

Can you add a stripped down copy of your database to your thread then I will take a look.

Adapt this function and it should work.

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

If you want to be able to return all the data or what you have selected from your combo's then use the Like[Formname]![ComboName]&"*" as your criteria in the query.

Have you considered in the design of a table you can use a text field and use a MASK to encrypt the password.

Welcome to the forum, I am on line and noticed your thread. I have created a database that you can download to see the example. If you open the form and then select a record and use the button it will display a single record in the report. If this is what you want look at the macro in design...

Welcome to the Forum Stephen. You should receive a lot of good advice here as and when you need the community support.

Please don't double post it is against the forum rules http://www.access-programmers.co.uk/forums/showthread.php?p=1442825&posted=1#post1442825

Please don't double post it is against the forum rules. http://www.access-programmers.co.uk/forums/showthread.php?t=279560

Add a button to a form and then in the event tab select On Click the 3 dots and select Code Builder then in the code type in the name of the sub routine (between the Sub and End Sub lines) which is sendForApproval1 So something like this, when you add your button it might be called...

I would ask what have you tried so far for both of your questions. Can you show the additional code you have created.

When you click the cog in the sharepoint site and look at site content can you search for Access App and hopefully that come up with an option for you. Here is another video that provides instructions. It is building a New Database the detail is there for you...

Take a look at this youtube video https://www.youtube.com/watch?v=cutjdCTdLQE

Well done James and thanks for letting us know you have a working solution.

Welcome to the forum, I would still use Excel VBA to clean up the CSV files before importing. If you set a Reference in the Access VBA screen (Alt + F1, then select the Tools Menu and References, search down for the version of Excel on your PC) then you can use Excel VBA within the database.

Welcome to the Forum, I have added the extras you have asked for. First you need to add the Function above the code that runs the email. So copy this Function into another Module sheet. Next you would add and adapt this code. I have added the formatting and date to the subject line...

Happy to help and thank you for your reply.

Within the Apps Launcher does it allow you to open MS Access. You have only placed the Database in the Documents Library you more than likely would need an Access App or Forms App.