Ok, so I dont seem to be getting anywhere.
Imagine you have a datasheet that has 7 columns (fields) with about 100 rows of data in it.
If a user happens to change the 3rd coloum in row 68, then how can i dtermine programitcally that this column was changed?
The afterupdate event triggers, yes, correct, but the trigger isn't the issue, its getting the column/field changed and value that was changed.
(as i said if it was textbox...
jacjacjac
Last Activity: Mar 8 '13, 03:02 AM
Joined: Dec 20 '12
Location:
-
Regular expression in VB6
Hello,
I am wanting to use regEx (regular expression) in visual basic code (vb6.0)
I have one field on a form that will get inputs from a user in the following format, (note the 3 numbers of the end will change)
HNPSD/001
HNPSD/002
HNPSD/004
HNPSD/999
etc
I need the pattern/rules/constriants for this text format, so how to ensure that the HNPSD/ is always entered and... -
I understand the methodology behind what you are/wish to achieve but i need a piece of code to get the field value from a datasheet. Thats the part i can't do, if it was a textbox on a form it would be NameOfTextbox.V alue, but this is a value in a subform datahseet on a form. Any code would help?Leave a comment:
-
Hello,
Topic: Auditing results in a datasheet (which i have learnt is more similar to a FORM than a table)
So I now use the AfterUpdate method/function/sub and it triggers when a field is changed.
The question i have is how to determine exactly what value was changed, if there is 100 records and i change the 10th one, it triggers when i leave the field so can i extract the value (in the field) that was changed (ie,...Leave a comment:
-
Track changes of raw table data information
Hello,
NOTE: Im working in MS Access 2003, result in ACcess ONLY please
Ok this might be strange or not possible;
Im creating an audit trail for users actions in a form, to monitor and keep track of what fields were updated/entered/removed from the database, these actions are essentially done from command buttons (and the audit trail, is coded on the button click)
However, I have a few... -
Access SQL ORDER BY putting NULL values last in query
Hello,
NOTE: Im working in MS Access 2003, only results in this SQL/database (not mysyl, MSSQL etc)
I want to be able to ORDER an SQL query and put the NULL values last.
I have a basic databse:
Table name: PeopleTable
Field names: TableID, PersonField, PersonID
The aim is to order by PersonID and put the NULL values last
I use the orderby SQL statement...Code:SELECT
Last edited by zmbd; Dec 20 '12, 01:44 PM. Reason: [Z{Please use the <CODE/> button to format posted code/html/sql}]
No activity results to display
Leave a comment: