admin
Client Side Storage Access And WebSQL Database Part3
In this post I am showing how you can make your webform more user friendly. Sub GenerateContainmentInspectionsHTML() Dim intRandomDB As Integer Dim intSeed As Integer Dim strDB As String ‘this is seed value for the RND function’s random number generator. Randomize ‘Int ((upperbound – lowerbound + 1) * Rnd + lowerbound) intRandomDB = Int((2500 – […]
Client Side Storage Access And WebSQL Database Part2
In this revised procedure I will create the SQLlite (WebSQL) database to hold the Access query contents and then display them on a web form in a table format. (don’t be concerned with the colors in the following code:) Sub GenerateContainmentInspectionsHTML() ‘HERE YOU ARE MAKING THE DATABASE FOR THE INSPECTIONS Dim intRandomDB As Integer Dim […]
How To Create A Local Web Page With Access DB Data PT1
This is going to be a multiple part blog post, but here I am clicking a command button on a form and then taking the data from a query called “qrySecondaryContainmenttodrain”, and creating a html page called “containment_inspections.htm”. (You will have to modify the query and the html page so it will fit your need) […]
How To Integrate Access With An HTML Page
Hi, While I was troubleshooting some other issues, I found a way to integrate MS Access with an HTML page. It all started after someone I work with posed some interesting programming question. They had a question about whether it could be done, and since I enjoy trying to find out the solution to questions […]
MS Access Incrementer/Counter
Below l show you how to create an incrementer/counter for your Access database. As you may or may not know, Access will reset your counter, every time the form is closed. (It’s like the SESSION variable for a browser). Anyway, to preserve the value of the counter when a database form is closed and reopened, […]
File Open Shell VBA
This video is a response to a comment on another video at https://www.youtube.com/watch?v=98t1yLUwmEo&lc=z13oevyrxxiyjpjdd221jthigmnmghv3l “Hello, where can I add code to open a specific excel document?” There is a more useful option to the Shell function, because I don’t have to name the file to open, and it’s already built in to Microsoft Office. You can […]
Create A Report Based On Items Selected In Access Combo Box
You can download the database here: Click here for the database and the code: Create-A-Report-Based-On-Items-Selected-In-Access-Combo-Box.accdb If you have a suggestion for a future video, contact me on my contact form, and I will seriously consider it. By the way, if you got or are getting value from the VBA information, please click the “Donate” button […]
Access Parameters Using TempVars
Access TempVars are like using query parameters. TempVars seem to be like Session variables for your Access application. In the past I was using hidden forms to store parameters for my queries, but TempVars can be useful to do the same thing. I have seen this in use and wanted to share it with you. […]
Access 2010 Ignoring Open Of ADP File
Hi everyone, today I was doing a client consultation and came across a strange issue. Access 2010 was ignoring my request to open an .adp file, or Access project file. Access was ignoring the request to open “adp” files. Normal Access files “accdb” opened fine. I found the solution to be adjusting the security settings […]
How To Set Up Relational Database
I had a suggestion from a reader named “Dennis” after trying to gather information for a new database book. He responded: Erik, My suggestion is this: Make an easy tutorial to set up a database with tools on how to setup tables, link tables, how to set up keys on tables. Most tutorials tell users […]