Recent content by darag2358

Thank you, that is an excellent tip and explanation!

Thank you! Appreciate both of your thoughts. I will put them in to place and see if it helps. At least it is good to know that my code is basically correct, since this is the first time I have tried to import a text file in this manner. Thanks again, Dan

I have a big messy text file that I need to import and extract information from to go in to two tables. These are our mainframe security access rules and I need to compile the information from this file in to a database so that I can see who owns and has access to what screens. The file is...

I don't think I have enough knowledge to have even thought about that. This is a bit of a jump for me, not that I couldn't learn quickly. The databases I have created in the past have been primarily just for me and a few others. Can you provide some basic information or maybe know of a...

We are developing an Access 2002 database that is going to be used as a problem tracker for technical system issues. It will be used by about 20-30 people. At normal levels, about 7-10 people will be actively using it. The database will be stored on a Novell shared server. The tables will be...

Yes, that does make sense. I will try to implement that logic. Thanks for the help and taking the time to respond.

I am doing a database that keeps track of mainframe security access. If someone goes to a certain screen on our mainframe, their ID must pass verification on some behind-the-scenes access "rules". I am documenting what each rule does, what mainframe system the rules are for, and what rules are...

Yeah, I was thinking about that last night. The first field in the table should be broken apart further. That will probably solve my issues. Thanks for the post.

Thanks Fornation's response was very helpful and is what I used to get my table set up. Doc_Man, your information is laid out perfectly for me to understand. I plan to use this information so that I can more easily automate this. This text file changes sometimes daily so it would be much...

I have a lot of "Or"s in my query. I know there must be an easier way to write this, but I'm too new to this stuff. I was able to save the query, but now I can't go back in to design view because it says I have exceeded the 1024 character limit. It just takes me to the SQL code (see below)...

Thanks again. I modified your Excel macro slightly to suit my needs and was able to get this in to a usable table. Appreciate the help. Dan

Thanks, Fornation, but I have over 80,000 lines which exceeds Excel's max. On second thought, maybe I could just split this in half and then try what you have. I'll let you know on Monday. I too like Excel better for manipulating data and getting it in the order I need. However I'll still...

One unit will have access to multiple screens, so a many to one relationship exists. Here's a sample of actual data. As you can see, HOIO*0269 is listed multiple places. The entire file is about 30,000 lines. The "Key" is the screen name on the mainframe. Field1 $KEY(TG03) TYPE(CKP)...

I'm trying to import a messy text file in to a table so that I can run queries. How should I cleanup and organize my table? The information is a data security report that shows what kind of mainframe access each area in the company can have. When I import the file, it comes in as one column...

Oh, duh...can you tell I'm new to Access? Thanks!:o