Recent content by ProgrammingB52

I figured it out, what happened was there was an incorrect table relationship, when I added the table to the fieldList, the page dissappeared because the relationship was wrong.

The underlying record source does not contain any data because it is a blank form and the data entered into my textboxes goes into the database, not the reverse--the records from the database which are currently blank are not to show up on the form. What I am doing is dragging fields from the...

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

I managed to add an updated fieldlist to the form from the properties window. Then I can drag and drop the properties over. That makes them appear in the record source.

Well I got that far but I am setting the control source wrong. I am setting it to =tableName!FieldName That doesn't work.

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?

Thanks so very much, The update table sql worked. I made it more complicated than it really was.

The output is:Cannot insert the value NULL into column 'stdID', table 'clarkOnline.dbo.Student'; column does not allow nulls. INSERT fails. The statement has been terminated. (9 row(s) affected) ---------------------------------------------------------- When I write this: select...

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

Does anyone have a link for any PLSQL samples that I can run?

Got it working. What it was was in the control panel for ODBC datasources the sql server driver had to be set to windows authentication mode.

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

Using select username from dba_users I get the error message ' table or view does not exist' Does that mean that there are no databases that I am privelaged to?

In MySQL it is show databases; What is the command to view all of the databases available?

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?