debasisdas,
I got enough VB to filter the text file and import it into Excel,
Thank you. :)
-DH22
DH22
Joined: Aug 29 '08
Location:
-
debasisdas,
Okay. Now that I have a direction to head, I'm gonna have to go hunt down some way markers so I'm not lost.
Any pointers / suggestions?
Thank you.Leave a comment:
-
Reading / Filtering a Log (Is VB a solution)
Hi there!
I'm looking for ideas / examples on how to read a log file, filter out content based on certain criteria that changes based on a date, and outputting the information into some format (maybe via an Access DB, or HTML, or Excel...).
Heck, I'm unsure if VB is even the best option for me, but I haven't many tools to work with nor the permission to download anything. All I have to work with is a standard WinXP... -
Stewart,
I thank you for your help in this, again! I'll definitely keep the recommendation in mind and will probably go ahead with it.
If I do find out any other solution, I'll post it here just for future searches.
Once again, thanks!!
-DH22Leave a comment:
-
Perhaps using the Query as a Make Table query and then running the form on that result? That would narrow it down.Leave a comment:
-
Take your time, I'm stumbling through with ideas, myself. Nothing ventured, nothing gained!
-DH22Leave a comment:
-
What about a filter?
I really don't know much about it, but could that help out? It would make the combo box less busy, too.Leave a comment:
-
Hopefully the attached dbase is what you were asking for. :)Leave a comment:
-
Yeah, sorry, Stewart. As I was adding the zip as an attachment, I got called away to a very long meeting. Ooi.
I'll be adding the zip to this post.
This is just mock information for security reasons, but the database reflects the real one closely....Leave a comment:
-
Alrighty, here's a very small example, only three records but that's basically it....Leave a comment:
-
Heh, I bet you're going to scold me for this one, but what do you think about this?
I can use the Inputbox to trigger Dlookup into returning...Code:Private Sub Command10_Click() Mystr = InputBox("Enter Account Number") MyAccount = DLookup("[Account_Number]", "[dbase]", "[Account_Number]=" & Mystr) MsgBox MyAccount End SubLeave a comment:
-
Hmm, well, I could give more details and see what you may come up with, idea wise. I'm up for anything that keeps it simple on my end users.
What information would you need, Stewart? I typed a few long paragraphs to try and describe the situation, but then I realized trying to wade through that wouldn't be very nice and I won't do that to you.
Here's a summary:
I have tif files linked to accounts, that's...Leave a comment:
-
Okay, how do I narrow the account list down to just a specific account? We're working on close to one million account numbers as well. I cannot possibly expect them to go through the entire list looking for one, right?
I may just be confused and being frustrating, which if so, I humbly apologize!
I feel real close to a solution thanks to your assistance, but the long listing just doesn't feel.. "right",...Leave a comment:
-
If it works with three files, it should work with a thousand, I'd image.
I was sort of thinking was it possible to have a form to retrieve the information, make it static long enough for a second form to use something (maybe Dlookup at that point, since it works with 'static' information).
But you understand where I am coming from, right, Stewart?
I basically need to restrict the range of data..
...Leave a comment:
-
I'd prefer not to do it with Access, either.
However, my problem is thus: My directory is huge, over thirty databases, one million+ files, and 500gb+ of information.
I need to be able to look up an image file and delete it. I will not know the directory or subdirectory in which the file will reside, though there are over fifty directories for each database with over thirty subdirectories for each (and climbing)....Leave a comment:
-
Stewart,
I'm not having much luck so far with the combo box (and frankly I'm not liking it very much, either. That's probably due to my lack of experience with it, though.)
While I work on learning to like the combo box, are there any other options you can recommend?
-DH22Leave a comment:
-
Stewart,
I will be doing just that. Thank you very much for your time and patience in this matter. Hopefully I'll figure it out. I've been using Access and VBA for a week and a half now, so I'm gaining steam.
-DH22Leave a comment:
-
I firmly admit that at this second I'm clueless on how to use the combo box, but I'll figure it out.
Would it be possible for you to point to some reference material? I will be hitting google quite hard here, in a bit, as well.
-DH22Leave a comment:
-
Stewart, I will search around to see if I can find some more details for that, but what I am after is very possible, right?...Leave a comment:
-
Hey, that did work, Stewart. Thank you! I'm still very fuzzy on the criteria, but I'm practicing.
However, the reason why I need the query is I will be setting up a Dlookup to use in conjunction with a delete function.
I'm trying to think of the best way to phrase this..
I have a database with records that point to files. Field 1 points to the directory, field 2 points to the sub directory, field 3...Leave a comment:
No activity results to display
Leave a comment: