Search results

Hi, I'm wondering the best way to go about this. I have a situation where a user will click a button once a week and this will query all records that are due to be invoiced (these will be monthly invoices but the button would be clicked once a week as not all fall on the same date). I then...

Hi, Not sure if this forum is correct place for this thread but here goes. I am developing a website for someone that already has an offline Access database which they currently use. They need me to import the data into the website which is fine. However, they want to be able to automatically...

Hi, I have a check box that gets ticked when 'work complete', it adds the parts/service totals and fills in the 'parts total', 'vat' and 'total' fields. This works fine but I need it to write the values to the table as well rather than just displaying the values in the fields so reports can be...

Hi, I have a database that has been in use for sometime but it needs some amendments. I have burnt the db to cd and plan to make the updates and then take it back and import the tables from the one in use to the newly updated database. I remember trying this before and it wouldn't let me...

Hi, I'm creating a db for customers and each customer can have many service orders. In the customer form I have two buttons, one to create a new service order and one to open existing service orders. Both buttons work as they are supposed to although I am doing this with custid, so both the...

Hi, I have a database running on a PC and other users just have a shortcut to database on their machines. I have an path set but it sets it for my D: partition not the network share.. so others don't get the icon... Anyway around this?? I'm probably being really silly :o :confused: :D

Hi, I am trying to create a db for service orders for customers. At the moment I have four tables, customer, service_order, parts and totals. I have one form for customer records that has a button that when clicked opens another form for that customer's service orders. The service order form...

Hi, I am trying to create a similar db to this: http://www.access-programmers.co.uk/learning2/sample3.htm Looked and there is no video :confused: I have made a start with two tables, 1 is customer and the other is service_orders. I have a 1 to many relationship from customer (key) field...