Search results

For Access field value input of any standard data type... is there a datatype which would loose data/precision passing through a String variable as opposed to a Variant variable? I realize use of the Variant type would be necessary to be able to store more specialized data type, but for sake of...

Greetings, I have tried two methods to export VBA modules. Neither for me produce complete hidden headers that the manual export user interface includes. This results in VBA not being able to import them successfully. I have tried the following two VBA implementations: 1) VCS code originated...

Greetings, I commonly use an Auto FE DB Updater described here: FE AutoUpdate with RoboCopy / XCopy http://www.access-programmers.co.uk/forums/showthread.php?p=1214733#post1214733 Without a shared LAN drive available any longer, does anyone have suggestions how to still have shared access to...

Greetings, I believe I bumped into a contradiction. According to the official VBA docs from Microsoft here: Property Let statement https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-let-statement So I am trying to create a read-only Property that is...

Greetings, Previously we got working: ADO.Command + Disconnected ADO.Recordset for SELECT https://www.access-programmers.co.uk/forums/showthread.php?t=258559&page=2#post1318234 I am trying to arrive at similar working VBA code to perform a SQL INSERT or SQL UPDATE such that I can have the...

A while ago we were having a discussion about having a ADO objects feed data into an Access Multiple Items form. Today I discovered one can do almost exactly the same with a DAO.Recordset based on DAO.QueryDef. Link to our prior Access Continuous Form fed via ADO objects: "Example of ADO...

Greetings, I have used such syntax as in this snip below: 'Define attachment to database table specifics and execute commands via With block Set adoCMD = CreateObject("ADODB.Command") With adoCMD .ActiveConnection = ObjBEDBConnection.ADODBConnectionObj() .CommandText =...

Greetings, I suspect a GPO is preventing me from adding directly to the registry Access 2016 User Trusted Location. In the Access UI Trust Center, all buttons are greyed out, and nothing shows up as User Trusted Locations. I successfully added my own directly to the registry. When I restarted...

Greetings, Some time ago, I was chatting with Galaxiom in this forum system about techniques to use ADO objects as the data source for form controls and not have to use the ADP file format. For a previous client I worked out a technique to use Access in a Client/Server configuration where...

Greetings, Is it a requirement to using the Access Runtime version that the database VBA source code be compiled? Or will the Access Runtime raise no issue operating an .accdb file format? Blessings,

Greetings, Given an environment of two separate / different SQL BE DB's able to be connected to by ODBC connection, what other options than using a desktop database file as temporary storage exist to download records from the one SQL BE DB, to then use as the source of a bulk INSERT into the...

I am suspicious that in Access, Reports Group On behaves differently than in SQL RDBMS's. I have an Access Report which in the "Group, Sort, and Total" pane has the following: Group on: vendorid Sort by: vendortitle Sort by: partnumberI was expecting the first to simply group all of the...

Greetings, I am hesitantly considering use of a non-Pass-Through query to bulk populate SQL Server tables. All other areas of BE DB SQL access are via Stored Procedures (SP's). To publish records from Access to SQL Server, presently I fire an INSERT SP for each record to be populated to SQL...

Previously I had been running Access applications through paces "torture testing" and had come up with three DoEvents being required to completely flush the input queue of all Esc / Cancel requests. Abridged example: Private Sub btnClose_Click() 'Flush keystrokes out of the buffer so that...

Greetings, I just realized that I do not know where my ShellAndWait module is obtaining the constant definitions for the WindowStyle arg. They are all defined presently: ? vbHide 0 ? vbNormalFocus 1 ? vbMinimizedFocus 2 ? vbMaximizedFocus 3 ? vbNormalNoFocus 4 ? vbMinimizedNoFocus...

I have always had solid read access to the Windows registry running on Windows XP with Access 2007. I am utilizing code from here in a separate VBA Module to obtain access to the Windows registry: "Change registry settings in VBA"...

Greetings, Some time ago, I discovered that the TreeView OCX control supports an undocumented Double Click event in Access 2007. I wrote up a tip about the undocumented feature and published it here: "Using Double Click event of TreeView from Microsoft Windows Common Controls 6.0 (SP6)"...

Someone brought up an intriguing question, so I thought to inquire among the peer group here: Is there a way for a SQL QueryDef object in Access to look up the name of itself in the SQL and return that as a value in the result set? Ex: SELECT [foo], [bar], [something]...

Greetings, I have found, today, very odd errors in code dealing with the VBA.Collection object. A friend has proposed that perhaps VBA returns a different error when a particular entry was not found in a completely empty VBA.Collection object verses a VBA.Collection having one or more objects...

Is there any sort of limitation in DAO.Recordset objects that would prevent me from searching across multiple columns for a match with code along the lines of this code? Dim strFindInCol Dim strWhereClause Dim daoRS As DAO.Recordset 'Find out which column is currently being sorted by...