Can I...?

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

I can't find anything on this, so I need to ask. Is there by any chance some way/process in Access
(2k3) whereby I could find what query/queries would have some code I want to copy? I have some date
code that I need, and it seems I forgot to make my usual "cheat sheet" where I keep such things in a
regular text document.

If not in Access, is there some [inexpensive] third party tool to so this?

Thanks in advance,

Tom
 
You don't really tell us what you are trying to do. You are looking for a
query that has some code. What code? Queries typically don't have code.

Please post back and explain what you are trying to do.
 
I can't find anything on this, so I need to ask. Is there by any chance some way/process in Access
(2k3) whereby I could find what query/queries would have some code I want to copy? I have some date
code that I need, and it seems I forgot to make my usual "cheat sheet" where I keep such things in a
regular text document.

If not in Access, is there some [inexpensive] third party tool to so this?
Click to expand...

There isn't - you can search VBA code but not the SQL of queries (at
least not easily, no builtin tool to do so).

There are some third-party tools as you correctly assumed. In
increasing order of power (and price):

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com


John W. Vinson[MVP]
 
The apps on my AS400 typically store the date in separate fields, such as the month, day and year.
Some of the apps even have a "century" field. Dealing with a date in "pieces" does me no good. I
need a real date, as in ONE FIELD.

The code(?) I've used previously, which I know is "in here somewhere", takes those fields and
strings them together to make a real date. It is this...language/syntax...I wish to find and copy.

Nothing fantastic, just...functional.
 
Are you perhaps referring to the DateSerial function.

DateSerial(YearNo, MonthNo,DayNo) will return a date.

Since I don't know what is in the CENTURY field I cannot advise you on how
to use it. If Century is 19 or 20 or 21, then you might be able to use

DateSerial(100*Century + Yearno, MonthNo, DayNo)
 
Back
Top