Search results

Not shure what you mean by your last post, but if you use the query as a recordsource for a form or report, you'll see the 'Expr1' in the field list, and can drag it as a field to the form or report. In general you should not store a calculated value.

Try importing the db into a new db, and see if that does it.

Not in the criteria, but in the first row of a free column in the query. (the place where you normally see your field names). After entering the line, Access will add Expr1: in front of it.

Yes, bring the two tables together in a query. There is a relationship between them- yes? Pull down the datefields (and other required) and enter the previous posted line into the next free column. Enter it in the field row

Try this in a textbox and set the recordsource for it to =DateDiff("d",[FirstDateFieldNameHere,[SecondDateFieldNameHere])

Hi there 'down under' Is there some specific reason why you keep the date, month and year numbers separated instead of using a Date format? I've made a query which pulls up the 12 months after a input of a month/year number. (0201 = february 2001). If you had used a Date field you could have...

Here is the exact code I'm using. Copy and paste the code int your BeforeUpdate Event of the control. Remember to change the name of the Me.MyNumberfield to your controls name. Post back if you still have problems. Dim lngNumber As Long lngNumber = Me.MyNumberField * 100 If lngNumber Mod 25 <>...

I've just tried it out, and it works as it should. It must be placed in the Before Update Event of the text box control you are validating.

Yes, it should be placed in the before update event. I'm trying it out now just to test it. I'll post back.

Try this; Private Sub FieldName_BeforeUpdate(Cancel As Integer) Dim lngNumber as Long lngNumber=Me.FieldName*100 If lngNumber Mod 25 <> 0 Then MsgBox "wrong input " Cancel = True End If Exit Sub Haven't tried it, but I think it will work!

Here's an example db and a dll file which you'll have to add/register in the VBE ->Tools->Reference. You can then turn mouse wheel on or of programmatically. See the sample db in the zip file. I've tried it, and it seems to work great. You must first register the dll file, or yo'll get an error...

Jennie, Try importing the db into a new db (with the data). I had same problem and got it working after I did the import. Gerhard