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

    Service Pack Updates - HELP!!!!!

    I am attempting to install SP6a and I receive the following error---- "Service Pack Setup Cannot Determine Whether You Are Running Windows NT Workstation or Windows NT Server" It then bombs HELP Randusoleis.....
  2. randusoleis

    Documentation

    In regard to documentation of databases, is there a way to document the database structure? Access 2000 has the Analyze tool....what about SQL7.0 Randusoleis.....
  3. randusoleis

    One to One Relationship - Automatic addition of records in the other t

    I would also agree with Jerry. You may want to re-examine your structure. Stay away from 1-2-1's. 1-2-Many and Many-2-Many is the way for total relaxation. Randusoleis.....
  4. randusoleis

    One to One Relationship - Automatic addition of records in the other t

    I just did some reading up on 1-2-1 relationships as I don't use them. As you said before you split the tables because they had too many columns....so your subform groups only show a piece of information that was originally grouped together. Here is my question.....If you need to change...
  5. randusoleis

    One to One Relationship - Automatic addition of records in the other t

    In access you can not create a Form/SubForm with a one-one relationship or a Intermediate Relationship. In your stores table you will need a field that is numeric/long integer that will match the Primary field (AutoNumber) in your Areas table thus creating a many-2-many relationship. This will...
  6. randusoleis

    Insert to Results

    Tell me about Pearl Randusoleis.....
  7. randusoleis

    Insert to Results

    I have created an Insert page and I would like to see the results of that page on a results page. How can this be done. Randusoleis.....
  8. randusoleis

    Show Dupes?

    I have transfered data from a dbf into Access and found that I have multiple dupes out of the 28,000+ records. I need to find these dupes and delete them. How can this be done. Randusoleis.....
  9. randusoleis

    Multi Pages and Parameters.....Please Help

    I am creating a site that has multiple pages. Searches, Results, Update, Insert...the whole nine yards you could say. Here is my question-> I have a results page I want to give the users options on. For example, my tables are set up in a way that 1 table has Children and another has Parents...
  10. randusoleis

    Access Data Pages

    I have multiple data pages that I need to post to the web. In Access Help, Microsoft says that you can link pages from linked tables by using a hyperlink and placing these pages on a frames page using something like Front Page. I don't get it. Any ideas? Randusoleis.....
  11. randusoleis

    Database often Freezing...Not Responding

    sounds like you may have other issues other than Access. How often do you run maintainence(sp) on your computer? I can be exhausting but run a scan disk and defrag. Do I hear HardDrive issues? Randusoleis.....
  12. randusoleis

    Formerly working update query won't work after upgrade

    There are issues with running SQL6.x and 7.0 at the same time from what I understand. Why have they not just upgraded all to 7.0? Randusoleis.....
  13. randusoleis

    How do I send emails in Outlook from hyperlinks

    The GUI method is a lot easier if you have a static e-mail address. Will the users be sending an e-mail to the same address all the time? Randusoleis.....
  14. randusoleis

    How do I send emails in Outlook from hyperlinks

    On your form just add a hyperlink and in the hyperlink dialogue box select e-mail. Randusoleis.....
  15. randusoleis

    Data Access Page Question

    I have created several data access pages in Access2000(.adp). I have created a frames page in Front Page with the data access pages in each frame. The pages have control sources that are already related to each other. I need to be able to link these pages together so they, of course, show only...
  16. randusoleis

    How to pass parameter from form?

    In my example I was using a stored procedure to produce a report. What are you using the sp for? Randusoleis.....
  17. randusoleis

    How to pass parameter from form?

    In the InputParamter property you no longer need to add the "@idnumber =" part because that is already in your stored procedure. Also make sure you place "FORMS" in brackets....[FORMS]![FORMName]![FieldName]. Randusoleis.....
  18. randusoleis

    What's the 'correct' approach to this design issue?

    Here is my two cents...... You have a Students table and a Ratings table. Each table should have it's own primary key. The ratings table should be a table that only has static values...your ratings. The student table will have all information on students only. The third...
  19. randusoleis

    Data Transfer

    A junction table is only a table to contain data for a "MANY-2-MANY" relationship. Randusoleis.....
  20. randusoleis

    Data Transfer

    Here is the kicker-in-the-asser. I just realized that the table that I was given is set up just like a JUNCTION TABLE. I think that is the problem. This table has no column for a distinct value. What do you think? Randusoleis.....

Part and Inventory Search

Back
Top