Search results

I knew something was wrong but can you explain a bit more as i am still learning i have attached a bit of the database i use to give you some idea thanks

Right here goes, I have now got rid of my old database as we did not have any relationships etc in place so information and data entry was a bit of a nightmare so i am starting a fresh new one and would like any help. I am quite new to relaionship and codes etc... Right! We have various...

i have a table which have all of the UK Postcodes in it PostcodeID, Postcode,Street, Town, County. What i am trying to do is after i have enter a postcode in a form field is for it to look for the results in th postcode table I know i can use a query but this would mean creating about 6...

I have a query that brings up a selected amount of records so when i select a customer the query brings up the records for that customer then i have a field a the top of the query form called order that i want the value of this added to the Ref fields of the query so it would be like this...

dont know if this helps open delivery/details form enter delivery details for selected customer on a daily basis at the end of the month open form invoice this will then call all records not invoiced and allocate the invoice number to the records maybe by way of a command button thanks...

thanks for that. nearly there, what i need is that when i start up the delivery form there will be no records showing and when i select the customer from the combo box then the records for that customer will show in the subform any ideas thanks simon

hi all i wondering if somebody can help i have been trying to get this database up an running but can't get by this bit... i have attached a database so you may be able to see what i am trying to acheive. we enter deliveries for a number of customers on a daily basis then at the end of the...

sorry to be a pest but your the only person who seems to have a clue what i am trying to do: i think i am nearly there just a couple of things i have changed field names and relationship etc as you said and everything seems ok i just a bit confused at how to create the form where the...

but wont i get a new invoice no everytime i enter a delivery, i need 1 invoice number for say 15 deliveries which we invoice at the end of the month. i have now removed customer id in the invoices table. other than that do you think the database looks about right. thanks simon

it is quite simular to what i am trying to acheive but there is a few modules on the databse which i have not got a clue about thanks any other thought

can somebody tell me where i am going wrong i want to allocate an invoice number for multiple records in this database database sample attached which may give you some idea

i have uploaded file so could you please tell me where i am going wrong i still get 1 invoice per delivery thanks simon

OK got that, but wont this only give me one invoice number per delivery i enter what i need is say if i enter 15 deliveries for 1 customer i need 1 invoice number for all the deliveries what i am trying to acheive is simliar to sage

i have got these to link but how do i allocate the invoice number from the invoice table to the deliveries table

hi there these are the same customer not customers with same name i have got it to link customers and deliveries but what do i do in the invoice table and the relationship

i use a form based on a query which call all records that have not been invoiced what i want to do is query these then in the form i have a field that when i enter a number and click on a button it gives all the records below this number in the field invoice no any ideas

hi there thanks for reply i have done my job because i have been using my own database for 5 years its just the annoying part to get a funtion where i can generate invoice numbers as i have to do this manually by entering the details into the invoice table any advice thanks simon

i am trying to create the following database and have not really got a clue this is what i am trying to acheive i have a few customers that send out deliveries on a daily basis which are invoiced each month so each customer will have say about 20 deliveries per month. i want to call these...

it not doing nothing even though i have followed your steps what i want it to do is at the end of the month recall all the jobs for a given customer and store them somehow in the invoice table and give all the jobs 1 invoice number thanks any ideas

i am quite new to this so please go easy on me!!! i have looked at northwind but all looks a bit complicated at the moment right here goes! i am trying to create a database to enter multiple orders on and then print invoices on the program at a later date, these are the fields i am working...