Search results

Access 2000 Hi Thanks for that, although I'm now disappointed having read the previous post. I use Access 2k and would be grateful if someone could confirm the 3 subforms issue. Steven811

Thanks Thanks for the post.

Can I nest to 4 levels Do you know whether that applies to nesting too? Thanks Steven811

Hi The following code works successfully (almost) for mail merging an active form/sub form data to a Word doc. Using the form/subform faq advice I am now using the correct syntax, I've got it working to the next 2nd subform. Is there a limit to the number of subforms that I can refer to...

Correct syntax With the correct syntax I've got it working to the next subform, thanks. Is there a limit to the number of subforms that I can refer to? The code I am now using successfully is as follows: .ActiveDocument.Bookmarks("Contact12ndName").Select .Selection.Text =...

Sorry, should have looked there first.

Hi I am getting confused when I try and reference the parent and sub forms that I am wishing to extract text from. The code is part of a mail merge procedure that almost works (full code detailed at end of post) The original code works okay for the parent and 1st subform but then stops. I...

Hi I have set up a mail merge via a cmd button so that the current form recordset is transfered to book marked fields in Word, field by field. The problem is that once I get to the 3rd form (2nd sub form) Access does not complete the transfer, no error message. I know that this code works as...

Interesting Hi Rusty Thanks for having a look at a problem that's driving me nuts. The idea is that the user is working with the data via the forms, a copy of what's on the screen is generated to be taken with the file out into the field and used by the engineers. The form that I use is a...

Hi I have a cmd button to export a record set to Word from the current form, this works okay. What I also want to do is move to the nested subform and do the same again. I have tried using SetFocus to move to the next form but, this doesn't work. Am I barking up the wrong tree, should I be...

Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;210271

Sorted Thanks for the reply. I don't know why requery didn't work on my combo box but after hours of suffering I came across a solution that worked, what joy. This worked: Me.Form.Recalc I hope this helps someone else. Steven811

Requery Hi I have tried these that you see here: cboManager.Requery Me.forSiteName.forContactsJobTracking.cboManager.Requery Me.Parent!forContactsJobTracking.Form.Requery Me.Parent!forContractsJobTracking.Form.cboManager.Requery Me.cboManager.Requery It must be something very simple. The...

Hi Sorry if this has been asked before but I've searched the archives and can't find what I'm after. In a combo box I wish to automate the pressing of F9 in the AfterUpdate event procedure. This appears to be the only way I can have the data requery in the other combo box on the same form. I...

Sorry to be dim Hi Rich Sorry to be so dim. This F9 issue is proving to be really difficult for me to resolve. I cannot find a refererence to F9 in the expression builder, neither can I search the archives as F9 is too short to search by. I've several books and they don't offer any guidance...

Export Hi I'm sorry I don't quite understand the question, I'm having another dim day. The forms are in Access 2k. The cmdbutton takes the active forms recordset and sends it to Word and stops there. I need it to got the nested subform1 and take that data and then finally to nested...

Hi I have the code and it works to export data from an active form to Word. The Form also has 2 subforms and I don't know what code I should be using to move from the end of one form to the next and then perform the same procedure. The code that I am using successfully is the Microsoft example...

Hi I have the code and it works to export data from an active form to Word. The Form also has 2 subforms and I don't know what code I should be using to move from the end of one form to the next and then perform the same procedure. The code that I am using successfully is the Microsoft...

Code The code works from a cmd button called cmdEmail

Multiple forms Hi Rudy I have a tracking form that I use a lot and I need to print the current record set out on a regular basis. This is made up of: Parent Form (Customer) SubForm1 (Site) Subform2 (Contact) Subform3 (Job) With the code I have so far I can print the data from the current...