Category: Access
MS Access
-
Auto Creating Continuous List forms
Often when analysing data , I import the data into access and use this code to make a list forms from the tables in my access database. The code will read all the fields from the tables and allow a user to set focus fields in the table. These focus fields are given an order…
-
List of all fields in an Access Database
I use this code to make a table which lists all the tables in an access database with the field names. I used this table as the source for making both Record and List form views. Details of the code for these other forms are listing in later posts VBA Function ; list of all…
-
Stock Counting App
I was testing a stock counting app from iReap. The android app allows you to load a master stock file or just scan barcodes , you have the option to edit the quantity and if the same item is scanned it increases the count quantity. Stock Counting App – Scanner for Mobile phone I had…
-
Barcodes for VBA
Barcodes for VBA: I downloaded and tested the TEC-IT Barcode activex. IT comes with a host of example in Excel , Word and Access. I created a simple table with a product code and added the barcode control and tied the control to the part number if the table and set the barcode to QR…
-
Manage your Site Downloads
Manage your site downloads ; this plugin will load all forms into a single folder and allow easy display in alphabetical order on any page or post on your site. From the admin menu you can load the file and give it a description which can be edited if required or removed if no longer…
-
Wordpress Site Migration
I was testing a number of backup and restore options for our club website in the last few weeks. Many of the plugin will do an excellent job but almost all require some pro features (Understandable but we don’t have the budget ) I came across the plugin Migrate Guru which directly clones the site…
-
User registration using VBA and WordPress
wanted a simple method to allow user registration in order to advise of program updates. I created this plugin in WordPress to make a registration table and I have detailed below the VBA
-
Top 5 Uses for NFC tags
NFC (Near Field Communication) tags are versatile and can be used for a variety of purposes in personal, business, and industrial settings. I have listed below my Top 5 Uses for NFC Tags. 1. Contactless Business Cards 2. Wi-Fi Sharing 3. Digital Marketing and Information 4. Inventory Management 5. Smart Home Automation Bonus Ideas: NFC…
-
Trusted Locations with Access
If you are using the full version of Access you can set the trusted locations as required in the trust center. This option is not available in the runtime version.
-
We’ve got a new look!
We’re excited to share our redesigned logo for Anything Access. The team behind it did an amazing job, and we’re really happy with how it turned out. The new design feels fresh, modern, and truly reflects who we are.
