I am looking for a simple text parser that will search a .txt file for
the words "Prefailure ", "Warning", "Error", etc. and send an email if
any of those words are found using a program called "Bmail". I am
using the Beyond Logic SMART script for monitoring hard drives - the
bmail program is on that same website. (http://beyondlogic.org/consulting/smart/smart.htm)
...
mpmason14
Last Activity: Jun 15 '09, 02:23 PM
Joined: Jun 14 '06
Location:
-
TXT file parser
-
thanks...but just to clarify what you just said...you DONT use the sum function if you want it totaled for individual records, just write an expression without any functions...
thanks for all your help. i got it set!... -
thanks, that does something...but it totals for the entire database.
how do you set it for just one record at a time? (ie. amount due for one customer)
i have done this before, but don't have access to that database right now and cant look it up.Leave a comment:
-
access form - expression
hi guys -
I have this formula that I want to use in a form to calculate the "amount due" for a text box. i have tried the text box as both an unbound text box and a text box with the expression below:
the result is a blank text box. there are no 0s in the other text boxes and the types are set to number.Code:=Sum(([dvdqty]*8)+([cdqty]*5)+([dvdcdqty]*11))
if anyone could help... -
no problem, but does anyone have a solution? i'm continuing to work on it but to no avail....Leave a comment:
-
heres how it works:
1. OPTIONAL TO USER: ssn entered on form
2. ssn saved in table when record saved from form
3. on opening the report, the reports control source is a query that uses the module code previously posted to verify if the ssn is not null, but will still open the report even if there are blank (empty string) ssn's.
4. because the report is based off a query, and that query has "built-in" error checking...Leave a comment:
-
that didn't seem to work.
I still get the "Must be 9 digits error" coming up when I try to open the report with a "0" or empty string in the SSN field. still trying to figure this one out.
thanksLeave a comment:
-
VB question on Access form
You may be familiar with this problem as I posted it before, so here we go...
I have a module that provides error checking for the length of a SSN and I need a
little help in one area...
The code will check to see if the SSN is 9 digits exactly, and if not it will produce an error message, otherwise it will cipher the SSN. The error message is part of the VBA (the 'msg' in the code below).
My... -
thank you, this really helps. now we can use this new feature!...Leave a comment:
-
thanks for the reply. i am trying to figure out how to incorporate that with my current code. here is my starting code (yielding run time error):
and the code with your addition (to start, still playing):Code:Private Sub SSN_AfterUpdate() Me!SSN = CipherSSN(Me!SSN) End Sub
...Code:Private Sub SSN_AfterUpdate() Dim MyString As String Me!SSN = CipherSSN(Me!SSN) MyString = IIf(IsNull(Me.SSN), 0, Me.SSN)
Leave a comment:
-
it is text because of the ciphering...the question is how do i suppress the VB error? is there some work around or way to hide the error?...Leave a comment:
-
code to ignore/catch null error?
I have a form with a textbox for entering SSNs and an AfterUpdate event procedure to encrypt it when clicked out of the box (not the problem)
the problem:
if i enter a SSN, save and go to the next record, and then go back to the record and delete the SSN, save and go to the next, i get a VB Run-time error 94 - "Invalid use of Null"
how do i suppress that error or handle it so it can continue on even... -
he is logged in as himself, and there is the local admin account that he will be logging into to get this resolved. thanks for the feedback...Leave a comment:
-
remote password reset
we have a user that is on his laptop at a conference. over the weekend he changed his password on the laptop but - surprise! - forgot the password. he is still away at the conference and needs to get into the network remotely using his account (for remote desktop).
is there a way to reset his password for the domain on his laptop without physically being connected to the domain?
i have looked into password reset tools,... -
finally! thank you very much. this will certainly help relieve some stress on my vacation:) thanks again...Leave a comment:
-
assistance? example code?...Leave a comment:
-
problem NOT solved :)...Leave a comment:
-
i tried that and i got VB run-time error 2465: "Microsoft Office Access can't find the field 'SSN' referred to in your expression."
the SSN is being pulled from a query that queries the employee table (where the encrypted SSN is stored) and the report has a textbox on it that has a control source of "ssn" off of the query.
all i want the code to do is decrypt the SSN back to a normal 9-digit's and...Leave a comment:
-
sorry about that, its a typo...the module name is cssn and the function name is CipherSSN ... very hectic today as its my last day.Leave a comment:
-
decrypting problem - dont get scared by the title
i have a form that i will be using when the user opens a report that asks the user if they want to decrypt social security numbers stored in the database or not. the module to do the encrypting/decrypting works perfectly, but when i try and apply it to the form on a command button (labeled "yes"), it gives me a VB runtime error - "Run-time error '424': Object required". i have the code below - i am using MS Access 2003. as...
No activity results to display
Leave a comment: