Recent content by archiecone

  1. A

    export a subform to excel

    I would create the macro then convert it to a module. Make the module to where you pass it the form name.... Sub MacroName(formname as string) end sub
  2. A

    Referring to a form with Form("FormName")

    In order to do that the form must be open! You can also use Forms!FormName.
  3. A

    Possibility of 4 different dates, need to know latest to work out process time

    There is a function called DateDiff. Subtract each date from the current date and use the smallest.. You can email me at archie.cone@mustangeng.com
  4. A

    Barcoding

    dim db as database
  5. A

    Changing ResordSource of subform

    try writing a sql statement in vb
  6. A

    PLEASE Help ME,Get a calculated field on a form to write to the same field on a table

    You can do it in Visual Basic as well. Public Sub name() Dim x1 As Database Dim rs1 As Recordset Set x1 = CurrentDb() Set rs1 = x1.OpenRecordset("tablename") With rs1 .MoveFirst While Not .EOF calculation or if statement here rs1.Edit rs1.Fields("fieldname")...
  7. A

    DLookup

    Dlookup will return the first value that satisfies the criteria.
  8. A

    DLookup

    I did not say that I wanted to return more than one value. I said I wanted to return a single value.
  9. A

    Excel to VB

    Does anyone know of someone or someplace that I can translate excel formulas to Visual Basic?
  10. 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"...
  11. 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...
  12. A

    MsgBox

    yes, do a search in this message board forum and there is an answer.
  13. 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).]
  14. 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?
  15. 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
See more
Top Bottom