Recent content by DanJames

Thanks Guys! I used the website above and it helped me complete my aim!

Thanks for your reply. I have now fixed it - I re installed the system and it worked! Thanks again! :)

Hi I am having a problem with Super Easy Mail Merge After clicking Add New Document, and then typing name, clicking OK. I get the following error message: On clicking Debug the VBA appears: What shall I do so the mail merge works. Thanks Daniel James

Hi, I want the calendar to show the date in the field [Next Payment Due] - whenever this value changes, the calendar date should change accordingly. I want the calendar to be assigned to a text box (txtCalDate), so this would also contain the date of [Next Payment Due]. However, If the...

Figured it out: Private Sub Command39_Click() Dim MyForm As String MyForm = Form!SUBCleanerJobSearch![Cleaner-ID].Value Me!SUBJobCleanerLink.SetFocus DoCmd.GoToRecord , , acNewRec Form!SUBJobCleanerLink!CleanerID.Value = MyForm End Sub Thanks anyway

Hi Here is code I am using to copy a value from a subform to a continuous subform. Private Sub Command38_Click() Dim MyForm As String MyForm = Form!SUBCleanerJobSearch![Cleaner-ID].Value //Somewhere here it would be good to go to the next record with no cleanerid value thus add a new record...

Hi, I know how you can view a website on a form, but I would like to be able to somehow copy text on the webpage into fields on the form. I don't know if VBA can automatically copy areas of a specific website and paste them into a field. Otherwise it would be great if the user could highlight...

Hi, I have a database with a table of every client (current and cancelled clients) and a query just showing the current clients. I want to show if the number of clients is increasing or decreasing, but I'm unsure how? I was thinking maybe calculating the average number of records for this...

Thank you Mark, It has worked perfectly! Cheers, Daniel

Hi, Any ideas on how I can move the current record on the form, from one table called "currentclients" to another table called "cancelledclients". The two tables have the same structure and the autonumber for "currentclients" is client-id. I have client-id in "cancelledclients" but with the...

Hi, I have two tables: tblClientDayJunction and tblCleanerDayJunction These hold the ID, ClientID/CleanerID and Day (which is a number 1-5) I would like to be able to link Client Name - Cleaner Name in a query, depending on wether the Day fields equal the same value. For example, If the...

Hi, I have an access database with hundreds of records, and would like to be able to have a table of letters linked to a word 2003 doc location. I want to be able to select one or many records on a form, then select the letter, and then a button to Mail Merge. I have been trying to do this for...

That says how to save an email attachment, however I would like to have the email content saved to a table in the database. I have knowledge of VBA for ms access on forms etc.. but nothing advanced. I know this must be annoying but is there anyone that can help specifically for this? Thank you.

Thanks a lot, but are there any free options of doing this just through vba or do I have to pay for other software? I would like to be able to have a macro or something to even take emails from ms outlook or windows live mail? This would be easier and cheaper for us. Thanks in Advance, Dan.

Hi, Is there a way for access to receive emails from a POP3 server (in this case ntlworld.com) and store emails in a table. I have access 2003, and at the moment have Windows Live Mail - If I have to change to Microsoft Outlook I probably will. Then I plan to have a query so only specific...