Search results

Just thought I'd throw this out as an FYI. My employer recently migrated to a new version of Citrix virtual hosting, and now even portable software and the no-permissions version of MZ-Tools will not run. I'm afraid this type of lockdown is going to become more and more common. Time to...

Okay you won that round. :cool: I work for the DOE in a Facilities team. When people hear that "F" word they automatically think "broken toilet", but we are spending our money doing seismic bracing, bridge installs, etc. My team is viewed as somewhat optional since we don't produce or transmit...

Guys, Thanks for the information, there is some good stuff here and I like where you were going Doc. Unfortunately I am working for the government and in a less visible department. Buying off the shelf software is...hard. My group is still on the waiting list for a CMMS package. Ten...

Apologies Doc, let me see if I can clarify the situation. This is our workflow: A project is scoped out and a budget is drafted. There could be several budgets drafted per project, exploring different methods of achieving the project goal…but ultimately only one “approved” budget when the...

I'm wrestling with how best to implement change tracking in a smooth way and thought I would see how other people have approached it. I am tracking budget data and the change actions that occur over time, with approval state and the needed to see prior configurations, not just creating a...

Excellent points all around. Some gut level response made me reject the idea of temp tables, but really with a split database the objection is moot. Thank you all for the great feedback and links

What I mean is that I currently have one function that creates a disconnected recordset and then a second function that populates it. Then a simple Me.Recordset=ADORST I am not using SQL server or any other source beyond an Access back-end file. Did you mean that I can somehow pass that...

I'm considering a temp table as my next step. I've always just been personally averse to them because of bloat (even when it is not truly an issue). Just personal preference, but I may be going that direction as it appears to be the best option.

You know, in all of these years I've never done a passthrough. This sounds interesting...the records do not need to be updateable. Setting up a passthrough seems to be based around SQL connection strings. How is that reconciled with a virtual adodb recordset? Right now my FORM_OPEN event...

Thanks for the very quick answer. This is a bit of a head scratcher now. Redesign of the form and recordset (this is a big job - lots of complex data), or proceed with the column functions broken. :banghead:

Morning all, Having an interesting error I just can't seem to resolve. I have a datasheet that uses a disconnected ADO recordset - it's a master list of projects and my managers wanted columns that represented data in differing structures, so using a standard query as a source couldn't be...

I can't believe this hasn't received more attention. Thank you CJ, this one is very handy and easy to use.

Thanks for the response. I found the issue (sort of). I created one of files using the software from Accessribbon DE, and created the other one by simply importing basRibbonCallbacks from somewhere else. For some reason the functions in one would not return images at all. I swapped out the...

Yup, no issues with the references that I can find. The issue is that I don't where the images are being sourced from. For my regular ribbon, there is the subfolder and that is kosher. In the working copy, I can't find the images anywhere yet they show up. I'm thinking maybe they are in a...

OK, so I got the layout to work properly, but the images still don't show. I have a test database from a couple years ago where I used this XML and it works, images and all. Copied to my current one, and nothing. Any insights? <backstage> <tab idMso="TabInfo" visible="false"/>...

Howdy folks! I’ve been struggling with the backstage portion of my custom ribbon and I can’t seem to make it work. I know that this can be done as I’ve found examples, but for some reason this just won’t layout for me. The second (hopefully small) issue is that my ribbon pictures do not...

That is an interesting idea. That is simple but covers the scaling consistency issue. I was trying something similar once...if no values were found at a hierarchy level, ignore it and use the numbers above. The other thing I am doing at the moment is playing with a treeview demo because the...

I've get what you are going for - doing all the dates and funds at the activity level rolls up fine, and it does in my current dB. I think the issue is more of a perception problem from my users. The PM doing your first example is not willing to expand the Phase down to that single Activity...

One of my attempts was done this way, but was rejected by management because it required users to log even simplistic projects down to a high level of detail. Some projects we really don't know (or care) about specific activities, just that it gets done.

Thanks for the replies! A lot of my trouble with this are the constraints the company wants...they of course want easy scalable data collection that takes little work and provides excellent metrics. I am also stuck with the terminology given to me, so I understand the confusion, particularly...