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...
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...
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...
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...
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...
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) & "<br>")
Next
Next
Response.Write Vals
Vals is only displaying the last value...
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...
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...
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...
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 "Provider=SQLOLEDB.1;Password=firmlink;Persist Security Info=True;User ID=firmlink;Initial...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.