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...

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...

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...

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...

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...

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...

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

I have a report that has a Yes/No control. I would like a result only to print when the control value is -1 (Yes). For No I would like to leave the text box blank. More emphasis is afforded if the &quot;Nos&quot; are blank than when I try to find the &quot;Yeses&quot; amongst a sea of...

How can I setup a table linkage for deployment when I do not know to which drive the client will install the application? e.g. Initially the linkage is to a backend on drive C: If I run the deployment package and install to a different drive however the linkage is broken and if it is a...