Search results for query: *

Hi I have a column containing 1200 records that I want to convert into a table in Excel so that I can clean it up and export it into Access. The data looks like this: A1:Name A2:Address1 A3:Address2 to A10: sometimes the last 2 0r 3 fields are empty etc and I want it to become: A1:Name...

Hi I need the foreign key value to update when I enter a new record. I've tried setting the default value to the primary key value of the parent form and that didn't work. I've also had the suggestion of setting the BeforeInsert event, I used the following code here and this didn't work...

Hi I want a filtered pop up form to accept new records. The foreign key doesn't update when I enter new records. An archive posting that I found suggested that I insert [MyForm]![LinkedField] as the default value of the linked field. Any suggestions gratefully accepted. Steven811

Hi I have a cmd button on a form to launch Outlook and populate the to: field with the email address from A2k, all works fine. When the cmd button is selected and there is no data in the field an error message pops up [run-time error '94', invalid use of null]. I want to change the error...

Hi I have a form with 4 combo boxes. The code that I use works correctly when I first open the form. There after if the form remains open and I select new records the next cbo filters correctly but the subsequent cbo retains the previous record set until it's parent is selected. The combos...

Hi When I have been through the combo boxes once and made my selection everything is fine. When I go back to the top and start again, the next but one combo doesn't requery as I have planned. I have tried to make it happen with OnUpdate, OnChange and OnClick without success. The code that I...

Hi I have form with 4 cascading combo boxes and if you filter down after the form has opened they work fine. If the combo boxes have records and you go back to the 1st combo and choose another record, the 2nd combo correctly shows the selection and the 4th combo is cleared and locked as it...

Hi I have a simple form with 4 cascading combo boxes that are sourced through queries and work fine. To help the user I want to display a record count as a record from each combo is selected. I searched the archives and using my own initiative came up with something that doesn't work, so now...

Hi In the db I have constructed, when I'm in a form and press the page down key the layout of the form is changed. This is not helpful and I wish to disable this capability, when in Access only. How can I do this? Steven811

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. 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 boxes and subforms. How...

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

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. 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 the related records. I...

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 This is such a simply I question I am almost too embarassed to ask it. I have written lines of code that are too long to fit on the screen and I'd like to split them to 2 or 3 lines so that I can see manage them better. Hard returns don't work and I've searched help and can't find a...

Hi I have created mail merge code that works fine. However, one of the subforms (subform4) is a continous form and I now 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...

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

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