Search results for query: *

Thanks a lot! That worked just like I wanted it to. Thanks again.

Here's an example of one: A. Ecess value of ticket. B. IRS contact. C. Tax-exempt number. D. Tax form number. They were entered on a form. After every choice, they would hit the enter key on the keyboard. Hope this is enough information

Hi Remou, When I tried that query, it split them really weird. For ItemAnswerA, in the new table, the values were all "A." For ItemAnswerB, they were on the line of "nn." For C, they were "I." For D, "ur." And For E, they were "do." The query did split the field, but not the way I wanted it...

Hi, I have a field in a table that currently contains the multiple choice options for tests. Here's an example: A. 4 B. 6 C. 8 D. 10 E. 12 What I want to do is to split this field up into 5 different fields. Currently, it looks like this: ItemAnswers A. 4 B. 6 C. 8 D. 10 E. 12 I want to it...

They are at a one-to-one relationship through an autonumber field.

And also about splitting the tables, would you do it in my case? Thanks

What is the problem with doing that? Could they mess something up? Or is it for security reasons?

Do you think I will experience performance issues in my case? I definitely do not have more than 255 columns or anything of such. I also do not have any security issues in which I need to split tables. My current users actually prefer that everything was in one table because they say that it...

Hi, Currently I have a database that contains four tables. One table contains item question, answers, key, keyword. Another contains author, level 1 classification, level 2 classification, item type. The 3rd contains case text and case title. Finally, the 4th contains graphic title and graphic...

Thank you guys. The .mde file worked fine after I compiled/compacted in Access 2000. I think that this issue has been solved. Travil, Thanks for the code, this is going to be helpful in another part of the database. Thanks again.

Come to think of it, the reason why I stopped using .mde files was because I kept recieving errors (program unexpectedly terminated....) when I ran them. Here's what I do. In Access 2002, I first compile the application. I then compact and repair it. Next, I open the file with Access 2000 and...

Thanks for the tips. As it stands right now, the people that I have using the program do not have a very knowledgeable computer background. Something like #3 that you described above will surely do the trick for them. I am just wondering if I could put that code into one database and have it...

Yes, that is what I had going. I had one database open the main database (with tables, forms, etc.), which was password-protected. The main database lets user input data and so forth. What I am trying to do is to protect the main database so that the user cannot access the forms' designs and...

Hi Trevil, Yes, that helped quite a bit. How would I protect my main database if the password is removed? I do not want to make it an .mde file because for some reason, the machine that is running Windows 2000 has issues when running .mde files. Any suggestions? Thanks

Hi, I have the following module run when the form loads. It works fine under Windows XP, but under Windows 2000, the form freezes and just stays there. It is supposed to close, but it doesn't. Here's the code from the module: Option Compare Database Private Declare Function apiShowWindow Lib...