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 TouchToneTommy 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: TheSpoon
  • Content: Threads
  • Order by date
  1. TheSpoon

    How to jump to arbitrary page programmatically in report?

    I need to be able to make a report display, for example, page 2 without the user clicking on the next page button at the bottom of the report. Is there a way to do this? Thanks very much
  2. TheSpoon

    Check state of a RecordSet?

    I want to know if a RecordSet object is open before I call .Close, is there a way to find this out? Thanks
  3. TheSpoon

    Aliases in SQL query

    I have a query that looks like this: SELECT NB_CLIENTS.C_ID, NB_CLIENTS.C_Name, NB_CLIENTS.Transit_ID, QDef_1.Cost AS P1, QDef_2.Cost AS P2, QDef_3.Cost AS P3, [P3]-[P2] AS VAR, IIf([P2]=0,0,([P3]-[P2])/[P2]) AS FLUCT, IIf([P1]=0,'INACTIVE','ACTIVE') AS STATUS INTO NB_ANALYSIS FROM ((NB_CLIENTS...
  4. TheSpoon

    Converting String to Date

    I have a String that represents a date. For example "040720" represents today. Its format is UNKNOWN, it is specified at run-time. The format of the string in my example happens to be "yymmdd", but it could be anything. So, given a date string and a format string, how do I convert this to a...

Part and Inventory Search

Back
Top