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 Chriss Miller 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: HBG6
  • Order by date
  1. HBG6

    Export Data from Access to Excel

    I currently have a form (reimbursables) with a subform (Items) in Access. These two forms are linked by a relationship called job number (common field). This job number acts as a filter and only outputs those records that contain the same job number as in the reimbursables form. Well, here is...
  2. HBG6

    Generate Number from other fields

    I have an Access database and need to generate an Invoice number in the following way: "RPI"("YYMM")000 (Autoincrease)= for example:"RPI0306000" for the first invoice generated on June 2003. RPI0306001 (for the second, etc, etc...) ok, let me explain what this...
  3. HBG6

    A form to a form automatically

    Hello again. I have a form called Plotting Statement, this statement should automatically send data another form called Plotting Invoice. I created a query, table and form for both of these. They are done. All I need to do is send the data from the Plotting Statement to the Plotting invoice...
  4. HBG6

    Creating my own "autonumber in Access"

    This is why I can't use DMax to determine the proper ID to use in Access 2000: aggregate function A function, such as Sum, Count, Avg, and Max, that you can use to calculate totals. In writing expressions and in programming, you can use SQL aggregate functions (including the four listed here)...
  5. HBG6

    Creating my own "autonumber in Access"

    ="S" & Format(Now(),"yymm") & Left(Format(Right(DMax("Statement Number","Plotting Statement","[Statement Number] Like ""S" & Format(Now(),"yymm") & "*"""),3)+1,"000") & "001",3) ok...
  6. HBG6

    Creating my own "autonumber in Access"

    TonyJollans Access gives me the following error: DMax= invalid expression. I have Access 2000. Any ideas?
  7. HBG6

    Creating my own "autonumber in Access"

    I created a form in MS Access for which a "unique" automatic number must be created. Here is the critirea I wish to use: SPI(year,Month,Statement-number) I was using the autonumber field in Access but that is not helping me(it only gives me a single number). I tried using the...

Part and Inventory Search

Back
Top