Search results for query: *

Thanks Leslie, Would you please look at my query syntax and see what's wrong with it? I tried to follow your suggestion by creating these two queries on SQL view and I got got an error. (qryNormal) SELECT ID, [DISCH_DIFF1] From [NameSSNraw] UNION SELECT ID, [DISCH_DIFF2] From [NameSSNraw]...

Dear Forum, This is an MS Access Query Syntax question. I need help with writing the syntax to accompolish the following: [Field 1], [Field 2] & [Field 3] are all displaying on the same row. Field 1 Value = 1 Field 2 Value = 2 Field 3 Value = 3 I want to write a syntax will grab value from...

Dear Forum, Here is my codes to perform above tasks and it stopped at it wants to debug at "Set sh = wk.Worksheets.Add" Any idea why? Thanks bunch! ------------------------------------------------------------ Public wk As Workbook Public sh As Worksheet Public strFileName As String Private...

Dear Forum, I am wondering what's the best way to write Excel VB codes for to accompolish the following tasks? I have an excel file (book1.xls) which consist of 1 master worksheet. I created a Form to trigger a bunch of macro buttons to do auto filters. Then my codes will copy and paste these...

*Sign* How come no one answers this Question?! Please help! Zabrina from the SF BayARea Just another humble analyst & VBA newbie~

Maybe when you created the comment with something filtered? Usually when I added a comment for a specific cell, I would make sure Auto filter is NOT ON. This way, I would know where the comment is referencing the exact cell position instead of being streth out. Zabrina from the SF BayARea Just...

Dear All, I got really stuck on this problem so any advise would help. Thank you! I am working on an multi worksheets excel file. I am trying to protect a single worksheet name "All Codes_Listing_HH," the protection part works ok but it caused problems to run my macro codes to filter certain...

Typically you can't change anything on a Pivot table. Unless you select the whole table and do Copy & Paste Special to a Value. Zabrina from the SF BayARea Just another humble analyst & VBA newbie~

Thank you Sooooooo much for both of your posting PHV & Zathras. To Zathras, that "Me.Hide" statement works like a charm! Thanks for the advice under the macro too, my codes under "A1PrintPreviewFlagY" was actually some default codes written by the Record Macro function on Excel. Zabrina from...

Hello All, Please help~I got stuck on this problem for a couple days already. I appreciate your insightful input. :D On excel, I created a macro under Tools-->Macros-->Record New Macro.. to record a chain of actions from turning on auto filter to print preview. If I choose to run this macro...