7 Ways To Do Sequential Numbering in Microsoft Access Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In oth [...]
Working With Console Tools - Microsoft Access We recently had a project that required us to interact with console tools. People might have different terms for those type of tools so when I speak of console tools, I'm referring to a program or script that opens a command prompt and output stuff to th [...]
Create Delete and Update Audit Tables in Microsoft SQL Server This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purpos [...]
Creating Custom Microsoft Access Formulas and Using Them Effectively MS Access has a very powerful support for using expressions in your forms/reports’ controls. For example, showing a sum of some column can be as simple as putting down: =Sum([SomeColumn]) and we’re done! Now, sometimes, we don’t ha [...]
9 Microsoft Access Developer Interview Questions A few weeks back, I created a post called 9 Interview questions to ask Microsoft Access Developers, and I challenged my loyal readers to try and answer them. Below are the questions and answers. 1. What is a collection? Answer: A group of objects held [...]
Recently we've been interviewing a lot of Microsoft Access Developers, we don't like to ask your run-of-the-mill questions like, ''Tell me your three strengths and three weaknesses,'' or ''What's your dream job?'' Aside from our vacancy actually being your dream job, we're less interested in the flu [...]
Google to Purchase Microsoft Access! Have you heard the big news with Access? FOR IMMEDIATE PUBLICATION: Google Inc, the search engine giant from Silicon Valley, announced today the purchase of Microsoft Access from Microsoft Corporation, headquartered in Redmond Washington. Larry Page, CEO of Googl [...]
Microsoft Access Seminars in Denmark and Spain [EN] We are excited to announce two big events that we are honored to present to you all. This summer Juan Soto, Access MVP and President of IT Impact, will be touring Europe and presenting a one-day MS Access Seminar, Discover the Power of Your Data. I [...]
In Depth Discussion of the Microsoft SQL Server Migration Assistant AccessUserGroups.org TUESDAY, MARCH 10th @ 6.30pm CDT This month Juan Soto, Microsoft Access MVP, will be presenting at talking about how to install SSMA, configure it’s use, doing your first upload to SQL Server and how to leverag [...]
How to Open Your MS Access Application Like a Custom Application Level of Difficulty Easy Applies to MS Access Versions Access 2000+ Overview: Sometimes, when we create a full blown application, utility, or departmental tool, we only want to see the opening form pop up on the screen and leave the fu [...]
Microsoft Access User Group Webinars for December Here are the details for 2 of our 5 Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participate. I [...]
