Search results

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

Hi all, I will try and make this as brief as I can. What i am trying to do is get results from certain tables and add the values to another, here goes? [InvoiceResultFrm] based on InvoiceTbl InvoiceNo InvoiceDate Customer Net Vat Total [JobTbl] Customer Net Vat Total Invoiced Yes/No...

Hi all, I am trying to tidy up my database as i am having major problems with Invoice Numbers being applied i.e. is invoiced then create a new invoice number. Please could you view attachment and tell me where I am going wrong with relationships on tables or any other advice would be much...

I dont think this will work, could you have a look at the attachement of database to give more of an idea and tell me if i am heading in the right path? thanks simon

I have attached picture of current view of database, hope this helps in what I am trying to acheive?

But they will have both, so when we enter new account details we would normally enter them both incase they differ. so basically there will be: invoice address collection address ( i.e. their warehouse or one of their customers ) delivery address ( same as above )

Hi All, I am creating a new project as my current database has a lot of flaws? What I want to know is, our customers can have a Collection Address that differs from their Invoice Address so should I create 2 tables and link them. Any help thanks Simon (Collection Point) Joe Bloggs...

Hi all, I am about to create a new database and now I have had a bit more practice I was wondering if somebody could give me some advice: Below are the fields I will be working with and need to know what Tables to create and what relationships. As i said, I am still fairly new at this so...

I use the "on no data" event of the reports properties and then add the message box regards simon