Search results

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

Hi All, I have a report for printing delivery notes on these reports are customer stock code description of goods quantity there may be 3-4 deliveries per sheet at the bottom of the report i want there to be a loading summary for all the deliveries together like this also bare in mind...

Hi all, I am trying to create a form that shows the sum results for a given customer using a combo box from a query then once the results are displayed these can then be exported to another table here are the contents of the query Date CustomerName Amount Show 12/11...

have now sorted out all the field required and need to see what needs to be where i.e. tables and relationships

thanks think i had this one before, the problem is i have multiple postcodes so there may be 100+ postcode to show on the map thanks

hi all we have a query that produces a lot of delivery address all over the uk and we are trying to map these on google maps from the postcode in the query any ideas i have seen a lot of websites using the method to show where there other office and members are etc.. regards simon

Hi all, I am creating a new project and was wondering how the best way to setup my tables and relationships. Here are my current tables and contents CUSTOMERS TABLE ============== CustomerID Name Address Postcode Contact PRODUCTS ============== ProductID StockCode ProductDescription...

Hi all, Can somebody refresh my memory: I have 2 tables one with full UK Postcode and the other with Customer Address. I have created a form and trying to when i enter a customers postcode the fields with the address are updated by the street, town and county from the matching record in the...

thanks sorted it now