Search results

I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'. Is there a way of opening the database...

Sorry to have to bump this but I'm stuck until something can be done.

I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'. So I have devised a method where I will...

Thanks Meltdown, I'll read up on a few of those suggestions :)

I had posted this in another area but didn't receive a response and my whole project has ground to a halt until I sort this out :( I have made a database with front and back ends. Now I wish to be able to use the front end over the Internet but the IP address of the back end keeps changing...

I have a form where customers can buy items, when they start buying they start a transaction. What I want to know is if the customer buys another item then how do I add the price onto the total bill in the transaction table? I have DoCmd.RunSQL "UPDATE transactions (TotalCost) VALUES ('" &...

Thanks for the replies, I'll keep trying :) Just bounding the forms now!

Okay, I admit I have botched it up :( I cannot find the value of the autonumber that the transaction was given. As I explained before when a transaction is started on the 'buy' form it is given an autonumber (OrderNumber) from the 'transaction' table, I simply cannot find that value...

I'll try to explain some more - When this is being done I am in a Form called 'frmBuyCards', when someone buys the card they start a transaction. When a transaction is started the 'tblTransaction' table gives the transaction an autonumber, how do I get this transaction number back into the...

I really hope I can explain this right :o When a customer makes a purchase I INSERT the transaction into the 'transactions' table, which I have no problems with. My problem stems from that I can't seem to get the 'OrderNumber' back from the 'transaction' table (OrderNumber is an AutoNumber...

Thanks for both replies, will try them both and see what happens :)

Thanks Wayne :)

Thanks for that; worked it out now :D Another question - how do I keep the form open and behind everything? If someone closes another form then I want them to go back to the switchboard, not to the open form.

I would like to make a value equal to another value in another form, but it keeps telling me that it can't find the Form. newID = Forms![frmLogIn]![UserID] Error message is 'Access can't find the form 'frmLogIn' referred to in a macro expression or Visual Basic code'. I have rechecked the...

Please note that I am self taught (90% of what I have learnt has been off these boards!). I did make this form with info I found on this forum. I am having problems with a log in box for a database, the line of code is - If Me.txtpassword.Value = DLookup("password", "customers", "[customerID]...

Thanks Meltdown :) Know of any good sites to learn ASP?

Hi all, I have done a multi user database for a private company (and thanks to all those that helped me out) but now I need to do another database to put onto the Internet so the general public can view it and order the products. Obviously some of the database needs to be private (so I can...

Okay well I screwed up asking those questions :o A) When I click on a button in my form (which is linked to 'table1') I want an automatic number created in another table (which I'll call 'table2'), then I want this number pulled back into table1 (table1 is not to create this number). I'll...

Making record in one form equal record in another form A) In one form I have acceptance numbers which I wish to copy across to another record in another form (no I don't want to simply link them). The code I am using is Me.ReleaseNo = FormFrom.ReleaseAcceptance where Me.ID=FormFrom.QuoteID I...

Thanks Wayne, Sharon & Pat :D