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.…
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…
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…
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…
Need help on reactivaing my microsoft 365 developer Sandbox
Hi All, Last year in November i signed up for 365 developer community and i was given the E5 Instance Sandbox for development due to some issues i have left the program after developing the powerapp and integrated it with teams. After completion of my…
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…
SSIS - Transfer data from Multiple tables using a single DFT
Hi... I followed all the procedures in this post and created a SSIS Package. (https://social.technet.microsoft.com/wiki/contents/articles/33564.ssis-transfer-data-from-multiple-tables-using-a-single-dft.aspx When i tried to execute this package all the…
I'm looking for accessing MS Project outside platform using RESTful APIs
I'm in the process of building a service that consumes or updates MS Project details via Restful API calls. After exploring the Graph API, I found that MS Project resources are not currently supported. While there are SDKs available for .NET, I'm…