Search results

I'll play with this a bit. Thanks, SKK

Again, I’m not sure if this is possible but… We have a FrontEnd/BackEnd database. The BE has an autoexec routine that runs a few update queries nightly. All works fine as long as everyone closes the FE (as well as a few GIS apps that link to the BE). However, if someone forgets to close all...

Bob, I believe I found my problem. On the first tab after the one in question, I added Me.Recalc for the Got Focus control. It appears to be working. Thanks for your suggestions... SKK

I'll try that. It's actually quite involved because there are a few other conditions that have to be met, but I'll keep you posted Thanks again... SKK

Condition 1 Expression Is [txtPERCENT] < 40 Preview is Disabled txtPERCENT is another calculated field (or control - not sure of the terminolgy) on the form. SKK

So when I tab to the next field, does the focus change or must that be coded? Tabbing does not change the color. SKK

I’m working on an ACC2003 form with conditional formatting set on a couple controls. I’d like to change the back color of one input field based on value in another field. It works fine when running Win2K but bombs on WinXP. One resolution I saw was coding On Activate to Me.Recalc. This...

To be honest JAL, I'm so confused myself, let's just call it a day for now. I may return to this in a bit for now... Thank you very much for your time and consideration. It truly is appreciated. SKK

I'm not exactly sure what you mean by this (I'm not programmer). I may have to dismiss this and hopefully find some other resolution. Thanks for your time, SKK

LABLE is the field in both tables noting a unique manhole label -- we do not have to create the field. If a LABLE value exists in tblLOCATION, then just update the ADDRESS field in tblLOCATION to the same as the ADDRESS field in tblACTION. If a LABEL value does not exist in tblLOCATION, then...

I’m trying to either create a query (or queries) or write some code that either updates or appends data from one table (ACTION) to another table (LOCATION). If a LABEL field value already exists in the table ACTION, I want to “update” the ADDRESS field in ACTION to the value in the ADDRESS...

Excellent - will try. Thanks for your time, SKK

Is it possible to modify the Row Source control of combo box (called cmbWO) on a form. I want to change the filter for the field SYSTEM (to either SAN or STO). I see how you can change the Record Source of a form but not sure about a specific fields Row Source on the form. Example- Click...

No stupid question - that was it (how silly of me). I was not aware of the Status Bar Text property. I was playing with the tab order last week and that's apparently when the status bar message change. Thank you very much RG. Like I said, this was not biggie, I was just wondering where it...

Yup, I placed it back in - just remove to test. SKK

Description fields are blank.

Sorry guys but I’m still confused (not unusual). There is nothing in any of the description columns. I did a search for “syscmd” and found one instance: isOpen = (SysCmd(acSysCmdGetObjectState, intObjectType, strName) <> 0) I remarked it out but still am seeing the "Continue working with...

Change to what appears. Currently they have it displaying "Continue working with existing work order..." This is fine, I was just wondering where this vebage is placed? SKK

I've noticed in some forms, the note in the status bar in the lower left corner change. Ussually this just says "Form View" or "Design View". How do I go about changing this on some of my forms when they open? Thanks, SKK

Here I go again, maybe asking for something that’s not possible. What I want to do is test if something exists in another database on the server. I can link the table, however this is on a laptop in the field without a network connection. Database = f:\sewers\new\portable.mdb Table = TACTN...