Search results for query: *

well, it's that i'm not sure how to do it! I can do this if there is just one category...say for the "equal opportunities" box... If Me.Equal_Opportunities > 0 Then strMessage = "Equal Opportunities = " & Me.Equal_Opportunities ElseIf Me.Equal_Opportunities = 0 Then strMessage = " " Else...

I'm using the following:- Dim strTo As String, strSubject As String, strMessage As String strTo = Me.Email strSubject = "Download Report strMessage = I have a field called JobDescription and one called PersonSpec. If there are no downloads of PersonSpec and one download of JobDescription...

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...

That's brilliant...thanks!

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 =...

I'm using Word 2002 and Access 2002 thanks Barry

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...

thanks...that's really helpful!

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...

don't worry...have worked out how to do it. thanks again!

tom - that's wonderful..you've really helped me out! one last thing (i promise) - this shows a range from last week to this week. Do you know how to tweak this to show a range from 2 to 3 weeks please? a thousand thanks!

thanks guys.. am pretty new to this so please excuse my ignorance... the table i'll be taking information from is called "Bookings" and the date field is "Closing Date" Would you just copy and paste what tom's suggested into the criteria box of a new query? thanks again barry

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...

guys... apologies have changed my control name and found it works ok now! thanks a million - you've been great!

thanks... i've changed the code so that it refers to the control Issue_Date in the main form. I've checked the spelling etc of the control but it's saying "MS Acess can't find the field Issue_Date in your expression" thanks

Or...could I use a macro that moves back to the main form once the subform has been completed????

thanks...I can't seem to get the code to work from the ATTAC example unfortunately. Each subform has only one field - I've copied the code into the declaration in the main form. For each of the subforms I've entered the second bit of code into the after update field ....now I keep getting this...