Search results

This was not an issue of misnamed objects. It was an issue of events firing in the wrong order and calling an object whose creation was bypassed when the references to the object were called. Update: Got it to work finally. Here is my solution as is based on Minty's suggestions to control the...

Or are you taking about Name on the Other tab of the form's Property Sheet. I see the object has a name and a source object, right now mine are the same. I may or may not change them. But I do see your point about the "container" name versus the source object reference. I do understand the Name...

I would like to, but I cannot. It has a very complex structure. It uses three/four databases, one Global, two on a server and one on the local HD. The Global and 1 server one are Encrypted Back Ends. The other server one serves and the install piece to put the front end onto their machine...

You lost. There is a control called subFrm_SuperValidChkBox. But I think I found the reason. Just posted my explination of the problem.

Misaligned processes was may original thinking as well. So I did some Diagnostic Testing. I commented all of the code out of the four forms' events and they fire in this order: frm_subfrm_SuperValid Open has code and I suspect the offending line of code that causes the issue...

Sorry no the program I am building is on an offline system. Also it would be to difficult to replace the actual data with test data.

The main form houses the user being looked at. The main Subform holds all the data that applies to the user by business days. The subform_SuperValid holds the information that the Superintendent validates is correct, the subfrm_SuprValidChkBox displays different boxes depending on which business...

Issue I have a Main form and a main Subform, with that subform have two additional subforms. Both the subsubforms have controls on them all of which I want to manipulate, make visisble etc. Main form is frm_SuperValidation, Main Subform is subfrm_ScenBal_Valid, with two subforms of that form...

Thanks for the spotlight on this.

Also, I am exploring the concept of a virtual recordset. Using the concept from ELookop where a remote recordset is opened, specifically tgtdb.OpenRecordset(strSQL, dbForwardOnly). Well could not this be used to create a remote recordset and then bind a local form to that recordset, virtually...

Agreed. I killed all of the OnCurrent code because like you said nothing is changing. Did you checkout the ELookup Function I Left for everyone. Its basically remote DLookup Capability, without the need to connect tables. You posted earlier that you had a failed attempt at making DLookup...

Thanks. Also Left a Function you might be interested in. It allows remote DLookup Capabilities, without connecting the tables to the Front End. It does require a Set dbObjVariable = DBEngine.OpenDatabase statement though, but after that works great.

Here is the function that I am using in my final solution to use like DLookup Functionaly but in a External DB without existing table links to the referenced tables. Again not solely Mine. Please if you use please keep the Author Information. Also please remember I am hand jamming this in...

I Had an idea that it was that. But I took Your Idea of unbound fields and amped it up, Made everything unbound and looked up everything remotely via Code and then plugged it into the form fields. I created a ELookup function from Allen Browne's ELookup implementation that does on a Remote...

Solved my problem of getting the data from the backend without actually linking the tables . I implemented a version of The_Doc_Man's concept of unbound objects. I created a global TestFdBk_CACID to store the targeted CACID for the feedback form to display. Sometimes it the user who took he...

Thank you all for your responses so far. Seeing that most people agree that the DLookups are the issue and linking the tables in some way might be the way to go. But directly linking the tables is impossible. Each row in Test_Data has 50 links to the Test Table via the first three digits of the...

Please look at my reply to Galaxiom regarding your response about joining the tables, which is not really possible. Thank you for your reply.

I agree, and I know how to do that already. Thank you for your response.

No this is not an updateable dataset. I am building the test feedback display. So it just displays static results. The form is not really necessary, but wouldn't creating the report data require the exact same data set? The vbCrLfs are not the issue, it only adds to the clutter. The problem...

The query loads in about a second when run on either location. No real delay in performance. the Test table houses the complete list of available test questions within their "Templates" Each Row is a new Template Has these fields ID (Autonumber)(PrimaryKey) (this is not related to anything)...