Search results for query: *

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.

Thank you this works fine. Is the syntax **** Is null therefore wrong in all cases or when should I not use it?

In an on click event the following: &quot;If Forms![Guests]![Guests Subform].Form![CheckOutDate] Is Null Then&quot; elicits a runtime error 424 message. In the same procedure &quot;If Forms![Guests]![Guests Subform].Form![Amount Due].Value <> 0 Then&quot; runs properly. Could anyone explain...

Thanks all! I finally came up with one similar but not quite so eligent as CClint's second version.

I am trying to write a program to check whether or not a CreditCardDate, expressed as 0204 where the first 2 digits are the month and the last 2 are the year, has expired. The following only works if the card month is less than the current month. It doesn't however recognize that 12/01 is < Now...

Using DPW I created a deployment package in a single cab file. When I run the setup however the program asks for disc 2 of which there is none and accordingly the setup shuts down? Any thoughts would be welcome. Thanks Jim Baird