Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ChewDinCompSci
  • Content: Threads
  • Order by date
  1. ChewDinCompSci

    Way of referring to a previous row in a table using vba?

    I am trying to refer to a previous row in a table to compare two times (time1 and time2). Is there a way of referring to time1 after dealing with time2 in vb so that I can get the difference between the two times? Any help anyone can provide is much appreciated. MatChew codename: vba4dumbE
  2. ChewDinCompSci

    General question regarding RecordSets

    When using recordsets is it possible to refer to a previous recordset (a previous record in your data table) and make a calculation on two numbers, each number being from a seperate record in the table? MatChew codename: vba4dumbE
  3. ChewDinCompSci

    use update query with "OR" statment

    I am trying to update fields in a column called FuelWord with the word "Gasoline" or "Diesel" based on the value of another field in the same record, FuelType which has a value of "1" or "2". This is the SQL I have tried: UPDATE tbl_FuelUsage SET tbl_FuelUsage.FuelWord = "Gasoline" WHERE...
  4. ChewDinCompSci

    Code form to populate records relating to a chosen variable

    I have a form that allows the user to select a specific date (cboRptDate) and equipment number (cboRptEquip) out of a large amount of records and then create a report on those choices. The report works fine however I want the user to have the option of also choosing all trucks (equipment) that...
  5. ChewDinCompSci

    Code form to query/report all records relating to a specific variable

    I have a form that allows the user to select a specific date (cboRptDate) and equipment number (cboRptEquip) out of a large amount of records and then create a report on those choices. The report works fine however I want the user to have the option of also choosing all trucks (equipment) that...
  6. ChewDinCompSci

    Code form to report/query all records that apply to specific variable

    I have a form that allows the user to select a specific date (cboRptDate) and equipment number (cboRptEquip) out of a large amount of records and then create a report on those choices. The report works fine however I want the user to have the option of also choosing all trucks (equipment) that...
  7. ChewDinCompSci

    Select all options in a combo box

    I have a drop down listing equipment numbers and want an option to select all the numbers in the combo box. What is the best way to do this? MatChew codename: vba4dumbE
  8. ChewDinCompSci

    Select all options in a combo box

    I have a drop down listing equipment numbers and want an option to select all the numbers in the combo box. What is the best way to do this? codename: vba4dumbE
  9. ChewDinCompSci

    Choosing a date and equip. number to retrieve specific data

    Last week I asked for some help on coding a form to allow the user to choose a specific date and equipment number to retrieve specific data from numerous records and then send that data to a report. Thank you for all the help. I used the following code on my "report generator" form: Private Sub...
  10. ChewDinCompSci

    Problem coding form to report queried data

    I have a form that allows the user to choose the date and an equipment number to produce a report on. The trouble I'm having is that nothing happens when you click on the command button to preview the report. I want the data to be sent to a report an empty report I have already made. This is...
  11. ChewDinCompSci

    Problem reporting queried data

    I am attempting to send data to a report that is queried by a form where the end user chooses a date and an equipment number. So I'd like to report only on a specific date and equipment number from all my data. I've used the following code for On Click to produce the report: Private Sub...

Part and Inventory Search

Back
Top