Hi I am working in design view, bounding textboxes and then when I switch to form view the whole page in the details pane is gone. Only the header shows,,,,help please....
Hi I just started out in design view with a form. I get a #Name? error on my form. What I want to do is have a text box be blank and when someone enters the data into the textbox I want it to be stored in a table. How do I bind the control to a table?
I have a table Student with fields stdID,fName,lName,email and username. I have another table studentType with a field degType for degreeType. The username field is blank and I am trying to write in TSQL that the username field be the (degreeType initial + _ + fName + lName). For example for a...
Below is my code and I am getting a connection unsuccessful error. I am trying to use a sql server database. I didn't do anything in the control panel odbc datasources.
try
{
String url = "jdbc:odbc:employeeExpense";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn...
How do I write a stored procedure to declare the following variables @Phone and @CustomerID to equal the Customer's table's fields Customer.phone and Customer.customerID?
I have about a hundred text files,each text file contains information about a person.I have to have these in xml.Is it possible to create an xml schema based on the text files and then import all of these text files to xml with element,field names defined from the schema. When I import them now...
In my C# application I have an update method that is not updating the database.
private void btnUpdate_Click(object sender, System.EventArgs e){ oleDbDataAdapter1.UpdateCommand.Parameters.Add("@Phone", contactsPhone);
oleDbDataAdapter1.UpdateCommand.Parameters.Add("@CustomerID"...
I am trying to insert values in a table where there is a foreign key to another table. I can't insert data into either of these tables and get the same errror....
INSERT statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'FK_OrgUnit_OrgUnit'. The conflict occurred in database...
I have 2 long script files the first starts with:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'empExpense')
DROP DATABASE [empExpense]
GO
CREATE DATABASE [empExpense] ON (NAME = N'empExpense_Data', FILENAME = N'C:\Program Files\Microsoft SQL...
I am wondering which would be better for my database FoxPro or MySQL. I have a growing access database. I am using Windows 2000 Server. What are the pro’s and con’s of both?
I am having a library problem. I went to tools->references and dont which libraries to use. It compiled and ran fine before, but all of a sudden it doesn't recognize ADODB.Recordset and CurrentProject.Connection
Public Sub removedashUPClist()
Dim cnn As Connection
Dim rst As ADODB.Recordset
Set...
I am trying to find files. I have the file names and tried a find . -name in root. The files weren't in root and I dont know what directories to search. Is there a way I can search them all?
I am trying to ftp and am unable to due to an unknown host. I entered ftp. ftp.umassd.edu and got "UNKNOWN HOST" and was not prompted for a user name. How do ftp to this site, or make this host known?????
I have a file on a unix machine that I need to email to hotmail. I looked up the ftp outgoing command, I dont think that that will do it because the receiver would have to log into my unix machine, which I do not know the name for. Should I create an outgoing directory, and find an address for...
I have imported an excel file into access. After importing though, the text format changes the numbers to scientific notation, for example 723252238464 changes to 7.23252E+11. In excel the field was formatted to text, and is text as well for access. All of the fields with long numbers after...
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.