Search results

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

sorry what do you mean by your test

Hi all, can somebody tell me to complete this task. If I open a report and there is no data a message box appears saying no data etc... ( which I have acheived ) What i want to happen is that if there is data then run a macro many thanks

Hi all, Brain a bit rusty. I have a form with command button and want to dipslay message Are you sure you want to update the following records then if user selects yes this will run the update query then if no then simply cancel the event thanks simon

Hi all, I have a customer who has a copy of my database with identical tables etc.. On a daily basis he enters numerous delivery address's. I am trying to do this with his database: When he has entered the address's and he prints/emails the list of address to us the records that he has...

Hi all, I am looking a create a Database for Deliveries and Collections we do. We are a small transport company so this is something like what we need. On a daily basis we collect and deliver parcels for various customers. The customers in question may have an Invoice/Accounts address that...

Hi all, Does anybody know where i can find a database with all the UK postcodes on it so i can use in Access. So i enter a postcode and the information is then updated i.e. street, town and county Any ideas? Thanks

Hi all I am trying to tidy up my existing database and create a new one but i dont want to make the mistake and errors i did with this one so was wondering if somebody could help in create the right format and relationships etc for the table below. I will also explain a little on how the...

I have created a reltionship now, is this correct below and how do i associate the popup with the current record been added TblDelivery DeliveryID Date Customer Address ( popup opens on exit ) CustomerRef Cost TblDescription DeliveryID NoItems Weight Service On exit now return to CustomerRef

Hi all Can somebody tell me how to create a popup form for additional data entry. What i need is when entering data on the on exit event of the address field to show a form to enter the quantity, weight and service details I think i may need to create a seperate table with a relationship as...

how do i do the dsum function the customer field is account_name (this is from the form called CreateInvoice ) the sum name is £cost where the invoiced field is False thanks simon

No Responce

I have a form that show me results from a query What i want is to if there is no data on the form then cancel this event and show message box saying sorry no records or something like this I have a field on one form where i enter the postcode then a button which opens the form with the...