Excel 2007: Adding a Secondary Axis to a Graph

It’s pretty easy to add a secondary axis to a graph if you’d like to plot two different series of data that had different scales or units.  Generally you only want to have graphs of data with different units, if you’re trying to show the relationship between the two series, so use this tip sparingly. … Continue reading “Excel 2007: Adding a Secondary Axis to a Graph”

Get Visual Basic 2010 Express to query an Oracle database

So one of the limitations of Visual Basic 2010 Express is that you can only add data sources to link or query Microsoft databases such as an Access database or MsSQL. So if you need to query an Oracle or mySQL database, for example, it seems that you’re out of luck unless you upgrade to … Continue reading “Get Visual Basic 2010 Express to query an Oracle database”

Access Tips: Watch out for case senstitive situations

I just spent like 2 hours trying to get a query with like 3 levels of sub-queries that I built in a sandbox with copied tables in Microsoft Access to work under a live ODBC linked connection with an Oracle database. Guess what broke my query? 3 references to a user input form that were … Continue reading “Access Tips: Watch out for case senstitive situations”