Search results

  1. A

    Rounding Error?

    thanks that solved my problem, cant beleive i didnt think of it before because ints are whole numbers are doubles have a decimal point. <G> i call myself a programmer as well :/
  2. A

    Rounding Error?

    i set the field to auto and i sitll have same problem. if i set it to percentage when i type in 1.63 it changes it to 200.00%
  3. A

    Rounding Error?

    I seem to be getting a strange rounding error in access. When i enter 1.63 it always shows 2. If i import any data into my tables it will auto round them all up. I have the field set to number and 2 decimal places. can anyone help?
  4. A

    an if statement in ms access?

    the problem i am having at the moment is doing this in a form, is this the psuedo code for VBA? if so i am having a couple of problems one is obtaining the text from the text field whatever = tboNetSurveyWO2.Text i dont think will work because text from textfields are string. So i wuld have to...
  5. A

    an if statement in ms access?

    Hi i was wondering if anyone can help me, i am wondering how to disable the box number with a given amount of $ For example: If i had $31,000 stored in a text field how would i display this amount is in box "3" and show 3 in a text field? if i was programming i would check if the textbox is ==...
  6. A

    Importing Data from another Form

    Doesnt work :( it brings back the first customer record not the one entered
  7. A

    Importing Data from another Form

    thats the easy way i prefer to add customer detail and have them auto import, rather than add the details, remember the id then find the id in the combo box
  8. A

    Importing Data from another Form

    how would i do that, if i was programming i would store the values in variables then insert the variables into whatever form. Do you have an example?
  9. A

    Importing Data from another Form

    Hi i was wondering if anyone can help, ive got a sales form and a add customer button, how would i insert all the customer information inputted in this other form to my current sales form?i understand i could provide a lookup based on whatever customer id the user inputted but i prefer to do a...
  10. A

    Drop Down Box Filtered of Previous Value?

    I was wondering if this is possible in access... Say i have a table which has information about cars, car id, make and model. If i have a drop down box on a form with car makes it will look up from a table of car makes... How would i create another drop down box ONLY showing the models of the...
Back
Top Bottom