Search results

  1. A

    Excel to VB

    Does anyone know of someone or someplace that I can translate excel formulas to Visual Basic?
  2. A

    DLookup

    Can anyone help me out with this function?? From my understanding it will look at values in a field based on criteria that you give it. Does it work with only one record or all the records in the domain? here is an example of what I have wrote var3 = DLookup(("cablesize1"), "voltage drop"...
  3. A

    looking up a value in another table

    Ok....I have a query that I am doing calculations in. In one of my calculations I am trying to look up values in another table that is the same value as the one in another table. For instance, I am looking up a power factor for a motor. I have the horsepower in my query and I want to match...
  4. A

    calculation

    I have values in a table that I want to use to calculate other fields in another table. How can I make an if statement to look at a field in one table and then look at another for a value? Also, How can I run this function? [This message has been edited by archiecone (edited 02-21-2001).]
  5. A

    form to table

    I created a form that when values are put into the text boxes, it fills in a table. Is there anyway that I can have a combo box in my form to fill in my table?
  6. A

    tables

    is there any way to input information in one table from another table. I know about the lookup field, but it only fills in one field for you. I would like them to be able to choose one field and then it fill in all the corresponding info with that field. Thanks in advance
  7. A

    navigation

    what code would you write for when you are navigating through a form and you reach the end of a recordset to make it go back to the first record?
  8. A

    password

    I have a link table in one of my databases. In the table where I link the table from the database has a password on it. How can I set it where when you open the other database, to get into it without putting in a password?
  9. A

    Data Viewing

    I am making a form to view some data. I have a combo box, a sub form and then I have the viewing table. Is there any way that I can designate in my combo box, when they select a piece of data, to look at a certain table and then when they click in the subform to narrow down the data in the...
Top Bottom