Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. infdarsas

    Splitting One Table Field into Five Table Fields

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

    Splitting One Table Field into Five Table Fields

    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
  3. infdarsas

    Splitting One Table Field into Five Table Fields

    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...
  4. infdarsas

    Splitting One Table Field into Five Table Fields

    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...
  5. infdarsas

    Single or Multiple Tables

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

    Single or Multiple Tables

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

    Single or Multiple Tables

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

    Single or Multiple Tables

    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...
  9. infdarsas

    Single or Multiple Tables

    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...
  10. infdarsas

    Module freezes when run under Windows 2000

    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.
  11. infdarsas

    Module freezes when run under Windows 2000

    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...
  12. infdarsas

    Module freezes when run under Windows 2000

    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...
  13. infdarsas

    Module freezes when run under Windows 2000

    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...
  14. infdarsas

    Module freezes when run under Windows 2000

    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
  15. infdarsas

    Module freezes when run under Windows 2000

    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...

Part and Inventory Search

Back
Top