Search results

Hello the reason why i use combo boxes is that the level of computer literacy here is null and zero so we have to make it as easy as possible for the users. The combo boxes stipulates that it is a pre-set amount and the next text box is a manual entry text box so if they dont want to use the...

I think that the access I use is to old for outlook express as I have tried all different solutions but still none work I get microsoft outlook to work and will standardise on that and it will solve a lot of problems as access 2.0 works 100% with microsoft outlook. Thanks for all your help...

the price is not the problem for development we have all the latest development tools the holdback is technology. people cant afford to buy new stuff so they purchase second hand systems like pi pii which we need to cater for and to make the system stable as these are rural areas and there is...

the version of microsoft access i use is version 2.0 the 16bit version for windows 3.1 due to the fact that in south africa we sell more old pc's than new ones as it people cant afford it. that is why i have developed the application so that it would run from a 486 to p4. i press the email...

Hi RuralGuy i mannage to get the query to filter the data properly by adding the following criteria to the query [Forms]![Goods Receive Details Mainform]![Embedded40].[Form]![Product Code] but now all i need to know is where to focus this so it applies each time i select the combo box the...

Hi RuralGuy that is correct the qty and cost field is only text fields i have attached a new screen clip where i have added the combo boxes and manual input boxes but i need to only get the combo boxes to display the qty and cost for the product code which is where the scanning take place the...

Hi niel thank you very much for your reply and ruralguy you are great. the version of access i am working on is version 2. would that be able to work. mel

hi reclusivemonkey i think the problem why the sendobject command does not work is that i am on access version 2. is there a way to integrate access 2 with outlook express. when i use the send command it comes up with errors. thanks mel

Hi all, i would like to find out if there is a way to send reports microsoft outlook express. i have done it with normal microsoft outlook but not with outlook express. Thanks Mel

Hi RuralGuy That is correct if must only have 1 line of data in. If they dont want the prespecified data they must be able to put in their own qty and price. as i have an update on cost if cost is lower keep it and it cost is higher update it if they take the prespecified price the price stays...

the procedure is i scan a barcode of a product then it will bring up all the information for that product but the price and qty field must only show the data for that product which they can select or do a manual input. so if a take product 1 the details will appear but the combo box must only...

Hi I would like to know how can i reference a combo box to the value of a text box on the form it is for a purchasing system. if i select product one i only want the the order quantity for that item to show and the same with the price field as all the reorder levels and cost information is...

Thank You Thanks it really helped

i have to import sales figures from a branch to head office. the import facility in ms access 2.0 only allow for 1 table although the data that needs to be imported needs to be done into two tables. how would i be able to do that appending the data to a query already setup to bring in the...

i have to import sales figures from a branch to head office. the import facility in ms access 2.0 only allow for 1 table although the data that needs to be imported needs to be done into two tables. how would i be able to do that appending the data to a query already setup to bring in the...

thanks i will try it

would you be able to use this when you enter a value in a text box in 1 form and passing that value to a main form. how would a person go about doing that i use access 2.0

They can only create new records and it is for the new records that they have to enter a id number. I have made it mandatory but coding with access 2.0 nothing always work as it should. The id is a number field. i just want a popup window to ask them what their id is and it should then put...

i need to find out how can i have a popup dialog box where they can enter in a value and the value must then populate to a non enabled field on a form. This is my trigger field and has to be filled in but they tend to forget this what i want to do is put a dialog box where they will enter their...

i need to find out how can i have a popup dialog box where they can enter in a value and the value must then populate to a non enabled field on a form. This is my trigger field and has to be filled in but they tend to forget this what i want to do is put a dialog box where they will enter their...