Search results

Can manage to get all wanted information from Sales table and from Address table (or query), but not at the same time. That is, changing order number on order form will change Sales data to that contained on next order, but will not change corresponding Address data.

the bard I think the answer might be a sub-form but have not got anywhere yet.

the bard Lying in bed this morning thinking about this (sad I know), it suddenly came to me what the problem is. The form I created which I thought worked was exactly the same as yours, although I created it in a different way. Both work when they pull information from just one table, but fail...

the bard False alarm! It works when I create a new form based on just an Address table (it doesn't work on a query), but it will not work when I try to create a new form based on two tables (Sales and Addresses).

the bard Don't get too excited, I am not sure how I did it - it did not involve vba - or whether I can do it again!

the bard I have been fiddling around creating new forms and suddenly I have done it!!! The problem is I have got so confused that I am not sure how! I will come back to you.

the bard I have at the back of my mind it uses a different file system or something like that. I can upgrade to 2007but not vice-versa. I only bought 2007 because I thought it would be easier to learn! I am obviously not 'with it' enough to sort, would it be easier if I sent you details of the...

the bard "You cannot use this database in an earlier version, because it uses features that require the current file format"

the bard I have been trying for hours, with no success. So I tried from scratch creating a new form, but hit another problem. On an order form two addresses are needed - the supplier's address and the customer's delivery address - but Access will not let you have two combo boxes with the same...

the bard You really have lost me, I copied your original (working) code Private Sub cboCoName_AfterUpdate() Me.txtAdd1 = Me.cboCoName.Column(2) Me.txtAdd2 = Me.cboCoName.Column(3) Me.txtAdd3 = Me.cboCoName.Column(4) Me.txtAdd4 = Me.cboCoName.Column(5) End Sub

My original Address table has "CoName" plus Address1-5 as does the Address query. I have also amended the VBA as below if I understand you correctly. Private Sub CoName_AfterUpdate() Me.txtAddress1 = Me.CoName.Column(2) Me.txtAddress2 = Me.CoName.Column(3) Me.txtAddress3 = Me.CoName.Column(4)...

the bard I have tried creating a combo box (CoName) in my original database (Sales). This is logical as this is where I would enter all customers' order details. The first line (CoName) appears ok in my Order form, but I still cannot get other address lines (Address1 etc). I am no longer...

I have found another difference; in the text box for Address1, in the Property Sheet it is shown as "Text 355". I changed the label attached to the box, but this is obviously not right.

I have amended as below, but the coding still stops on box "Address1". I created this by clicking on "Text Box" control and re-naming text label to "Address1" etc - is this correct? SELECT [Addresses Query].[CoName], [Addresses Query].[Address1], [Addresses Query].[Address2], [Addresses...

the bard I have found the difference, but do not know how to correct. My Property Sheet, Row Source against the combo box reads as follows SELECT [Addresses Query].[CoName] FROM [Addresses Query];

Private Sub Combo349_AfterUpdate() Me.txtAddress1 = Me.Combo349.Column(2) Me.txtAddress2 = Me.Combo349.Column(3) Me.txtAddress3 = Me.Combo349.Column(4) Me.txtAddress4 = Me.Combo349.Column(5) End Sub Programme insists on calling it Combo349 so I altered accordingly. I created it on 'Order form'...

the bard I think I might be making some progress! I have noticed that, several times, alterations made are not saved. Normally I have to delete and re-make. I have altered code to accomodate programme's name for combo box and run, but it stops at "address1". I am just using text box tool and...

the bard Will try to attach again. If it fails, would you be prepared to let me have your email address? Zip file too big

the bard 2007 will upgrade from earlier versions, but will not 'downgrade' (although it says it will). I have named combo box as shown, but it keeps reverting to combo 343, even though this does not exist now.

the bard I have been working very hard at this and really thought I had 'cracked' it. I have got Address1 etc labels but vba is stopping at cboCoName. I am sure it is something very easy. I use Access 2007. I hope attachment is ok, I am working on 'order'. Many thanks.