Search results

What is cboCo ? Also, how do you get unbound boxes for other address lines? I have cut and pasted vba code but I still cannot get even near to your sample.

the bard Not doing very well. As you may have guessed, I am very much a beginner! I mastered setting up tables etc fairly easily although being used to DTP programmes I found layout very 'clunky'. I have not got as far as VBA, as I will not need that until I get to the invoice calculation part...

the bard Sorry, attachment did not show first attempt. Yes, that is exactly what I want, but I cannot see how it is different to what I have done. I have created query on addresses and seem to have done the same as you. Apologies for being so thick!!!

Sorry, you have lost me!

the bard Alternatively, if I enter each address on just one line with comma separators, is there any way (Macro etc) that @, (return) ?

the bard Sorry for delay in replying - been decorating. I do not know if I don't understand, but cannot get this to work at all.

the bard This is frustrating! Thanks to all your help I have now got the form nearly right, except I can only display one line of the address via the combo box. Surely I cannot be unique in wanting to put a postal address on a form?

My Address table contains (say) 5 lines of a customer's address. Some will be very short (ABC Ltd) and some will be very much longer. What I need is a way of laying out the address exactly as if you were addressing a letter ie on up to 5 separate lines. I need to be able to select line 1 with...

I have been trying your various suggestions, with some progress! I have created a combo box to pull addresses from a single address table, but it displays the whole address across the page, ie not on several lines as per normal addresses. How can I achieve this?

The supplier address(es) would be only 3 or 4. But delivery and invoice adresses - which may be different - could be up to 100 over a year as goods are supplied to (hopefully) new customers. There will however be some regular delivery and invoice addresses. I therefore need the facility to use...

the bard I have changed the links. I originally had only 1 address table (as per my existing DOS programme) but I could not get it to enter 2 different addresses on an order form (SupplyAddress and DlyAddress). I therefore set up 3. I have read up on normalisation and, I must admit, didn't...

Here is the sql code. I am sure it is the joins that are wrong but... I originally wrote this programme in Amstrad Locoscript. Whilst I have a Windows version, it is not very happy and keeps crashing, plus it will not work on Vista when I eventually have to upgrade. Howver, it does absolutely...

I think the problem is with my joins. I have 3 address tables - supplier, delivery and invoice. On the main table (Sales) I have look ups to allow me to insert the correct address. When trying to join the address tables to the Sales table, whatever I try Access throughs up an error message to...

The headings appear, but no data. What is sql?

I have also created a query including all the items I want. I then used the Form Wizard based on the query to create the form. This looks ok in design view but, when I click on Form View it is blank!

I have tried everything!!!I have tried via a query which includes all the tables, I have tried creating a new form based on all the tables and I have tried sub-forms, but cannot get rid of heading etc on sub-form. I have created Look ups on the main (Sales) table to select relevant order...

I am tring to create a order form which uses information from my main table (Sales) but includes supplier address (SupplyAddress) and delivery address (DlyAddress). I have linked the 3 tables and can get information from Sales but not the other 2. By trying different things I can, for example...

Creating an invoice The function Nz worked perfectly - many thanks.

I am trying to create an invoice with up to 5 items.Each item is sub-totalled using Total1 = Price1*Quantity1 throught to item 5. I use the formula Totalgoods=Total1 + Total2 etc which works provided there are 5 items, any less and it will not total. I have tried various other ways to total...

I am a novice to VB. I am creating an invoice form from a database. I have allowed for a maximum of 5 items. I have created code to calculate each item total price (Total1 = Price1*Quantity etc). These are then sutotalled, carriage added, vat calculated and grand totalled. This works well, but...