Search results

If it is an UPDATE query, then definitely use the ADO.Command / ADO.Parameter style query VBA code. I have a concise example of such - though specifically postured towards Access tables - in the links above. To that, you would need to supplement with an appropriate ADO.Connection object able to...

Questions: 1) Should running on Win7 without elevated permissions be able to open/read from: HKEY_LOCAL_MACHINE, "SOFTWARE\ClientNameHere\Fandango\Database" ??? 2) If so, what should my RegOpenKeyEx samDesired options be? RegOpenKeyEx function...

Yes, if you have a SQL back-end available, making use of it will make a performance improvement. You will need to dig into the wonderful world of Pass-Through queries in Access. You do not necessarily need to code the queries as Stored Procedures (SP's). For my applications I prefer to use...

????????????? Trying again.... It is appearing that I am banging into a permissions issue with Windows 7... that conclusion from this post: VBA Code Failing in Win7/Excel 2010, Works in XP/Excel 2007...

I came across a link stating troubles with running x86 API calls from x64 Windows OS here: "Can't Run Code on a 64 Bit Machine" http://www.mrexcel.com/forum/excel-questions/646239-cant-run-code-64-bit-machine.html#post3206098 So I updated the API declarations thusly: '...

I would expect programs which work properly on Windows XP / Access 2007 to remain working properly on Windows 7 x64 64-bit / Access 2010 x86 32-bit. My use of the functions in this Module are as follows: 'Read the values out of the registry strDBServer = regQuery_A_Key(HKEY_LOCAL_MACHINE...

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"...

I found the above technique of detecting Mouse Double Click events when running on Access 2010 not functional. Following is another method of attaching code to the Double Click event of the TreeView control, and this works with both Access 2007 / Access 2010. Option Compare Database Option...

This morning I started with a fresh / compacted-cleaned copy of the A2007 database file. Using A2007 / WinXP I implemented the WithEvents version and commented out the non WithEvents event method I had discovered worked on A2007. Then I ran through my DB cleanup process: NT Command Script and...

Guaranteed not to have any residual side-effects from the WHERE clause having been passed into the Form, Sir Topham Hatt. It is merely pre-locating a record if found. I believe the WHERE clause method would actually filter / limit the number of records displayed while the WHERE clause is active...

That is quite simple. You need to pass in to the form being opened which record you would like it to be preselected on. Perhaps use OpenArgs, perhaps from the form opening reach out to some other form and have the opening form look up the specified record, etc... Once you have determined which...

The way I deal with dates in Access / SQL BE DB is in the SQL BE DB they are stored in a datetime2(0) field type. When Stored Procedures / Pass-Through SQL selects the dates out, then I format them to the display preferences. SQL examples of such: CONVERT(varchar(10), [met].[toolpodate], 101)...

hhhmmm... I started receiving the following error when attempting to open the Form with the TreeView control. I had to comment out the WithEvents added code to correct the problem. AppErrorMsg: Form: Form_products, Subroutine: btnReports_Click() Error Source: Fandango_FE Error Description: The...

Thank you, Mark. Indeed that is the work-around to get A2010 supported. Option Compare Database Option Explicit Private WithEvents ObjM_TreeView As mscomctllib.TreeView Private Sub Form_Open(Cancel As Integer) 'Set reference to the control object on the Form Set ObjM_TreeView =...

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)"...

Thank you, Paul.

Jon, Wiki saved URL's no longer work again. In fact, they appear to be 404'ing. Did you remove the Wiki?

This code appears to do what I was seeking... Place this in a VBA Module: Public Function dbutils_returnCallingQueryName() As String Dim daoQdf As DAO.QueryDef Dim strExecutingQuery As String For Each daoQdf In CurrentDb.QueryDefs If Left(daoQdf.Name, 1) <> "~" Then If...

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]...

You are still very welcome, Chris! :cool: