Search results

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

I want to cleanup a table by searching record by record for the text "HGIO". The text may be inbedded within other text. If it is there, go to the next record, if not, delete the record. I'm new to VBA in the Access environment, so any help is appreciated. Running Access2002. Thanks This...

Never Mind I did a quick search in the forum and found the answer in a previous post.....should have done that first.

I have a macro that runs some delete and append queries and I want to know how to turn off the message boxes when it asks you if you "are sure you want to delete...." I know how to do it in Excel VBA, but I can't find the equivalent in Access. Thanks.

thanks Will do.

that fixed it, thanks Looks like I've got a lot of work to do. Appreciate the help.