Search results for query: *

Hi, I have a form that contains order entry items. When a user records the order details they hit a button which sends a confirmation email to the client showing, in the message body, what they have ordered... Is there a way of only including those fields from the form where the value is...

hi, i have a form that sends an email to a clients confirming their booking. It's over a few lines and i'm having problems getting the code right to do this. i'ld like to have it so it reads... line 1....text line 2....blank line 3....text I'm not sure how to get the blank line and also how...

Hi, I have some code that I've borrowed from elsewhere to enable me to run a mailmerge to email from access. the problem i have is that when the merge begins it always creates a new document called "Electronic Message 1" Here's the code... Private Sub Command1_Click() Set oApp =...

Hi, I use mailmerge to send clients confirmation of their bookings by email. I'm struggling with a problem in that when I merge to email I'ld like the subject line of each email to contain one of the merge fields, in this instance the order reference number. I've tried copying and pasting the...

Hi, i want to find all records in my database for a particular issue date. the issue dates are weekly, every saturday format dd/mm/yy i want to run this query to show all bookings in the table 'Use' appearing for this weekend. Eg. if today is 19 may it would find all bookings for 21 may...

Hi, I have a query which is run each week. It shows the download stats for a product. I'ld like to mailmerge the results, sending to each client by email. I opened my mergedocument and recorded a macro of me manually performing the merge with the hope of copying the code into a module in...

Hi, I'ld like my database to collate a list of all bookings received in a particular date range. these would be collated weekly, but not on the same day each week. I'ld like the user to select today's date - the query would then find the date for the Monday of this week, before finding all...

Hi, I've got a slight problem with my form showing client bookings. The first field is a combo box with the client type - the result of which decides which of 2 subforms is opened. After the subform is completed the user then moves back to the main form. The problem I'm finding is that the...

Hi, I've a form with 2 subforms - the subform to be used depends on the selection of a combo box. This all works fine - however after completing this section the user should be able to tab to the next field which is back on the main form. I can change fields using the mouse but not with the...

Hi, I'm v.new to Access so do excuse my ignorance. I have a form with a combo-box with the following values: Trust, Course, Overseas, GP When Trusts is selected I'ld like frmtrust_sub to appear. When anything else is selected I'ld like frmnontrust_sub to appear Once the data has been...

Hi, I'm v.new to Access so do excuse my ignorance. I have a form with a combo-box with the following values: Planes, Trains, Cars When Planes is selected I'ld like planes_subform to appear. When Trains is selected I'ld like Other_subform to appear Once the data has been entered in the...