Recent content by Housey

Hi, Well I've got an contacts tbl which is linked to orders which is linked to payments. In the orders tbl I have a field called reminders which will hold a value from 0 to 4, this will will be updated everytime a invoice/reminder is sent and will help me determine whether an invoice was sent...

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

Thanks for the reply, does anyone have an example of how this would work. I understand roughly what you are saying but need help with the syntax...

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

thanks for the replies. I have now split the database that I have a copy of to see how it works. So when I have made the changes to this one and load it on to the machine where the original resides, do I have to split the original and then import the tables into the updated one? When I did a...

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, Thanks for the replies... I had a bit of problem putting my post into words. There is currently a one-to-many relationship. From customer.custid (primary key field, autonumber) to serviceorders.custid (number) and from the customer form I can bring up the relevant service orders by...

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

oh, its ok.... I managed to sort it out by putting it in the form_current function and it works ok...... I'm sure i'll be back though :D

Hey thanx for posting! I see your point and now have the parts total working with DSUM and the others are calculated from that. However, where is the best place to use the DSUM function? I tried it as a control source value, no good, tried it in load form which is ok as it works the...

OK, I am a bit further now :D I have added some code in BeforeUpdate event which gives over the customer value - works great thanx. Now I'm trying to add the total. I have got rid of the totals table and put the fields in the parts table (I also gave the parts table a part_id PK but not...

Thanks Pat! I will add that event... and a primary key in the parts table... I have a totals table because before when I had the totals fields in the parts table there was total for every part and I wanted to add them all together etc...

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