Welcome to the portion of my website where I share and store information or tools about Microsoft Access and Excel. Hope you find some of it interesting or helpful!
If you're totally new to using Microsoft Access, I recommend reading this article to help get you started.
If you have any questions or suggestions for the articles on the website, feel free to post in the forums. I can't promise my response will be quick, but I will try my best to respond to all forums posts.
Sincerely,
Azli
As an Amazon Associate I earn from qualifying purchases.
A new data type was introduced last year in Microsoft Access, i.e. Large Number (BigInt).
The Large Number data type can handle bigger numbers than the standard Number data type, i.e. 8 bytes vs 4 bytes. While the Number data type has a range of -231 to 231-1, the Large Number type has a range of -263 to 263-1.
If you're a Microsoft Office 365 subscriber, you can now deselect cells in a range of selected cells.
Once you'e selected a range, just hold down the CTRL key and select cells or a range within your selected cells to unselect them. (It easier to do than to explain)
Step 1. Select your range.
Step 2. Press and hold the CTRL key, and select the cells (or ranges) you want to deselect.
Additional Links
This is code from a Microsoft KB article - KB Article 210398. I can't find it anywhere online (except for the Internet Archive) so I'm posting it here for reference along with the pertinent text from that article.
This article contains a sample user-defined function named IsTableQuery() that you can use to determine whether a table or a query exists in a database. The sample function uses the TableDefs and QueryDefs Data Access Objects (DAO) collections.
NOTE: The sample code in this article uses Microsoft Data Access Objects. For this code to run properly, you must reference the Microsoft DAO 3.X Object Library or Microsoft Office 16.0 Access database engine Object Library. To do so, click References on the Tools menu in the Visual Basic Editor, and make sure that the correct Object Library reference check box is selected.
Apparently this can be done in Microsoft Access 97 but I haven't tested it. This is something from an old hard drive that I still have. I saved the following explanation somewhere but can't figure out where I got it from;
You can use the MsgBox function in Microsoft Access to create a formatted error message similar to built-in error messages displayed by Microsoft Access. This function permits you to supply a string in three sections for the prompt argument. You separate the sections with the at sign (@).
The following example displays a formatted dialog box with a sectioned string. The first section of text in the string is displayed as a bold heading. The second section is displayed as plain text beneath that heading. The third section is displayed as plain text beneath the heading "Solution", which the function provides for you.
I haven't tried this since I don't have Microsoft Access 97, so I can't say if it actually works or not.
MsgBox "Wrong button!@This button doesn't work.@Try another.", vbOKOnly + vbExclamation"
However, this can be done using the same syntax but must be used in together with the Eval() function. You can format a string into two sections - bold and regular. The bold section is first. Also, there will be a line break in between the bold section and the regular section.
Eval("msgbox('BOLD Text.@Regular Text.@@',4,'Example 1')")
