Recent content by Tracey Rylatt

Hi, We built a database in 2007 with a search query and using Access 2003. I am now trying to build the same query in a new database, however now using Excel 2007 and the query no longer works in this version. Do we have to put the criteris in differently due to the 2007 version? Thanks.

Thanks, I'll have another look at it today. Tracey

Hi Rabbie No, no brown dot but still highlighting the whole of the bottom line in yellow. This is the whole code. Private Sub Released_to_MFG_Click() Me.Booked_Date = Date DoCmd.SetWarnings no DoCmd.OpenQuery "TJR MFG Status Update", acViewNormal, acEdit DoCmd.SendObject acSendNoObject, , ...

Hi Rabbi, This has now worked but it is still highlighting the whole line in Yellow and then showing an error message which brings up the debug and says that the Send Option was cancelled, if I end through it it is fine. Can I stop it bringing up the message.

Hi Rabbie I have done this and it still brings up the debug menu. Will not allow me to move out of this code. Any other ideas? Tracey

Hi Can somebody please help me. I have the following query and cannot find why it is stopping me pressing a tab button to release records. DoCmd.SendObject acSendNoObject, , , Me.RepEmail, , , "Order Confirmation", vbCrLf & vbCrLf & vbCrLf & "Please find attached Order Acknowledgement for...

Thank you, think this might be the solution.

Hi I have created a subform which looks like an excel spreadsheet. Is there any way that say, if you have 10 lines already completed with information that you can copy and paste these 10 lines in the same spreadsheet to make 20 lines. Thanks. Tracey

Hi I have an access database which is shared by approximately 10 people. I have a shortcut to the front end of the database as I make all changes and also have a copy of the back on my desktop, all other users have a copy of the front only. When I try to open the back of the database to...

Hi, I have created an action button which then brings up a template email for our team to just add information, however you cannot change the font/colour etc on this email but if they format it into Rich Text they can. Is there a way in which we can make the email automatically rich text...

Hi I have created a query which gives me errors for orders received. The query is fine except that I have one order which has 100 lines on and when I pull the query instead of just giving me that one order with the one error it gives me 100 lines with the same error. I need it to give me...

Hi Unfortunately this didn't work. This is my code and won't allow me to use it, keeps going yellow. DoCmd.SendObject acSendNoObject, , , Me.RepEmail, , , "Order Confirmation", "Please find attached Order Acknowledgement for Oracles Sales Order number:" & vbNewLine & "Your Customer Purchase...

Hi Can you please help me. I am very new to access and trying to add a new line into a code in access. I am creating an email template and although I have created the template, when it is given as an email all lines just follow on instead of each line being on a new line i.e. Name...