access-vba-recordset
How To Identify The Last Row Worked On (VBA Variable Scope)
So, I had an interesting question regarding how to find the last row the user was working on before the closed the form, so when the reopen the form, they could continue to work on that record. (This is actually expanding on an example I showed: https://vbahowto.com/how-to-highlight-the-current-row-in-a-continuous-form-in-3-steps/) The the following code will demonstrate one way […]
How To Extract Data From Outlook To Access With VBA
In this post you are going to find out how you can extract data From Outlook to Access with VBA”. Someone at the place I’m working at was let go, and they wanted the information, primarily from the user’s Outlook inbox, to be extracted to an outside application so the particular information about various projects […]
How To Have Access VBA Link Tables Programmatically
This table relinking procedure is a really good example of how to use VBA to link your tables programmatically, and how to have MS Access refresh linked tables automatically. It allows re-linking all tables to a selected drive source (the folder the backend database is in). In this example, all of the tables that need […]
MS Access Subform Navigation Buttons
In the following example the ms access subform gets its value from parent form. In our example we have a main form which shows the customers and the subform which shows all the orders for the customer: Independently the forms function by themselves, however it is more meaningful if they are combined. This is how […]
MS Access Running Count With String Column And Duplicates
In my previous post, https://vbahowto.com/ms-access-running-count-with-duplicates/, the DCount counter, works fine when you have a numeric value, and it works fine when you do the VBA counter when you do it on numeric column values, but what about counters on string columns with duplicates? MS Access Running Count With String Column And Duplicates Since an Access […]
MS Access Running Count With Duplicates
This post is a response to a video I have on Youtube: MS Access Running Counter In Query “After running your solution in different databases, I found out that it only works if there are no duplicate values within the Number field (in your tblRunningSum). Once there are duplicate values, the row numbering gets corrupted. […]
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) […]
Access VBA Create Table
This example is a response from an email I received regarding: “How to build a table by extracting some fields from a main database…” I interpret it as: “Query a main database (mainframe) and create a local table.” I do have another easier version of this process at “How To Create A Table In Access […]