Search results

Well, I'm still waiting on our IT guys to respond to that request. We cannot download & use external software. In the meantime, is that function intended to lock the WHOLE program? And why would it lock the program for others who have not set a password? How are they supposed to get in?

That's it...but I've got bigger fish to fry. Actually, that's all I have. I don't have rights to the program that spit it out. Another user forwarded the data to me (although I DID tweak it a bit before posting it to make it confidential). If you want, I can generate more data by cutting &...

Thanks, but no... Nope, did not work. I can get along without the database I was working on. I saved a copy in case I screwed up, but I have managed to lock myself & any other user who logs onto my machine out of Access itself! I can't create a new database, I cannot go into an old database...

I'm Locked Out!!! HELP! HELP! HELP! :eek: HELP! HELP! HELP! I have messed up in a BIG way! I was experimenting with database security for a new database containing confidential information. The help file and the book I was using said I needed to set a database password, but did not give...

What did you mean by this? Is this something I need to do to the data before import?

Thanks, but what about this error message...? Thank you so much for this! I am working with it now. When I run it, this line: Dy = Trim(Mid(TDate, Comma - 2, 2)) Gives the error message Run time error '5'...Invalid procedure call or argument Any suggestions on how to get around this?

Yes Yes. Just irrelevant labeling.

The file name CAN be the same every time if that is what I train the end users to do, so Yes to that. Here is the data again... SPECIAL REP ORT 1 Date Of Contact Number Location of Event Issue Codes Section Involved: Clinic 1 123.04098 "FEB 2,2004" OPT AREA X0A Referral...

Sorry about the confusion with the double-post. It occurred to me later that I had posted it in the wrong place, and I was worried that the right people would not see it. I was also trying not to be TOO wordy. Thank you for responding. Here is some sample junk data that is similar to the...

Sorry! I'm sorry. Since no one had replied, I was thinking that I had not posted to the correct forum. I have been working on the problem at this end and it occurred to me that this forum was actually the more appropriate one. I thought that the folks who review THIS forum might not see the...

Sounds interesting. Does this Monarch clean up the data before it goes into Access? Is it easy to use? Can I use it with Access somewhat invisibly? I am looking to make a button that the end user can push to import the data without having to think or know much about what is actually taking...

I am trying to write a macro that will import a text file. We download reports from another incompatible program to text files that consistently have the same number of irrelevant leading lines at the top. I want the program to ignore the first four lines (or records, if they were successfully...

Help? Anyone...Anyone?

I am working on 2 separate databases for two departments, each of which has a private folder on a server (set up as private on Windows 2000 Professional on a network based on individual names) One department wants to extract a particular item of data out of the other department's database...

Help? Still looking for any suggestions anyone can offer. Thanks!

I am trying to write a macro that will import a text file. We download reports from another incompatible program to text files that consistently have the same number of irrelevant leading lines at the top. I want the program to ignore the first four lines (or records, if they were successfully...

I am working on a report with various levels of headers and footers. I have one footer based on Location, which is counting the ID numbers for each field that is in that Location like this: =Count([CategoryID]) (the field is named txtCntCategoryID) As you can imagine this Footer gives me...

Is it possible to tweak the wizards so that when you create a form or report, the fields are named using a nomenclature YOU want so that you don't have to go & rename them all and fix all the calculated summary fields? (Examples: lblMyField instead of MyField_Label or cboMyData or txtMyData...

Ah committees! The committee could not decide whether or not they wanted to capture demographic data. Then they decided to keep it and add an optional name line so that they could contact folks who did leave their names. Just as an FYI, this database is for departmental data entry from paper...

Now what? I am a bit confused as to how to proceed. You guys have been wonderful with assisting me every step of the way with this thing, as I have been learning VBA as I go with this project. Don't even ASK what it looked like before you guys stepped in. However, now I seem to be getting...