Whether you are a newbie or an experienced Access database user; with the improvements of enhanced Access database versions it’s common to encounter Access Database glitches. Today we will discuss about one very frequently occurring Access database issue i.e Macro…
Last week we have learned how to capture Events, built-in and User-Defined, Raised from several type of Form-Controls and to run Event driven Programs in Class Module. We have used Text Box, Command Button, Combo Box, List Box and Tab Control, one control of each type, on the Form. You may visit the earlier pages by clicking on the following Links:
- WithEvents Ms-Access Class Module Tutorial
- WithEvents and Defining Your Own Events
- withevents Button Combo List TextBox Tab
Forms will have several … Read More
Last week we have learned how to create the Class Object Array (the Class Object that defines only a single Access.TextBox Control as it’s Property) of TextBox Controls from MS-Access Form. The built-in AfterUpdate or LostFocus Events Raised from Text Boxes on the Form are captured in their respective Class Object Array element and executes the AfterUpdate() or LostFocus() sub-routine from there.
The AfterUpdate Event of the first TextBox is captured in the first element of the Class Object Array and the AfterUpdate() sub-routine … Read More
I’m trying to create an easy way to manage employee key records (who has what key to what door). My predecessor had it all in a badly formatted Excel file, so I’ve spent a while normalizing the data and getting it imported to Access, and now I’m working on making a nice and easy form to manage the data with.
I’ve got a table of employee information (Name, department, etc), and a table of which employee has been assigned what key (Name, key, date).… Read More
My table is acting up.. If I add a new record and move down, everything’s fine and the new record is appears at the bottom.
However, if I save the form, exit, and reopen, my new record is suddenly at row 2.
For example, if I have a list of P1, P2, P3 P4
And I add P5. I exit and reopen the table. The records are now in this order: P1, P5, P2, P3, P4.
Does anyone know how to fix this?
submitted … Read More
I have a continuous report, where customers are listed in a combo box and I am trying to calculate the number of orders by them in a text box.
I have the continuous form displaying unique customers in a combo box. The combo box has two columns, one being the CustomerID field and the other being the CustomerName field. The CustomerID column is hidden so the unique names are displayed on the report
I created another text box where I am trying to create… Read More
This is frustrating me because I believe I used to be able to resize it now I can and can only see 3 sorts at a time.
Anyone have an idea why I am not able to anymore? I can resize the Navigation and Properties panels without issue.
Get the best Microsoft Access conultant
The company I work for has an old Access database that I’d like to move the back end to Azure SQL Server.
I think the best way to do this is to migrate all the data to the new Azure db, and then link the tables in the back end file to their azure counterparts (although, if anyone has any suggestions otherwise, they’re welcome!). I have already migrated all of the data to the new azure db.
- The Access db
I have a table like this: NoteDateTime DateTime Description ShortText Narrative Long Text
I’m trying to create a form so that on the left side of the screen there is a list containing the short text and description of all the rows. When I click on a row, the right side of the screen populates the narrative.
How can I go about this? Thanks!