Search results

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

Hi all was wondering if anybody knew of a simple database to download for entering orders. I am looking at building on the sample. Looked at Northwind but way to advanced for what i need Thanks all

sorry how do you mean and where do i need the primary keys

I want to create a new project but just need a bit of help as i am a bit rusty now.. I have a database for send out orders but need a little reminding on relationship for this database. Please note that the customer will order multiple items from the products on each order i.e. 1 x...

Hi all, Is there a tool to convert mdf to mdb I have a MDF file that i want in my database thanks simon

i have created a google maps account but where do i go from here cant find any information about access on link thanks simon

Hi all here is the code i am using from the second form which update fields on the first form then closes the second form Forms![frmdeliveryentry]![Consignee] = Me.Consignee Forms![frmdeliveryentry]![Del1] = Me.Del1 Forms![frmdeliveryentry]![Del2] = Me.Del2 Forms![frmdeliveryentry]![Del3] =...

Hi All, Can anybody tell me if there are any mapping tools i can use with Access Thanks Simon

yes i am as the field is highlighted on the form ???