Search results

I put in a form error event, but it is not executed. I also put in an On Error GoTo statement, and that also is not used. I don't know of any other event handler I could use to catch it.

I don't know exactly, but I think the Owner.Column(1) was executed before it got a chance to execute the AQA and UQA functions. Anyway, as you can see from my post at 10:17 AM today(post #18) I separated out the particular portion of the IF statement and put it inside my TraceTxt function...

Which functions? The trace and tracetxt functions? They do run. I do get output. The AQA and UQA functions? I do have traces in them as well. I think I have the right tree, which is the owner combo box. That would be why the Tracetxt (Nz(Me.Owner.Column(1), "Null")) fails. Not everytime...

It is failing again. Even after I added the Me. It is failing at the same location. I've isolated it to the following statement. I get 33, but not 34 to my file. I'm getting "Null" for the third record, when it does not fail. Trace (33) Tracetxt (Nz(Me.Owner.Column(1), "Null")) Trace (34)...

The bound control Owner has a value list as follows: "1";"CDR";"2";"QA" With a column count of 2. And column widths of 0", and List width of Auto. That suppresses the index value (1 or 2) and only shows blank, CDR, or QA. I'm going to check for other column references in my database...

That is it! Wow, I would never have guessed! It works fine in the development version of Access, but fails (sometimes!) in the runtime. When I add "ME." is it not failing. I would have thought "me." would be the default, using late binding. Thanks much for the suggestion. What you think...

Interesting. In the runtime it is failing when it tries to evaluate the field owner.column(1), which is null. Owner is a bound value list combobox. The subform containing the combo is an integer value. I tried using nz, but it still failed. Trace is a routine to write a numeric value to a...

Thanks Bob. That is certainly an improvement over using msgbox. Perhaps I can just use a variable that I increment on each statement to save me the work of copying the statement. I have over 100 lines.

Paul, No problem in the full version of Access. No offer to go to debug mode in runtime. Cannot trap with form_error. Don't I need to use the full version to step through the code? It works fine in the full Access version. spikepl, Thanks for the tip on NZTOOLS. I'll give that a try.

I'm using the record navigator. There is quite a bit of coding in the current event. The frustrating thing is it is not consistent. Sometimes I can move through multiple records, like 1-6 sequentially. Then I close the form and reopen it and when I move from record 2 to 3 I get the error...

Yes, your right. I thought I saw it working on a accmb file, but testing it again, it also generates the same error. I'm also getting the message when moving from record 2 to record 3 on a different form (record 1 to 2 is okay). I have no missing references in VBA, having converted my Excel...

I get the following error in the Access 2010 runtime using an mdb. I do not get the error in the Access 2010 full version using an mdb or the Access 2010 full version or runtime using accdb. The close command relates to the form executing an event procedure. It successfully closeds the...

Yes, I did. It is the same routine I published before, faqChangePassword. I noted in the original post that it did not work. Now it works. However, I don't recall what I did to avoid the error. Perhaps I thought I was in the Admins group, but wasn't.

I have a 2003 database that is set for record-level locking. I have a form set for locking the edited record. I also have an unbound form to edit a field in the record. I pass the control to the form and it displays the content of the field (in a large window). This works fine until you...

Thanks Don & Bob. That works.

Don, The only object I found for the restore method was docmd. I tried using that, but it did not seem to have any effect on the minimized window.

Thanks Don, That does indeed work. However, I did find that if the user minimized the Access window then my dialog box appears in the upper left corner of the screen and the application remains minimized. Is it possible to restore the application and center the form within the application...

I'm trying to develop a message sub-system in my Access 2003 application. I have a form (hidden), driven by a timer, that checks if a message needs to be displayed. If so, it open a form with the message. It works, but the problem is when the Access application is minimized. It still...

I've tried the FE/BE idea. Its slows access down. It also complicates updates. This is a common suggestion, I've heard it many times, but after working with Access for 7 years I've found this is not a good idea.

The two databases have some of the same user and some that are different users. Also, some of the tables and forms, although different in the two databases have a name overlap. So, I don't think it is practical to use one mdw. For everyone's information, a poster by the name of Joan Wild, in...