Search results

You're welcome. Glad to see you worked out that Linked Table Manager is only available once you have linked the tables so you do need to use the External Data Tab to link the files first. However, once they are linked, you can use the Linked Table Manager to change the location of the linked...

Hi The user won't be able to open the backend file and make changes to it unless you supply them with the password. The password for the front and backend(s) doesn't have to be the same so you need only give your user the front end password. (You, as the designer, will only be asked for the...

Thanks guys I changed my coding to include: ExitHere: ouApp.Close Set ouApp = Nothing Exit Sub and it works! Also looked up code tags and included them in this snippet of coding. Hope that's what you meant, JHB. Many thanks to you both for taking the time to look at this...

Hi Someone please take pity on me and help me with this code which I have now spent over hours and hours and hours on. I am using Access VBA to open Outlook 2010 and send an email followed by a calendar appointment (my coding allows user to choose which calendar to put appointment in). The email...

Problem solved. I added the following code: Set olfolder = ouApp.GetNamespace("MAPI").PickFolder Set outInvite = olfolder.Items.Add This displays the Outlook folder listing and then I can just select the calendar I want the appointment to go into.

Hi I have written some code to add an appointment item. I have 2 calendars under 'My Calendars': my personal one and a second one named 'Brokerage'. My code is currently adding the appointment to my default calendar but I want it to add it to my second calendar. This is the code I am using...

I have created some VBA in my Access 2010 database to send email (works fine) and generate calendar appointment in Outlook 2010. The calendar appointment works fine on my laptop but when I try it on a work PC (MS Exchange server), the appointment headings are all okay but body text is massive -...

After you have split the database, open backend in 'exclusive' mode, use File tab to add password. Close backend. Open front-end in 'exclusive' mode. Use File tab to add password. With front-end still open, delete links to backend file(s). Use External Data tab to re-link to back-end file(s). On...

I am a partner in a small IT training company. We teach MS Office - mainly Excel, Word, PowerPoint, Outlook and every now and then Access (but definitely not VBA!). I have built a database using standards queries and forms to keep account of our bookings. However we now want the database to do...