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

    MS Excel Macro to select a column based on row heading

    Is it possible to create a macro in VB codes to select certain columns based on row heading in Microsoft Excel? Basically, I need the macro to select the whole column of "Account" before proceeding to do some other formatting just for this column. Reason i need to macro this is because i have...
  2. extreme00

    Insert count from 2 queries

    Thanks to eerlee and Hovercraft and those who tried to help even if you have not posted the solutions yet. I've mangaged to use DCount with success!! These is how I've coded it : INSERT INTO TBLCOUNT ( [CurrDate], Count1, Count2 ) VALUES (DATE(), DCount("[VarX]","[Query1]")...
  3. extreme00

    Insert count from 2 queries

    Thanks so much for replying, eerlee! However, I had to change the syntax due to the syntax error that MS Access prompted when saving. This is what I've changed it to INSERT INTO TBLCOUNT ([CurrDate],Count1,Count2) VALUES(DATE(),(SELECT COUNT(*) FROM [Query1]),(SELECT COUNT(*) FROM [Query2]))...
  4. extreme00

    Insert count from 2 queries

    I'm a MS Access programming newbie, can anyone please help me on the following? Query1 contains the following : varX ---- D Query2 contains the following : VarY ---- 1 2 3 I'm trying to insert the count of these 2 queries into a new table, say TBLCount, so that TBLCount look like this ...

Part and Inventory Search

Back
Top