2,489 reputation
1819
bio website awmisfits.com
location Texas
age 47
visits member for 2 years, 8 months
seen 18 hours ago

Afterworld player, and forecasting/VBA/excel/access to support the habit :)


Jun
22
answered Installing Windows from Ubuntu while booting only from hard drive
Jun
22
answered Unrecognized file format .mdb in Microsoft Access — repair doesn't fix it
Jun
22
answered how to create hotkey for doubleclick?
Jun
22
revised how do you use RunSavedImportExport from a macro
changed to correct "access" tag
Jun
22
suggested approved edit on how do you use RunSavedImportExport from a macro
Jun
22
answered how do you use RunSavedImportExport from a macro
Jun
21
awarded  Organizer
Jun
21
revised VBA script in Outlook 2010 rule
added correct outlook tag
Jun
21
suggested approved edit on VBA script in Outlook 2010 rule
Jun
21
comment MS Access: Force input mask characters in field
I have no idea why that would happen - I'm in US, so don't see any changes if I use slashes or not
Jun
21
comment Show Excel column filter information in cells
the workaround for that is =CheckFilters(A3:E3) & &LEFT(SUBTOTAL(9,A5:A200),0) really, any function that makes it re-evaluate on a spreadsheet change
Jun
21
comment Specific issue with long pathnames in Windows 7
then pkzip - zip everything up, then extract them without the directory structure. You may have to use the command line version to do this step
Jun
21
comment Change the Point Color in chart excel VBA
see stackoverflow.com/questions/11136194/…
Jun
21
answered MS Access: Force input mask characters in field
Jun
21
answered Run a .bat file upon logoff, windows XP, no domain controller
Jun
20
answered What are the recommended operating temperature ranges for the AMD Phenom II 960T?
Jun
20
revised Windows 7 losing one of my displays after restart
removed extra stuff in header
Jun
20
suggested approved edit on Windows 7 losing one of my displays after restart
Jun
20
comment How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
try removing the Worksheetfunction - it's evidently optional -> Application.VLookup(FindList(I), DataRange, NumberColumn, False)
Jun
20
comment How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?
Also, if the value is not found in your table, it will return 0, and the err.number will be set to indicate this.