Search results

GPGeorge Thank you for your reply. i am happy with the way the report prints. like i mentioned in my first post, i would just like the report view to only display the part that will be printed like this instead of it having the white part at the bottom like this. i just need a way to...

Hi there Mark Thank you for you reply. So this will be printed, i just figured that instead of that large white section at the bottom it would look better if it only displays the part that will be printed in the report view. The width i good its just the white part at the bottom that doesn't...

Hi there experts Hope someone can assist me. I have a pop-up report that has a big white section below that i cant get rid of. I have tried to resize the border and save it but when i reopen it its the same again. This is what it looks like. i would like for it to look like this and...

Whooops. Fixed it, thank you Mike.

Indeed, i have been watching quite a bit of Richard Rost stuff. I'm thinking about watching his training stuff from A-Z and practicing on training Database. I love access its done so much for me in my career.

Hey Pat I can assure you next time ill remember. Guess that's how we learn.

Hi George Yes, thank you. I'm getting the hang of things a bit around VBA and my access database.

Thank you for this Gasman

Okay so i have changed it a bit, i have now put the expression under "CustomerID" instead of "CalloutID" It looks like this... It all works perfectly now. Thank you very much.

Hi there Thank you very much for your reply. I'm pretty new to all this so I'm not 100% sure what you mean here. How would i go about using the expression builder to sort this out?

Hi Experts I need to get a report to work properly. I have created a Query that contains fields of both my main table "TblCustomerInfo" that is my main form "FrmCustomer Info" as well as my subform tabel "TblCalloutsDetails" that is my subform "FrmCalloutsDetailsSubform" The Query...

Got this solved. My code looks like this now.

So this what I'm getting

Hi George Thanks a mill for your reply. ill be honest i have no idea what you mean. Is there something i need to change on the code?

Hi Experts I really need some help please i am still pretty new to Access VBA. I am trying to create a pop up reminder in my form called "FrmCustomerInfo" that has a Subform called "FrmCalloutDetailsSubform" I am using the On Timer event with VBA and a Timer Interval of 5000 But i keep...

Hi Mark I am quite new to Access VBA yes. I have managed to create the query and it now only displays the customers that needs to be mailed. I have placed your code on the send email buttons one click event like you have explained below. What is our next step.

Hi Mark Okay, i created the form "frmReviewForm" as per your request with the 2 buttons. Button 1 - Cancel = Macro to close form "frmReviewForm" Button 2 - Send Mail = I am not to sure what you need me to do here Then you mentioned that i make a query that returns ONLY the customers i need...

Thank you Mark Thank you for getting back to me. okay i am not an expert at this. could you help me with some vba code to take me in the right direction. like i explained. when my form frmNewCustomerDetails is opened the vba code must run automatically, and basically do what we have...

Hi Mark Please see the answers to your questions below. 1) Are you trying to send 1 Email to a group of people OR send each an individual Email? - That is correct it is one email to a group of people 2) Do you want to see each Email before it is sent or have it automatically go? - The...

Hi Isladogs please see below my SQL SELECT NewCustomerDetails.ID, NewCustomerDetails.Date_Of_Site_Visit, NewCustomerDetails.Customer_Name_and_Surname, NewCustomerDetails.Customer_Cell_Number, NewCustomerDetails.[Customer_E-Mail_Address], NewCustomerDetails.Customer_Address...