Search results

Hi, i have a form which shows stock levels. It works by the user entering a value and pressing search, then one query returns the data on the product from the stock table (so that it can be edited), and another query returns a "total of how many have been sold" in the form of...

hi, thanks for that, yes it is the answer, but i dont understand that much access coding so have no idea how to use it. but thats the basis of what i need to do. any help appreciated. jared james

Hi, i have a form which shows stock levels. It works by the user entering a value and pressing search, then one query returns the data on the product from the stock table (so that it can be edited), and another query returns a "total of how many have been sold" in the form of...

Hi, invoice numbers are incremental autonumbers, so if one record is deleted the number simply continues as it would do if the record exists. so if the records are: 1 2 3 4 and 4 is deleted it would now continue like this: 1 2 3 5 6 etc... All i was wondering was if User 1 was creating an...

Many Thanks, will be in touch if i hit any snags. you are right, i also read about the 25 user thing. mine is only for 2 max so shouldnt hit problems there. Many Thanks Jared James

Hi, just one more thing: if User 1 is creating an invoice and User 2 attempts to access the form and create one as well, what would happen? also if User 1 is performing a stock check and User 2 attempts to perform a stock check at the same time, would this be possible? Thanks Jared James

Hi, Just one more thing, if User 1 was to access the invoice form and start creating an invoice, what would happen if User 2 attempted to access the invoice form and create an invoice? Also, if User 1 is checking the stock on Computer 1 and User 2 then attempts to perform a stock check on...

Thank you very much, i now understand this as well as i feel i need to. Will re-post if necessary for help. Many Thanks Jared James

Hi, thanks for that, so if i split the file on Computer 1 and then move a copy of the front end to Computer 2, it will automatically know where it was split and connect to it? thanks Jared James

Hi, thanks for the reply. I understand what you are saying here, but just require some clarification on a few points. Firstly, so as long as the network is up and running and the users have the front end file, would it just "connect" to the back end automatically or do i have to specify its...

Hi, i have made many access databases which run on standalone machines and perform tasks such as invoicing, stock checking and various other tasks for businesses. My problem is, I have just been asked to allow multi user access to the system with updates performed almost instantaneously. Heres...

hi, when i press a button on my form to close it, i have told it to requery a combo on the form it opens over. the problem is it says i need to save the field before i run the requery command. any know how to solve this? jjames

hi, yeah i tried that but it tells me that i have to save the record/field again. any ideas? jjames

hi, a user enters a word into a combo. a form opens to add the data of the item and is then closed. the problem is, the item doesnt go straight to the combo and keeps being flagged as a new item. i had it working just now butit has totally stopped so i have no idea. any ideas appreciated...

thanks very much jjames

i have a combo which is set to limit to list. i need it set like this in order to get my code to work to add a new record. all i need to now is how you suppress the "item not in list" message you getif you type in a new value to the combo box. jjames

thank you very much why cant everyone else be this simple. very impressed. everywhere else has some complex explanation which means nothing.

hi, i need the same basic setup as shown above, however, the data i need has not yet been saved into the combo and is currently in the blank space (user just typed it). how do i get that to show. jjames

hi, i have a form which has a combo on it, and if the user enters data that isnt in the form they are given the option to add the item to the list. if they choose yes the addition form is open. is it possible to have the word the user just put into the combo box to display in the text box in...

cant say ive ever seen a barnes and noble store. i agree with you, i like to know the why as well, i can explain in great detail many topics concerning physics and geography and mathematics, subjects i enjoy very much. however, in a field such as this where the "professionals i talk to only...