Recent content by jadeverell

Hi, I have created a macro that sends a report to numerous email addresses and have created a 'shortcut' copy of this macro and saved it on my desktop. I have then created a scheduled Task to run this macro on a particular day/time of the week. It works fine, until I set a database password...

Splitting a Database (merged thread) Hi, I am after some advice please, I have the following set up with regards to a shared database (Stored on a network, and used by several users) I have created: MDB File - This contains all the forms/queries/reports etc MDE File - Same as above but with...

Sorry, me again. I have one final question.... My code now looks like - Private Sub Command100_Click() DoCmd.SendObject acSendNoObject, , , [Forms]![frm_Maintenance Contracts Data]![End_User Email], "emailaddress@email.com", "", [Forms]![frm_Maintenance Contracts Data]![Contract Title]...

Its working!!!! :D Thank you all ever so much! James

I am quite new 'modules', and have been trying with the code you provided. It appears my syntax is wrong and i am really struggling to work it. Please could you break it down and explain it to me as i were stupid :rolleyes:! My email address is stored in the form/field -...

Hi, I am trying to send an email from an access 2000 form using email addresses stored with the form. I have created a button that links to a macro. Within the Macro i have put the following code in the 'To' field: [Forms]![frm_contract_maintenance]![End_User Email] However, everytime i...

Hi, I am not sure if i am doing this correctly or not, and was wondering if you could help me... I have a form that contains staff details including email addresses. I want to create a button that sends an email to the email address that is in the current record. I have created a macro and...

Hi, There is no error message, when they click on the access file it just doesn't load the database. It has been suggested to split the database into a Front End & Back End system to allow for multi-user access. Is this a stable method of setting up a database? thanks

Nope. Opening it in normal mode. JD

Hi, I have a .mde database which has been created in Access 2003. It is stored on a network and is accessed by up to 3 people. Whenever a user logs into the database it creates a .ldb record locking file and only allows one user into the database at a time (i.e. if another person wants to log...

Hi Neileg, There is already a 'Not Know' supplier (Supplier ID - 0) in the supplier table.

Hi, I am having a slight (but very annoying) problem with a query I am trying to create. I will try to explain what I am doing as best I can…… I have 3 tables, one is Maintenance contracts, one is for General Contracts and the other is a suppliers table. The two contracts table link to...

Hi, I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple...