Search results

Hi all, Please see attached picture where I am stuck at? I have a table that holds UK Postcodes and a customer table that holds customers. I am trying to create a relationship between the 2 so when I enter a postcode in the customer table this is then related to the postcode table...

sorry, what is join? do I also need to create a query? thanks for your help simon

Hi all, I am using access 2010 and have the following question? I have 2 tables, 1 called UKFile and the other Customers with the following fields [UKFILE] THIS IS WHERE ADDRESS DETAILS ARE STORED POSTCODEID POSTCODE STREET TOWN [CUSTOMERS] CUSTOMERNAME POSTCODE STREET...

Hi all, using access 2010. I am trying to setup a parts and supplier database that is currently done using a spread sheet. Each part may have upto say 5 suppliers with its own price. I then view the prices and use the lowest quote. Prices are checked and updated on a monthly basis. What...

yes, many thanks though! simon

Hi all, I will try and explain this as best as i can, please go easy on me as i am fairly new to access. I have a form called "invoice" and has a subform called "JobsSubform" The subform is in Datasheet view with only a few fields on it. When i click on the record of the subform this then...

Hi all, I have created the attached database to show you what sort of thing I am trying to acheive. A customer will call us each day with 1 to say 10 bookings, these bookings are then allocated to an Invoice and Invoiced at the end of each month. The invoice consists of many bookings for a...

Hi all, I am creating a new database to input my customers deliveries and collections on a daily basis. Then when all data has been added over a number of weeks we then print out an invoice for these and send to customer. Am I heading in the right direction or can you recommend any changes to...

I starting a new project and need a bit of advice. I have 3 tables as follows: TblCustomers TblContacts TblWarehouse TblCustomer has all the head office details entered. TblContacts has contact names and telephone numbers as there is sometime more than one contact person and telephone...

I all, I have a database with all uk address's on it as layed out below which is great for queries etc.. There are 1754968 records on here in total covering the whole of the UK and Ireland from around 2007 I can supply this on CD for a small charge if anybody would find this useful...

can you look at my new posting as I have updated the form

Hi all, I have uploaded database to show where i am at. Please look at bookings form for error. When I try to add another record to an invoice i get error message: "The object doesn't contain the Automation object 'invoice' " What i am trying to do is when a customer requests a new...

getting runtime error you cant assign a value to this object ??

sorry, can you specify a bit more info never used the openargs before? thanks

Hi all, I am using Access 2010 I have uploaded database to show where i am at, but I am now stuck on the following: As you will see I have a form called Main which dispays all active ( uninvoiced ) customers which has a list box that when selected show the Invoice. What I want is when the...

Hi all, I have attached a copy of my database. I am trying to create a form to add records to a given invoice number, tried numerous things but getting different errors. There are many jobs for each invoice number. Eventually, I need to create some sort of dmax funtion where when i enter the...

thanks for you reply, but how would i act on this with my form as at the end of the month a want to simply print all the invoices off in one go for all the customers?

Hi all, This has been doing my head in for a while now and i am still no further. I have attached a sample of where i am at upto now. THE MAIN THING TO NOTE ABOUT MY DATABASE IS THAT WE UPDATE AN INVOICE FOR UPTO A WHOLE MONTH AND THEN POST THESE OUT AT THE BEGINNING OF THE FOLLOWING...

Hi all, please find attached database completed upto now! Was wondering if somebody could help me with this new project. This database contains collections and delivery points for our customers. A customer can make upto 1 to 3 delivery and collection bookings per day and these are all...

Hi all, Can somebody tell me the formula for my vat fields for adding and deducting vat amounts of 20%. Regards, Simon