Search results

Hi there, wondering if anyone can help me. I Have an access database which my users can add New information into. On Form 1, there's a combo box called Product, which lists 1,2,3. What I would like if possible is an ADD button next to the combo box, so if the user doesnt find the product...

Yes, the Default Open mode is SHARED. every form is Recordset Type - Dynaset Record Locks - No Locks Thanks

I Have the record Locking set up as; Default Record Locking - No Locks Open Records using Record Level Locking - Ticked box i havnt changed anything under the Tools - Options - Advanced tab, as im not too sure what im doing. maybe you could shed some light on what i need to do. thanks

Hi there, thanks for the reply. Ruralguy..what would i need to do after i've changed from shared mode to exclusive mode? Thanks

Hi there, wondering if anyone can help me. i have a database that is going to be shared across a network server. What i would like(if possible). USER 1 has opened up the Microsoft Access database and has spent 15 Minutes entering information. USER 2 then goes to open the same database, but...

Thanks everyone for your help. the database works a treat :)

Hi Again. Thank you for all your replies. the query works great!! one final thing, i have 3 forms, with parameter queries, so when run it asks you to enter a part no, description or a component. that all works great. i was wondering, would it be possible to create a form based on the query i...

yes total is a field in my table. as the QTY changes, the Total will need to change. thanks

Hi All. i finally have it working and it looks great. one tiny problem, is there a way that i could add a pound sign to this Total: Nz([QTY])*Nz([Cost]) so when the query runs and brings up the results, they all have (£0.00) infront of them? thanks for your help

Hi There, Thank you for your reply. forgive me for my stupidness, but how would i write the above into my query. which criteria field would i insert Nz([QTY])*Nz([Cost]). into? Thank you.

Hi all, wondering if anyone can help me. Im trying to a run a query to see the results of my table. but i am experincing problems, when use the SUM function. I have constructed a query with three fields. 1) QTY. 2) Cost 3) Total. what i would like is to be able to Multiply QTY & Cost to...

Hi there, thank you for your reply. what would be your recommendation on how to approach this? i've tried splitting the database before but had no luck. please could you provide more information on how you would go about doing this procudure.

Hi there, wondering if anyone can help. im trying to create a multiple user access database, but i am experincing problems when more then one person is trying to access the same entry fields and this is causing conflicts, the database is stored on a server and is not localised to the network...