Search results

acPrevious works Hi The buttons work, first, last previous and next. Oddly this code doesn't stop the user mving to a blank/new record [If Me.NewRecord Then DoCmd.GoToRecord , , acPrevious End If] Steven811

Help with syntax It only displays the error message when I'm on the new/blank record and then try to move on one more record. The buttons are on the main form and there are 2 nested subforms. The code that I'm using is: [Private Sub cmdGotoNext_Click() On Error GoTo cmdGotoNext_Click_Err...

Hi My own nav buttons work well with the exception of the next button. I only want it to go to current records and not past them as I have another button for that function. How would I modify the code? Here is what I currently use: [Private Sub cmdGotoNext_Click() On Error GoTo...

Hi I have constructed a form that consists of 4 cascading cbo boxes and 2 subforms. (Thanks to mile o phile) When I have made my final selection in the last combo and go back and choose another record from the first combo I requery the second combo, this leaves the records in the other combo...

Hi To display a Rep field from a linked customer table, I have used a SELECT query for the 2 linked tables. This (correctly) shows the customers where they have a rep but I wish to see the customers that don't have a rep allocated to their account also. How do I modify the relationship or...

Hi I've spent hours on this problem and can't resolve it and would appreciate some assistance. I have 2 cascading combo boxes on the parent form that work okay. I wish to link the subform to the 2nd combo and have tried to do it like this: Using the subform properties I enter the 2nd combo...

Hi I've been trying to sort out my cascading combo boxes today, spent about 6 hours on it and got no where. My mind is fuddled and I could do with some help, does the following look correct? [SELECT [tblCustomerDetails].[RepKey], [tblCustomerDetails].[CompanyName] FROM tblCustomerDetails...

I have changed a parent form so that it is now unbound and contains 2 cascading cbo boxes instead. Now I have lost the link that I had with the subform and I wish to recreate it so that it reflects the selection in the cbo and only shows the 'filtered records'. Any help would be appreciated.

Hi - Novice here I've searched the forums and can't see/understand a solution to my problem. I have an unbound parent form with 2 cascading combo boxes ( thanks to mile-o-phile). I have a subform sourced through a query and I wish to link this to a combo box in the parent so that I only show...

More than one record should display Hi When I run a select query more than one record shows. When I run the combo query only one record is displayed. Very odd, it's something simple I'm sure. Steven811

Hi I've created 2 cascading combo boxes and they work okay with the exception that child only shows the first record. The select query I'm using is as follows: (I'm not sure if it's this) [SELECT [qryAllCust].[CustKey], [qryAllCust].[CompanyName] FROM qryAllCust WHERE...

Hi The original code works fine for the current record in the active form. The problem is that in one particular form I wish to print the other records (historical record of notes). The code is meant to be as I've shown here, not saying it's right. I thought that subform4 which holds all of...

results Hi The results I am getting are that debug/compile does not produce an error. When I run the merge the recordset comes across until I get to the comments bookmark. It works fine with the original code, when the following code is added it fails and stops at the "comments" bookmark...

Loop Hi The tables have relationships. With a parent and 4 subforms, a report dosn't work. Exporting it into Word does. Regds Steven811

Hi I want to export data from an active form, linked to the active control to Word. The code I am using works fine and is enclosed for reference. The problem I'm trying to resolve is that the last form holds historical data linked to the active control through an ID that I wish to include...

Hi I have created mail merge code that works fine. However, one of the subforms (subform4) is a continous form and I wish to print all of the records from the active subform. These are date related notes associated with the subform3 record set The code for identifying the current field is...

Hi I've created code (using examples from the forums) to export data from an active form/subforms to Word, this all works okay. One of the controls is a combo box displaying a linked field from a select query. My problem is that the code prints correctly the contents of the bound field...

Hi Although A2k limits the use of nesting subforms to 3 levels and this increases to 7 for 2002 and 2003 I can't get the code to work. On another PC I have A2002, I converted the db and it all seems to work fine. When I run the merge I still can't seem to get past the 2nd subform to copy the...

Can't quite persuade it to work Hi Although A2k limits the use of nesting subforms to 3 levels and this increases to 7 for 2002 and 2003 it still doesn't seem to work. On another PC I have A2002, I converted the db and it all seems to work fine. When I run the merge I still can't seem to get...

I've found it Had a look in help and there it is, 3 levels. Thanks for that. Would you upgrade from 2k to 2003? Regards Steven811