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!

  • Congratulations strongm 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: *

  1. Joels7

    manipulating textboxes and labels

    This is a little embarrassing to ask, but how do you move a label around without moving its associated textbox with it? I tried pressing shift and control, I can't seem to move one without moving the other as well. Thank you, joels7
  2. Joels7

    Preserving old values of updated field

    I would like to preserve the old values of an updated field in a new field. So if my table consists of the following: F1 F2 Rec1 1 0 Rec2 2 0 Rec3 3 0 After an update to F1 I would want the table to read: F1 F2 Rec1 2 1 Rec2 4 2 Rec3 6 3...
  3. Joels7

    queries with many parameters

    I want to set up a form based on a query; The user will be able to enter values on the form for the fields of his choice, and return the records with matching values. How can I implement without having all the boxes flashing one at a time (I want to enter any/all values in the query itself...
  4. Joels7

    HELP!! Monthly Interest for Loan Reports

    I need to prepare a report which will show a record of all interest payments made on Investments, showing a complete history of interest payments made on each investment. So for an investment that payed interest semi annually, it would have to show interest payments having on January 1 and...
  5. Joels7

    retaining functionality while importing from EXCEL

    When importing from Excel, is it necessary to rewrite Macros and calculations from auto-calculated fields, or can one import these features intact? Thank you, Joels7
  6. Joels7

    How do I use Excel Functions in Access 2000

    What is the procedure for setting these references? Thank you, Joels7
  7. Joels7

    HELP! calculating differences between dates

    In a query, I want to subtract dates and get the number of days between as a result, so if in a given record, end_date=9/11/01 and start_date=8/31/01, a calculation field defined by (end_date - start_date) should evaluate to 11. How do I accomplish this without getting an error msg. I'd rather...
  8. Joels7

    HELP! conditionals in queries

    In my query, for field name, I entered expr: last_date Under condition I put in the following If("paid"=("1J" Or "2"),6/30/01) meaning if the paid field equals 1J or 2, the new field produced by the query should read 6/30/01. I am getting an error...
  9. Joels7

    HELP! entering date range in reports

    How do I produce a report, so that when it runs, the user will be prompted to enter start and end dates, and the report will return all records between those 2 dates. thanks, Joels7

Part and Inventory Search

Back
Top