' Otherwise the table is linked to the ODBC data source. ' linked to the Access database file specified in dbPath. ' If odbcDSN (ODBC Data Source Name) is blank then the table is Sub LinkDataTable(odbcDSN As String, dbPath As String, tableName As String) ' Create or refresh linked tables using code instead of the wizard. The following VBA module provides that function. Doing so makes it easer to switch back-end databases when developing a front-end application in Access. In many cases, I prefer to create links to external tables, in another Access database or an ODBC data source, using code instead of the Linked Table Wizard. If anyone else finds them useful that’s a bonus. I wanted to document them here for future reference. Perhaps not an ideal work flow but faster than coding the SQL by hand.īelow are three VBA modules that I have found to be useful on several projects. Copy, paste, and edit the SQL to make it compliant with the target database’s SQL dialect. I’ve used Access as a SQL generator when building complex queries for other databases. You can use the visual designer and then switch to SQL View and see what the query is doing behind the scenes. The Access query builder is a great tool for learning SQL. Īccess is very powerful as an ad hoc analysis and reporting tool. Nonetheless, I do work with Access from time to time and actually think there are some things about it that are really awesome. I’ve heard the jeers and snide remarks, and agree with some, especially with regard to the GUI changes in Access 2007 (let’s make everybody learn where to find everything again). Real developers and DBAs can stop right here and move along. It sits just to the right of my monitor, in arm’s reach, and it flashes bright enough to catch my attention even when I’m deep into some code. It also has a magnet on the back so it sticks nicely on the whiteboard surface at the back of my desk. Each mode of alert can be switched on or off. Not only does it have flashing lights – it has an alarm, and vibration. I have been using this " General Tools & Instruments Timer for the Visually and Hearing Impaired " for a while now and I can recommend it as a quiet alternative for cube dwellers. A search on Amazon turned up one that looked worth trying. It occurred to me that perhaps there are kitchen timers for deaf people that flash a light instead of making noise. Since I didn’t think my coworkers would appreciate the noise of a kitchen timer, I was using a reminder in Outlook. In my current job I work in a cubicle at the corporate office more than at home. When I’m working in my home office I use a digital kitchen timer. I don’t have one of the cute little tomato timers – the original pomodoro. I also use it when I’m focusing too much on one thing and not taking breaks as often as I should. I sometimes use the Pomodoro Technique when I’m having trouble getting started or focusing on something that I need to get done. Software Development Python, VSCode Beginner Again I can always turn it back on if I miss it. That auto-completion is just not helpful for me with the kind of Python projects I’m working on now. Given I don’t mind adding my own import statements, and I probably won’t stop making typos, I decided to turn off “Offer auto-import completions” in the VS Code settings for Pylance. This is not a fault in the extension – it is working as designed. Instead it inserts import imp on a different line. Then I figured out I keep typing “im” or “imp” and hitting Tab thinking it would autocomplete as import. I found that I was trying to import the imp package a lot. The linter tells me an imported package is not being used, but I didn’t import that package (though the name of the package does look like a typo I just corrected). Overall it’s a good experience, however I’ve had these weird import statements show up from time to time. I have been using the Python extension which includes Pylance. Most of the auto-complete features in Visual Studio Code are helpful.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |