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 wOOdy-Soft 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: johncb
  • Content: Threads
  • Order by date
  1. johncb

    Variable Column Names

    I have a working solution to this problem, but I'm sure that there is a better way to do it. I have a crosstab query that produces data for each of the previous 12 months, i.e. a moving window and the report is run every month. The report based on this query uses the Month name as the heading...
  2. johncb

    Dim ... AS DATABASE

    Hi All, I get a "user-defined type not defined" error on this line: DIM dbs AS DATABASE. If I use DIM dbs as VARIANT and then SET dbs = currentDB it works fine. I am using A2K. Any ideas? Thanks, John
  3. johncb

    Access table row count in VBA

    Hi all, Advice please on how I can, in VBA code, return a row count into an integer variable. e.g. ====================== Sub something dim dbs as variant dim intRows as integer dim strSQL as string set dbs = currentdb strSQL = "SELECT Count(*) AS intRows FROM tblX WHERE tblX.name =...
  4. johncb

    VB5 Distribution

    Hello all,<br> Can anyone please advise me on how to get the Distribution Setup Wizard include the ability to place an icon on the desktop.<br> <br> I've got the distribution happening quite well, I just need to add this small feature.<br> <br> tia.<br> <br> john<br>

Part and Inventory Search

Back
Top