Bravo Navatante! Excellent work!
For DAO queries and settings variables, see this thread:
"Replace pass-through DAO.QueryDef with DAO execution of Stored Procedure Q's"...
I built in Access VBA the "Fifteen Puzzle" game. Later I added an auto-solve capability.
While auto-solve is auto-playing the game, I found that buttons could be clicked, and cause scrambles to the code.
So I hardened against buttons being pushed while auto-solve is in progress solving the...
On a similar topic warning things never to attempt in Access / VBA....
Several years ago I was involved in a discussion in this form about the possibility of getting an Access Form bound to an ADO.RecordSet rather than a DAO.RecordSet object. I still have the prototype form we arrived at.... as...
.... but I continue to get the Access World forum post recent activities, glance through them, this thread topic of distributing FE's seemed to correlate with an old post I keep in my post collection, so thought to share it. You fault me for that?!
Here is how I successfully do Software Distribution to maintain consistent versions of FE Databases:
FE AutoUpdate with RoboCopy / XCopy
http://www.access-programmers.co.uk/forums/showthread.php?p=1214733#post1214733
Thank you very much The_Doc_Man! Exactly the sort of answer I was seeking. Saving that for reference!
Yes math / arithmetic is challenging in programming languages which do not implement decimal arithmetic support. Rexx / ooRexx natively support decimal arithmetic. I forget what a pain it is in...
Thank you Pat and CJ,
Yes, I have no need to pass real null's in my code. vbaInet and I went round and round on that a few years ago. I coded a safe function to read field controls, and posted it here:
Safely read form field text controls...
Greetings theDBguy,
Good way of looking at the question!
Data Type Bytes Used Range of Values
String (fixed Length) Length of string 1 to 65,400 characters
String (Variable Length) Length + 10 bytes 0 to 2 billion characters
Those specs are well beyond any of the other data types. So...
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...
Odd... my #2 version of the module exporter above this evening IS exporting all of the header lines. Perhaps I just forgot to re-export all the modules after writing the #2 version, thus thought it defective as well.
I am thankful,
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...
Ahhh... now that bit I have heard of as supported by OneDrive Cloud. So still would need to have IT build a non user account that is tied to the program, upload updates to the FE via that, and manage app users allowed to run the app.
Tie it to a non user as sure do not want poof the app to...
No one else may see files within anyone else's My Documents.
There is no equivalent in OneDrive Cloud of shared LAN drive folders. (With or without a drive letter.) At least not without requesting something from IT. According to this thread's links... does not sound like OneDrive Cloud supports...
Lovely. Well IT's answer will be, "Quit using Access already!"
So no way to be able to have me update a master OneDrive cloud image, and allow the FE AutoUpdate script to see that the FE has changed, fetch a copy... as if it were a good old LAN drive share?
I am thankful,