Search results

Thanks for the idea, tried it last night and it turns out the network is the problem. i had a quick play with the sharing settings and managed to get 2 users on at once, just a problem with the third now. its a tough one as i've never used vista myself and their network behaves strangely, all...

just been over to have a look at the problem, the back end is in a shared folder on a 4th machine, all 3 users have their own machines running vista and office 2007. all have their own FE stored locally and access is set to open in shared mode. i found a site yesterday that suggested opening...

Not sure if this will work in other versions but in access 2007, copy your existing table, and paste a copy, you should get a dialogue asking if you want to copy the structure or the data and the structure, if you just copy the structure and paste your data from excel column by column ignring...

thats the option i meant - its definitely set to shared with no record locks - what i meant was that i was unsure if there was an option hidden away under the current database menu

i can't see an option in the options menu for the specific database but access as a whole is set to open in shared mode with no record locks

I've just built a database for a friend's business, to be used by 3 simultaneous users. I just split the database and sent the front and back end across to him, the back end is in a shared folder and each user has a local copy of the front end. the problem is that only one of them at a time...

I've built a system to log the orders i place at work. basic structure is that i have a main orders form for generic detail i.e. date, supplier etc, then a subform in datasheet view for the actual items much like in northwind. I've got it all working now except one aspect. I used the suborm...

I've now got it working by adding an unbound text box to display the second column, obviously it takes a split second to update but it'll do the job perfectly. Tha main reason i rewrote the system was to allow me to order more than 6 items, on top of that my query to look up historical prices...

After trying to get the system working on point 1 for the last few days I finally had a eureka moment and found the simple solution. i've taken the category out of the order details, so that i now have a simple combobox listing every single material - allowing me to keep the dayasheet view...

1. - sounds like you understand, but for clarity i have a materials table with three fields, id, category and description. on the orders form/table, i select category from a combo box and the combo box for item is populated with the items in that category - basically reducing the size of my...

Sorry for loading so many questions into one post but i'm getting inundated with problems. I basically devised a system for work to log orders for materials from numerous suppliers. as i've used it i've improved it, then re-written it and now i'm halfway through creating the third version...

suppliers table is as follows supplierid name credit limit payments is as follows paymentid supplierid payment amount orders is as follows (item quantiy and rate have identicle fields for item 1 to 6 etc) orderid supplierid siteid item1 quantity1 rate1 sites table is as follows siteid...

I received some help a while ago setting up a system whereby orders placed and payments made were logged into a system to display the remaining amount of credit with each supplier. for example if we have a credit limit of £1000 orders totalling £7000 and £2000 is paid on the account the...

I'm working on a system to log the orders we place with suppliers and in addition to monitor the value of orders placed in respect to our credit limit with that supplier. I'm trying to produce a form that didplays all of my suppliers and the remaining value of credit. I can display the...