Orally,
Just got back to this. I am performing this code in a report not a form. What event handler would you suggest I use to connect this code to?
kimmer
Last Activity: Feb 18 '11, 05:44 PM
Joined: Jul 29 '10
Location:
-
Thanks for the code. It makes sense. I have programmed in the past and am new to Access. I do not understand where this code would be inserted. I have done macros on events for forms, but not on reports. How or where would I insert this code?Leave a comment:
-
How to compare data between 2 consecutive records in a table
I have a database that records results from devices that uses an algorthmic code as its meter. I capture from and to readings. I would like to compare readings between 2 consecutive records to see if there is a gap n the readings. Therefore, I would like to compare the "TO" reading in one entry to the "FROM" reading in another for gaps. -
Subtract 2 hex fields for a report
I have a database that has 2 8-character hex fields. I defined as TEXT. The field has leading blanks since hex field is right justified. I want to subtract the two fields for a report. I tried to convert the hex field to an integer using the VAL("&H[hexfield]") but it only returns the value 0. Is this because I have leading blanks? Any suggestions for this report field? -
Thanks for the help. It works great.Leave a comment:
-
Autofill on combo box doesn't present all matches - just chooses 1st
I have a form where I enter several forms for a specific device which is serial numbered. The form starts with the entry of the serial number which I validate against a table with existing serial numbers. I used the combo box feature. When I enter the first character, it assumes the first key that matches and does not display the 20 other keys that has the same first character. I would rather the combo box displays the narrowed results as I type... -
Editing an 8 Character Hexadecimal Field in a Form
I am designing a form for a data entry function where two fields that are entered are hex (8characters). I want to edit this field for valid hex numbers. How do I do this? -
I am coding a validation rule on a form for a field that is entered in hexLeave a comment:
-
validation rule for a valid hex value
i am validating entry for a field which is an 8 character hex field. Do anyone have any suggestions to how I code this validation rule?
No activity results to display
Leave a comment: