Recent content by Orcanut

Installed Access 2002 mde file on Windows 98 machine updated to Access 2002 from 2000. Shortcut or mde file from expolorer opens with unrecognized format error. If I open Access 2002 first and then the file from there it works fine. Microsoft says problem fixed by installing service pack 4 or...

Many thanks. Does the Trick

A control button opens a form which inturn processes a series of events at the end of which I would like the form to close. If I put DoCmd.Close acForm, " " in the last line of button click event of the control button I get an endless loop I have to close with Pause break. If I put...

That did it Paul. Many Thanks Jim Baird

Thanks I tried both neither works. The problem is RegistrationID either exists because the other criteria in the query are in place or it isNull because the query returns no records. If the query returns a RegistrationID I want a new form to open to work on the results of the query otherwise I...

The following code is supposed to open a new form (Notation Final) if the query on which this form is based contains data or close this form if the query has no data. It attempts however to open the new form in either case? Assistance is appreciated. Private Sub Form_Open(Cancel As Integer) '...

I have a form based on a query "Notation Payment" with a field Authorization. This form runs a macro which returns a new value for the Authorization field. I can physically change the Authorization value in the Query Builder screen if I run the query but the following code: &quot...

Many thanks will give it shot.

The Refresh is necessary because the Label is getting a series of messages from an outside source - a PINPad. It will show the first line of input but then hangs when the next input comes from the PINPad because the Label is not refreshing. In a VB test bed it works fine but not in the Access...

The following function works in VB. When I try to utlize it in an Access application however Refresh does not appear to be a method available to my Label30 control. Is there some work around? Thanks Function Commentary(nts As NullTermString) As Integer frmSampleCreditCHEQ.Label30.Caption =...

I have a 500mhz Dell latitude laptop with 256K Ram and a 75mhz Dell Tower with only 128K Ram. When I open an Access database to edit an event procedure on the laptop I get a Microsoft Visual Basic out of memory message and the database locks-up. I don't get this message when attempting the same...

Thanks for your assitance Randy. I circumvented the problem by using a delete query and an append query to replace the make table query.

Will a make table query run in Access runtime mode? I keep getting undocumented error when I try and assume this might be why. Thanks

I have a procedure which when certain criteria are met change a control to "date". The table where the "date" is stored is formated as a short date but basic date stamps the "date" with the time when the procedure runs. e.g. 11/06/02 "sometime". My Problem...

Many thanks.