Search results for query: *

Thanks for your help gents. I opted for Ken's solution as I thought it would be easier and it works a treat. V Grateful.

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

Cracked it. Thanks for the helped gents.

Sorry if I haven't explained my self. That is what Ive done, I've checked the references too. My actual code is: Private Sub Form_BeforeInsert(Cancel As Integer) Forms!forProject2.ContactKey.Text = Forms!subformContacts2.ContactKey.Value End Sub My error msg says that Access can't find...

Hi I receive the error message that it can't find the main form (although in my case it is a subform) Steven811

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 Both the parent and child forms are linked to different queries.

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

Thanks, I'll work on this tomorrow am and let you know. Regards Steven811

Excellent, thanks Works a treat:))

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 You are correct, the combo boxes act as a filter for the subsequent cbo. The record is the criteria used in a SELECT query, this all works fine. The problem that I have is that once I have used the form the records don't clear in the 2nd level combo boxes until the parent combo is...

Hi I've tried to make your code work and I can't. I swapped the [>] plus the False and True and on the second selection it greys out the subsequent cbo. Doesn't seem to matter which way round they go. In spite of my best (although still limited) efforts I have reverted to my previous code...

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 They're queries. Thanks

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 It is a query and uses the selection in cbo2 as the criteria. All of the combo boxes use a query as their source, the last 3 use the previous cbo selection as their criteria. Thanks for looking.

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

Thanks, works a treat. I've used the list counting code elsewhere on my db too. V grateful.

Hi TheAceMan1 I'm doing fine ta, Your suggestion works really well. With your assistance I would like to modify it a little. At the moment the calculated control sums the record sets as I work my way through the combo boxes and what I would like to be able to do is have it display only the...