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!

  • Congratulations Mike Lewis 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. Rich25

    mapping table when using a subform

    Hi, I have a simple database that has 3 tables. Person ------ PersonId Name Mapping ------- PersonId OrganizationId Organization ------------ OrganizationId Organization Theres a 1 to many relationship between person and Mapping, and between Organization and Mapping I have a main form...
  2. Rich25

    MS SQL Server 2000 Installation problem

    the databases finally showed up. but it took about 5 minutes. hmmm what is going on here!?!?!
  3. Rich25

    MS SQL Server 2000 Installation problem

    I installed MS SQL Server 2000 client tools to work with our SQL Server at work. After installing the client tools, I went to register new server, and completed this. The new server shows up and when I click on it, Databases, views, and other folders show up. When I click on the Databases...
  4. Rich25

    How do I do an Insert like this one....

    I figured out what I had to do. I probably just didn't explain the problem well enough. All I had to do was open a new recordset after I inserted or updated Table A, then base Table B on the id field of Table A, including the new id that was inserted. That still may not be understandable, but at...
  5. Rich25

    How do I do an Insert like this one....

    I have an input form with mostly text boxes. When the user presses submit, most of the fields are inserted into Table A, for example. Some fields are inserted need to be inserted into Table B. Fields cannot be inserted into Table B if Table A has no records (is at eof). I'm having a problem with...
  6. Rich25

    1 to 1 relationship question

    Hello, I'm updating my data model and just noticed that I have a few tables where I thought there was going to be a 1 to many relationship, but they ended up being just a 1 to 1 relationship. Should I eliminate these tables and just put the fields in the table that they relate to, or keep them...
  7. Rich25

    Array Question

    Thanks a lot Wushutwist. You're hep was much appreciated!
  8. Rich25

    Array Question

    I have the following array: Dim iRowLoop, iColLoop For iRowLoop = 0 to UBound(TopicIdValues, 2) For iColLoop = 0 to UBound(TopicIdValues, 1) Vals = (TopicIdValues(iColLoop,iRowLoop) & &quot;<br>&quot;) Next Next Response.Write Vals Vals is only displaying the last value...
  9. Rich25

    Referential Integrity won't allow delete

    In my application, I have a section for topics, which can have can have subtopics. In the admin section, topics cannot be deleted if they still have subtopics because of referential integrity. I'm having trouble figuring out how to just show the user some kind of message telling them that they...
  10. Rich25

    HTML FRAMES

    Does anyone know if it's possible to make the Frame Borders completely invisible? Please tell me how. Thanks
  11. Rich25

    Changing input prompt format

    Hello, I'm using Crystal Reports on the web with an ActiveX control. My report prompts a user to enter a start date and an end date in the following form Date(year,month,day) - This is a little confusing for non-technical users. Is there any way to allow each user to just enter something like...
  12. Rich25

    Changing the input date format

    Hello, I'm using Crystal Reports on the web with an ActiveX control. My report prompts a user to enter a start date and an end date in the following form Date(year,month,day) - This is a little confusing for non-technical users. Is there any way to allow each user to just enter something like...
  13. Rich25

    Web Browser Control

    Can anyone point me in the direction where I may find help coding the Web Browser Control?
  14. Rich25

    Having Trouble with ADO Connection to SQL Server

    I'm trying to connect to a SQL Server 6.5 Database with the following code: Option Explicit Private Sub Form_Load() Dim cn As Connection Dim rs As Recordset Set cn = New Connection cn.Open &quot;Provider=SQLOLEDB.1;Password=firmlink;Persist Security Info=True;User ID=firmlink;Initial...
  15. Rich25

    VB 6 Run-Time Error..Please Help me solve it

    I keep getting the following error when I run my vb program. It's actually three components. I made 2 dll's and one executable. When I run the executable, I get this error: Run-Time error '-2147467259(80004005):' [DBMSSOCN]General network error. Check your network documentation. Please send me...

Part and Inventory Search

Back
Top