Hi all!
Recently i need to urgently perform an audit trail for my newly built system. I have gone thru many threads about using trackchanges() function at beforeupdate to record the changes made in the form. However this method works well only when the changes is made directly thru forms.
In my system, user can make the changes either by entering data directly or through clicking buttons with queries, how can i also track the...
zadkiel
Last Activity: Oct 29 '07, 09:03 AM
Joined: Jun 13 '07
Location:
-
Perform Audit Trail in Access to Record Changes via Query
-
How to use input paramters in query again in macro
Dear all,
I have a delete query for users to delete a specific period of data. the SQL of the query is:
DELETE [TRADE].[TRADE_DATE]
FROM TRADE
WHERE ((([TRADE].[TRADE_DATE]) Between [Enter a specific start date (dd/mm/yyyy)] And [Enter a specific end date (dd/mm/yyyy)]));
And I want to use macro to display a msgbox to let user to confirm the date he has entered, I create the condition... -
oh I changed
intStringCursor = 5
then it works PERFECTLY WELL!!!!
THANKS A LOT!!!!!!!!!!... -
Thanks a lot but the result comes in this way:
FT
FT
it only captures FT...Frustrated...Leave a comment:
-
Extract Substrings in Strings before other datatypes
hi all
I got a urgent problem in my job.
the sample data as follows:
FT="EXERPRI:$68 .88/10W*BB9505-28765710"
FT="MEETON6/3/07FOR
What I need is to extract the string after the quote and before any punctuation or integer so my outcome can be like this:
EXERPRI
MEETON
...Leave a comment:
-
Extract string before integer
hi all.
I got a urgent problem in my job.
the sample data as follows:
FT="EXERPRI:$68 .88/10W*BB9505-28765710"
FT="MEETON6/3/07FOR
What I need is to extract the string after the quote and before any punctuation or integer so my outcome can be like this:
EXERPRI
MEETON
I use the SQL query as follows
SELECT Left([freetext],InStr([freetext],isnumeric())-1)...
No activity results to display
Leave a comment: