Search results

Hi All, I have a report for printing delivery notes on these reports are customer stock code description of goods quantity there may be 3-4 deliveries per sheet at the bottom of the report i want there to be a loading summary for all the deliveries together like this also bare in mind...

Hi all, I am trying to create a form that shows the sum results for a given customer using a combo box from a query then once the results are displayed these can then be exported to another table here are the contents of the query Date CustomerName Amount Show 12/11...

have now sorted out all the field required and need to see what needs to be where i.e. tables and relationships

thanks think i had this one before, the problem is i have multiple postcodes so there may be 100+ postcode to show on the map thanks

hi all we have a query that produces a lot of delivery address all over the uk and we are trying to map these on google maps from the postcode in the query any ideas i have seen a lot of websites using the method to show where there other office and members are etc.. regards simon

Hi all, I am creating a new project and was wondering how the best way to setup my tables and relationships. Here are my current tables and contents CUSTOMERS TABLE ============== CustomerID Name Address Postcode Contact PRODUCTS ============== ProductID StockCode ProductDescription...

Hi all, Can somebody refresh my memory: I have 2 tables one with full UK Postcode and the other with Customer Address. I have created a form and trying to when i enter a customers postcode the fields with the address are updated by the street, town and county from the matching record in the...

thanks sorted it now

i have updated this now but i cannot select a customer on the combo although it is now showing me only one customer which is great error now saying that this recordset is not updateable help thanks

Hi all i am trying to create a query that adds up all my subtotals for a given customer when selected from a combo i.e. when i select a customer name from the combo on my form the total amount of sales is shown on my form this is so i can export these reults into another table thanks simon

Hi All, I have a combo box that shows me results for records on a given customer but it shows the the customers name for each record how do i just show the customer name once joe blogs has got 10 records this month so in the combo it show me joe bloggs 10 times thanks simon

Hi all, How do i create a VAT element of 15% on my report from the subtotal thanks

how do i use this.. never used ch() method before thanks

Hi all, When i try to use the & character on my report it does not show itself i.e. M&R Properties shows as MR Properties Any ideas thanks in advance simon

Hi all i am trying to put contents of pagefooter on last page only and not the first lage if there are 2 or more pages in the report the reason is because we have printed stationary and the details of the footer are that of amounts i.e. subtotal, vat etc... i also need on the first page...

i have a report that prints out contents entered on a form i.e. current record i have created a button that prints the details entered in the fields which is all ok the only problem is that there are these characters showing on the report from the field on the form which is a memo box how...

thanks for that worked a treat could you also help me with this all postcodes beginning with PO1 would equal a charge of 26.50 but all beginning with PO11 would equal a charge of 32.80 how would i get around this thanks simon

did not work any other ideas

ok thanks will try

Hi all i have an update query that i am using which gets the results from text boxes on a form everything was working fine but i have now hit a slight problem as this query works from postcodes so if i want to update postcode beginning with the letter L then the number i.e. L1 to L20 i have...