Limit the rows in Access table
Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.
Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasks
The next Access Europe meeting will be on Wednesday 5 June 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by about 19:30 (7.30PM). The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST . Please note that the UK…
Open form of still open database from another access
Good morning, I have a Ms Access form from which I would like to open another form which is located in another database already open. I can do this if the second database is closed, but not when it is already open. How to do? Thanks to everyone who…
How to insert a new reference in an excel projet
Good morning, I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet. I need to insert a new reference in the created Excel project. I want to insert a reference to Ms Access to be able to invoke a Ms Access form.…
access copy and paste issue
We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…
Query is too complex.
Hello To delete many selected records at once: In a loop I populate question marks: QuestionMarks = QuestionMarks + "?, " Then: "DELETE FROM table WHERE theID = ? AND fld IN (" + QuestionMarks + ")" And: For Each MyRow As…
ActiveX control not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
In Access, an ActiveX control is not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
Integer equivalent in Access
Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…
Form Filter returning no records causes Error 2185: Can't reference a property for a control unless the control has the focus
I have a continuous form with a simple query as the data source. In the form header I have an unbound control into which the user types a partial search string. In the onChange for that control I update the form filter dynamically. This all…
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
What works in my PC does not work in a Remote PC
I have written a database for someone else and installed it in their PC. It works just fine. Now they want an update - to be able to view PDFs from Access. This works just fine from my PC with the command: Application.FollowHyperlink…
What works in my PC does not work in a Remote PC
I have written a database for someone else and installed it in their PC. It works just fine. Now they want an update - to be able to view PDFs from Access. This works just fine from my PC with the command: Application.FollowHyperlink…
ComboBox BeforeUpdate handler - Cancel/Undo unexpected behavior
Consider the following scenario: An unbound combobox with rowSource set to a query. The selected value is used in later processing. In a given situation, the BeforeUpdate handler displays a MsgBox confirming that the user wants to change the…
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
Grand total of current stock report
I want to get grand total of current stock in the blank square at the bottom, but cannot figure out how.
How to contact a forum moderator?
Hi. How do I contact a forum moderator here? I want to know why one of my threads has been deleted. https://learn.microsoft.com/en-us/answers/questions/1660015/access-europe-user-group-meeting-using-vba-to-crea As an MVP, I would never knowingly write…
Access VBA References caused compile error
An Access database in Microsoft Office 365, which is up to date, uses references to several other programs, selected in the Tools | References menu in the VBE. It has compiled successfully for several months as it is developed. It then suddenly failed…
Missing Certificate - AZ900
Hi, I have recently passed the Microsoft Certified: Azure Fundamentals AZ-900 course and received the email with the certification ID, but whenever sign into my Microsoft Learn profile there is no certificates/awards recorded against my account. Kind…