Michael Blaustein

Williamsport, PA

michaelblaustein.com

Age: 45

I have worked in IT for 15 years, just getting started doing web development.

Jul
2
awarded Curious
Jun
13
awarded Tumbleweed
Jun
6
awarded Custodian
Jun
6
reviewed Approve suggested edit on Can I share individual views in Access 365 (using Sharepoint Online) with external users?
Jun
6
awarded Student
Jun
6
awarded Autobiographer
Jun
6
asked Can I set permissions on individual views in Access 365 Web App?
Jun
6
asked Can I share individual views in Access 365 (using Sharepoint Online) with external users?
Jun
3
comment What is the correct SQL statement to get the Row Source for a table, based on another field?
At first, I didn't, but I think I do now. It makes sense. I wonder, though, if it will cause me trouble in creating two different drop down boxes for Category and Risk Area? I will have to give it some thought.
Jun
3
revised What is the correct SQL statement to get the Row Source for a table, based on another field?
added 245 characters in body
Jun
3
comment What is the correct SQL statement to get the Row Source for a table, based on another field?
I will edit the above post to add clarity based on your question.
Jun
3
comment What is the correct SQL statement to get the Row Source for a table, based on another field?
tblCategoryRiskArea defines the RiskAreas for different Categories. For example, in tblCategories there is a Category named Asbestos. The RiskAreas for Asbestos are Environmental and Health. There is another category named Chemical Management whose RiskAreas are Environment and Safety. All told there are 4 different RiskAreas and 18 categories, and each Category has one or two RiskAreas. I created the intermediate table to define those relationships and to avoid repeating the RiskAreas in a table.
Jun
3
asked What is the correct SQL statement to get the Row Source for a table, based on another field?
May
14
awarded Autobiographer
May
14
awarded Autobiographer
May
14
comment Can range be used to get text from hyperlinked bookmark from a supplemental document in Word 2010 VBA?
A few reasons. One is that you need to activate the document before using ActiveDocument, and then, you propbably want to check whether the ActiveDocument is the one you want. Much simpler to just assign the document to a variable and access it that way. Second, if the user clicks on the inactive document, it becomes the active document, and may bring unintended results.
May
14
comment "Page # of #" in a frozen cell
Please read stackoverflow.com/questions/how-to-ask
May
14
comment Is it possible to append Excel data to an Access database file using VBA within Excel?
Definitely possible. You can access the Microsoft Access Object Library from within Excel VBA, and make an ADO or ODBC connection to the database, and run a SQL statement in your Excel VBA.
May
14
comment Problems with initializing form with VLOOKUP information
You can always avoid it, and it is always a good idea to do so.
May
14
comment Object Required in Word Macros
At risk of repeating what Logan asked, is there a control called imgSuspect on your userform?
1 2 3 4 5