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 derfloh 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. 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?

    RoyVidar: Yeah, I saw that property when searching google on the topic, but unfortunately (to my knowledge) there is no equivalent property in DAO. KenReay: Guess I'll have to do that.
  3. 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
  4. TheSpoon

    Aliases in SQL query

    Yep, I'll do what you said SiJP, thanks.
  5. TheSpoon

    Aliases in SQL query

    Eek, my reply was to Leslie.
  6. TheSpoon

    Aliases in SQL query

    Yeah I know that'll work, I guess I didn't express my question clearly: Why do aliases get forgotten after some point, and is there any way to reference "forgotten" aliases, or create aliases that don't get forgotten? Thanks
  7. 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...
  8. TheSpoon

    Converting String to Date

    Yeah, I sure as hell don't expect them to come out with an update to VB6, I was just wondering if there is already a function to do this.
  9. TheSpoon

    Converting String to Date

    You're assuming the month format is always "MM", the day format is always "dd", and the year format is always "yy". If that was the case, and only their order differed, it would be easy. But this is not the case because the format could be ANY valid format string, including "yyyy/MMMM dd" or...
  10. TheSpoon

    Converting String to Date

    Of course it could work, but it is a large amount of work. Hard to believe that there isn't a built-in function for this. VB has a function to convert a string to a date using the system's format, but not a user-specified format. Looks like another oversight.
  11. TheSpoon

    Converting String to Date

    I meant that the format is unknown at design time. It is known at run-time. Is there no function that can produce a Date object given a date String and a format String?
  12. TheSpoon

    Converting String to Date

    CDATE("040720") will not work because CDATE has no knowledge of the string's format. Thanks for trying though
  13. 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