Search results for query: *

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

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.

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

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

Eek, my reply was to Leslie.

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

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

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.

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

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.

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?

CDATE("040720") will not work because CDATE has no knowledge of the string's format. Thanks for trying though

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