Search results

Hi - I just removed all my files from box.net and forgot about these samples. I moved them to Citrix's Sharefile system which doesn't allow anyone to download. It's late here in New Hampshire. In the morning, I'll see if I can upload them to my ISP. Otherwise, you can email me at...

Hi James, it's AC 2010.

Hi, this one has me stumped. I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new...

Just in case someone stumbles on this, the answer to the text field problem with parameters was answered by Allen Browne, here: http://allenbrowne.com/bug-13.html under "Flaws In Access" in which he states that parameters of type text are evaluated wrongly. Pat was correct in many regards...

It pulls the floor [level #] from the tree and it is correct since the same node value (put into control txtNode3) works for other queries.

Thank's Pat - this is legacy and too ingrained now to correct given the size of the application. I've learned a lot since I started way back when, but in development, just as in life, sometimes we have to live with past mistakes since the cost of correcting them is too high. Cash flow on this...

Hi: I uploaded the form with all supporting tables, queries and code - it's probably worth downloading, if just to see Jan's beautiful subform, a code-based treeview. Download (1MB) zip from here: https://app.box.com/s/amrekqjkwk5kg1jkb2n1 requires AC10, maybe AC07. I'm beginning to think some...

Hi Pat: I uploaded the form with all supporting tables, queries and code - it's probably worth downloading, if just to see Jan's beautiful subform, a code-based treeview. Download (1MB) zip from here: https://app.box.com/s/amrekqjkwk5kg1jkb2n1 requires AC10, maybe AC07. I'll repost this on the...

Thanks Pat, this stuff is my weak point, I have QBE dependency and when I do need to "write" SQLfor insertion in code, I use Allen Browne's handy little converter which takes QBE SQL pasted into a text box and outputs code-compatible SQL. I've got some looming deadlines, so I'll probably just...

Pat - okay, got your point and converted all possible group-by fields to where. Some of the group by's are needed. Now I get this, after Access magically reinterpreted the query grid display: PARAMETERS [Forms]![frmInspectionReports]![StartDate] DateTime...

Thanks Pat - I'm playing around with this: PARAMETERS [Forms]![frmInspectionReports]![StartDate] DateTime, [Forms]![frmInspectionReports]![EndDate] DateTime, [Forms]![frmInspectionReports]![txtNode1] Long, [Forms]![frmInspectionReports]![txtNode2] Long, [Forms]![frmInspectionReports]![txtNode3]...

Thanks Pat and LagBolt for your speedy replies. I'll try one or both of these suggestions and let you know how it worked out! I love that treeview, it's very powerful and promises to be much more stable (and distributable) than Microsoft's activeX control.

Hi again, I read somewhere that it's difficult to pass "null" to a parameterized query when basing the parameter on a form control. I'd like to do that if possible, but I have a different, almost opposite, question. I have a query I'd like to reuse as much as possible based on multiple "where"...

Hi all, I'm hoping one you CodingMeisters can help me out. I've got a very complex form going that updates MS charts based on user selections of a frame control (3) options, a treeview control (free download from http://www.jkp-ads.com/ and very nice all-code control solution) having 5 nodes (5...

Hi all, I'm hoping one you SQLMeisters can help me out. I've got a very complex form going that updates MS charts based on user selections of a frame control (3) options, a treeview control (free download from http://www.jkp-ads.com/ and very nice all-code control solution) having 5 nodes (5...

Thanks - as a follow-up. This is what I learned. 1. Use a tool such as the one mentioned. It's just easier. 2. Access "instr" function can be problematic - it couldn't resolve strings with bang operators properly or consistently (not sure which). 3. Watch how many queries you open at one time...

Update - just noticed the extraneous quote marks surrounding some of these strings, may explain some of the issues.

That is funny - not sure why it wasn't saving for me, and I saw other forum references to the same issue. Now, I'm using my old technique to cycle through the forms (570 or so) and check if I used the query builder to embed the sql in list boxes and combo boxes. It turned out there were only two...

Hi again. I wish it were that easy! The instance opened that way is changed and it is a nice way to "run" a query. But, it's not the actual query, just a copy of it in memory and it doesn't save. The code below opened all the queries of concern, and I'm just going to manually edit them now. I'd...

Thanks much - yep - after 20 years, this is a massive application (a facility management core) to which I'm adding other applications such as inspection software. I'll look at vtools, although I've started to play around with this: strOldCriteria = "[Forms]![Main...