Search results

This is usually a sign of a corrupted database. You can try to repair the database with the Repair Utility built into Access or the Jet Compact Utility that can be downloaded from Microsoft. If these do not fix the problem you will need to revert to a recent backup to recover. HTH RDH

Number of controls and sections you can add over the lifetime of the form/report is 754 ...... If you have anywhere near this amount I suspect you have serious structural problems in your application. To reset the control count on a form/report to the actual number of controls .... create a...

If there is nothing selected in the listbox .. there will be nothing to populate the txtbox with .... RDH

Sounds like the line you are using to populate the txtbox is after the line to opens the form ... move the line to populate the txtbox above the line to opens the form. HTH RDH

No problem ..... You are Welcome ... :-) RDH

You should not store the calculated result .... The proper thing to do is to store the qty and the "price at the time of the transaction" in your main record ... then you calculate the result when needed dynamically. This also goes for a "Tax Rate" ... you simply store the "Tax Rate at the...

To to this at form level directly in a control on a form ... use: = Format([MinutesField]\60,"00") & ":" & Format([MinutesField] Mod 60,"00") "MinutesField" should be the name of your field that contains the numeric minutes value. If you want to do this at query level .. create a "field...

Question is ... why would you want to do this ??? It would appear that you would end up storing "redundant data" and also it would appear that possibly one field of information would be dependant on another field of information .. which is not a good thing. RDH

You should do this using the forms' "On Before Update" event. This event will only trigger if you are all on a new record or if any data is altered in an existing record. HTH RDH

Jack ... you and your "fields" ..... LOL .... "controls" ... Jack "controls" ... LOL "Fields" are in Tables and Queries ... "Controls" are on Forms and Reports. RDH

You are very welcome ..... :-) RDH

Use the "On Current" event of your form: If IsNull(lstBox) Then lstBox = lstBox.ItemData(0) End If Change "lstBox" to the actual name of your listbox. HTH RDH

See if this article will help you .... Nothing Happens When You Try to Start a Microsoft Access Wizard HTH RDH

That is "Great News" ...... :-) You are very welcome. RDH

Hmmmmm ....... Instead of working your timer to death and eating up valuable System Resources by triggering the code every second ..... Depending on the accuracy needed .. I would only check every minute. I would create a "Public Variable" in a module to increment by one until it reached 720...

My bet is that you are using Access 2000 (original release). You need to install the SR1 service release to fix this problem and others. Actually you need to install SR1 then install SP3 .. to fix many other problems in Access 2000. Here is a link that will get you going: How to Obtain the...

Use the Month() function to get the numeric equivalent. HTH RDH

The age should not be stored in your table ... unless you need to store the "Age at the Time of entry". You can use this expression to correctly calculate the persons age" DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month([DOB]), Day([DOB]))) HTH RDH

I answered this question at another forum .... But for those who may be curious: This is a table level error and can not be trapped in the event you are using. It must be trapped using the Forms' "On Error" event (error 2113). HTH RDH

No problem ... you are welcome ... :-) RDH