Recent content by sharon attwood

It worked Thank you very much Sharon

Thanks you all very much I tried the first 2 and everything seems to be OK I have passed it on to our IT department as I know nothing about networks and so would not know where to start. If they don't either - I might be back! Thanks again Sharon

I created a database which will need to allow many users at once. A group of us can access the file at the same time, but 1 new user cannot. If anyone has the file open she gets the message "Could not lock file", if she has the database open first we get the message "could not use (file name)...

I found a backup before I broke it and re-built all the bits that are missing so I'm able to carry on now. Thanks

Thanks for the offer I have tried to send the file as it is and a zipped version but our server at work is blocking it so I can't send it to you Thanks for the offer anyway Sharon

I have created a table which has a lookup box linked to another table with a bound column reference. The lookup works in the table. On the form I have linked the original table to a query table which does a calculation based on the result of the lookup and another field. Everything was working...

I used maximum to compact it

Unfortuantely the zipped file is too big to attach. I've tried deleting most of the data but it's still bigger than 300kb. I have since tried adding a button to bring up a form relating to a query which seemed to work and bring up the information of the table, but I can't use this information...

I put this on the tables forum but my answers have now stopped, can anyone here help me with how I get this information to appear on a form.... I have created an expense database but I now want to try to add fields to the main form which will allow the users to select their car engine capacity...

I can't seem to get the file to attach it doesn't seem the right extention code it's an mdb

Colin, I think I've attached the file, but I've never done this before so it might not be there! The table I'm trying to create is called pence per litre but it is completely stand alone at the moment until I can work out how to get any information out of it. I have changed the table to your...

Thanks, Unfortunately I can't get hold of a formula. I'm still not sure how I would look up a value, even if I changed the table as you suggested. The user would need to select a cc size and then a price per litre which would then need to be cross referenced to give a value. I could set up...

I have created an expense database but I now want to try to add fields to the main form which will allow the users to select their car engine capacity and the price they paid per litre to establish how much VAT can be reclaimed. A small extract from the table from customs & excise is set out as...

Just a quick check is that you have no duplicates on the 'one' side. I don't know enough about the scripts to help you there, but when mine would not update, this was the problem.

I have a table of product codes & descriptions I have a separate table of all repairs to any products and a separate table of our spares inventory. The last two tables populate various forms and I thought it would be easier to produce these forms based on complete information from one table as...