Search results

Book marks [I've done it with another code] Hi Rudy Thanks for your reply. In the mean time I've tinkered with the original code and it works okay now. Do you know how to print using bookmarks from multiple forms? Regards Steven811

Hi I have used the ms example to export the data from a form. When I run the procedure the word doc opens but the data is not there, just the original bookmarks. Any suggestions would be great. Here is the code. Thanks Private Sub MergeButton_Click() On Error GoTo MergeButton_Err...

Design question Hi Ken I offered to knock a simple db together for a pal, when he detailed the requirements it became a little more complex. On the up side, it all seems to work okay until he wanted to include 2 levels of contact, the 2nd at the regional office. This is where I have been...

Me.YourComboName.Requery Hi Rich Thanks for the reply. I know that it should work all the right fields are in the drop down menu when I enter this code. When I change the data in the 1st combo box and expect the requery to update the data in the 2nd cbo, it doesn't. However, when I use F9...

Hi I have 2 combo boxes in a form and the value selected in one needs to update the second combo box. This value becomes available via a query to the second combo box. I decided I needed a requery (incorrectly I now believe), however this takes me back to the 1st record which is not ideal...

I feel really dim Hi Thanks for that, I became fixated with the combo box. It now works. Thanks Steven811

I'm either a novice or an idiot. Hi Ken I guess you weren't impressed with the way that I grouped the higher level contacts. Strangely, F9 refreshes the data exactly as I would like it to work. Thanks for looking. Regards Steven

Hi Michael I've been looking at this problem for 2 days and my head is fuddled. I have used the following: Private Sub cboLocation_AfterUpdate() Me.Parent!cboLocation.Form.Requery End Sub The error message says that Access can't find the field cboLocation. My intention is to update the...

Is this correct - What's the problem? Hi Ken When you change the location of the contact to the Regional Office he becomes a manager and is used for grouping contacts. They should then appear in the cboManager as an option to select. Hope that's clear. Thx Steven811 PS - F9 does exactly...

F9 does it I've found that after searching the archives that F9 does exactly what I want. Now I want it run when I alter the data in cboLocation.

Cut down version attached Hi Ken Cut down copy of db attached. Regards Steven811

More info Hi Ken forSiteName = subform1 forContactsJobTracking = subform2 The subform2 has the cboLocation control that I'm trying to requery from. Regards Steven811

Hi I have a control on a subform that I want to requery when the data changes. The following code doesn't show any error messages, although it doesn't work either. Private Sub cboLocation_AfterUpdate() Forms![MainForm]![SubForm1]![SubForm2]!cboLocation.Requery End Sub There are no...

Thanks Hi Vince I've had a look through the archive and can't find anything so I will post a new thread and see what happens. Thanks for your help. Steven811

No more error messages Hi I've resolved some name issues, subform properties displaying a modified name to the form name in the db menu. The code in there now is: Private Sub cboLocation_AfterUpdate() Forms!forCustomerDetails2!forSiteName!forContactsJobTracking!cboLocation.Requery End Sub...

Looking for a field Hi Ken I have used the following: Private Sub cboLocation_AfterUpdate() Form!forCustomerDetails2!forSiteName.Form!forContactsJobTracking.Form!cboLocation.Requery End Sub Access says that it can't find a field with the name of my 1st form. It also changes my lower case...

Looking for a field Hi Dave When I run: Private Sub cboLocation_AfterUpdate() Form!forCustomerDetails2.Form!ForSiteName.Form!forContactsJobTracking.cboLocation.Requery End Sub I get an error message that says that Access can't find the field ForSiteName When I compile it changes the lower...

Reply that passes my by Hi Ken Thanks for the reply. Your reply suggests only 2 forms and the control I have is in the 3rd form. Sorry if I've missed the plot. Happens a lot. Regards Steven

That's great Hi Vince Thanks for that, I will look at it later this evening. I have got a structure working, but I'm struggling with a requery of a nested subform control (cbo). How are you with a requery? Regards Steven811

This is what I use Hi This is the code I use on a cmd button, I cancel and it works okay. Private Sub cmdEmail_Click() Dim Contact1emailaddress As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem email = Me!Contact1emailaddress Set objOutlook =...