Search results for query: *

Hi, Ok, this might be a stupid question but erm i have a subform that in it has a combobox which acts as my Product list. The problem is that whenever i select the products i want to use Access re-orders them and i need the products to stay in the order i selected them.. :( How can i prevent it...

Sigh... ok probably another really easy question to answer thatll make me look stupid, oh well here goes.. :) I have a query which searches through about 427895 records, there's a column called "Box Numbers" and when i enter: Between "321" And "324" In the criteria box the query search...

Hi, I'm trying to change the control source of a subform by the selection of an option in a combobox. Ive created the qrys that i want to be my control source but I have no idea how to write the code for what i want.. :( Help! Cheers, marcfl.

Hi Everybody! I've created a database for the company I work for and there's only one more thing left for me to do! (Which you can imagine I'm both happy and sad about.) I suppose the main problem I have is figuring out what the best way is to have a unique pricelist for some clients but not...

Hi, I've been trying to write some code to increase a field value by 1 each time a command button on my form is clicked. Basically my company uses "Job Numbers" for every order they get, if the job is based in woking the number will be WWO-0001 and if it's based at Gatwick then the number will...

Is there a fast way to do this or do you need to know the code and enter it yourself?

Hi, I'm trying to copy the address detils from my customers table into my shipping table, i created an append query that transfers the addresses to a new table called companies where i made the address field "No Duplicates" so i only get a list of the companies. I then made another append query...

Hi, I have an orders form and for every order placed on the form the total cost is calculated, i need to to save the calculated value into a table. Ive looked through like 100 posts and read the FAQs but couldnt find any answers, which is wierd because i would have thought this would be a...

I know this is possible but how? I read the FAQs but couldnt find anything on this subject. :(

Hi, The company i work for copy data off 9-track tapes, when a user has copied the last tapes of contract he will need to click on the "Contract Complete" checkbox to stop the option from appearing in the Contract combobox. Im doing this to limit the number of options that appear to make things...

Hi, This should be a pretty simple question for you guys, but i dont know where to start. Ive created a form which is supposed to enable me to enter storage information. What id like is to be able to enter a Box Number in one field and then under the Tape Number field (the contents of that...

Hi, I have an orders form on which my company will be placing orders we recieve. We have two real life sites where these orders are placed: Gatwick and Woking. I created a combo box called JobLocation which has these two locations as options. As we have two sites we have two different Job...

Ok, Im making a db for the company i work for and its my first time working with access, i also have very little knowledge of vba. On the order form i have atm, there is a subform where my bosses would be selecting the products they want for the particular order where the data is retrieved...

Hi, I have an Order form on which you select a client and the clients details (address, etc...) are brought up. On the same form is a Subform where order details are placed. a product is selected from the combo box (which works) and some text boxes are supposed to be updated with the details...