Search results for query: *

Ok, that all works now thanks a lot for all your help. There's now 2 other things I want it do do, In the loop I want it to display 2 different attributes in stead of just one and in the list bo I want it to display in this format Attribute 1 Contents - Attribute 2 Contents So I need to...

Ok that seems to work but I now get the same error but with the first ConnString being highlighted this time saying variable not defined. Do I need to put some of the code in the Option Explicit at the top of the page? Thanks, Darren

Ok I have put that code into my program but I am getting an error saying 'Compile Error: User-defined type not defined' It then refers to the first 2 lines of code which isn't a good start. Here is the code I have Private Sub cmdSearch_Click() Dim ADOCn As ADODB.Connection Dim adoRS As...

Also I'm a bit confused as to which sub routine each bit would go under, could you show me which ones? Thanks, Darren

That works thanks a lot. My only other question is what will I need to add if I want the query to look in 2 attributes for one of the text boxes? Thanks, Darren

Hi, I want to connect to a Access 2003 database using VB 6 and then by clicking on a command button I want to run an sql query from a specified attribute in a specified table from the Access 2003 database. The problem is there are 4 different text boxes on the form and I want a query to be run...

Hi, This is my first post on this site and I'm really stuck with something I want to create a box shape that bends in the middle using inverse kinematics. I have drawn a simple box. 40 x 40 x 40. I have them placed 2 boxed exactly inside the middle of the box, the first one stretches from the...

Hi, I have created a simple Hangman Game where at the beginning of each game a word is picked at random from a list of words stored in a text box in the cast. What I want to do though is create a separate text box in the cast with a list of clue words with each word where a clue will be...

Hi, This is quite difficult to explain but I'll try my best. I have created a simple hangman game but at the beginning of each game I want to display the number of letters that are containing in the word on the stage. This should be simple but I am quite new to Director and lingo and I can't...

Yes to your questions in your last post. It's impossible for you to help me without you looking at my code. There's not much of it. Thanks, Darren

Yes. I was given a template that was used with another database so it looked like all I had to do was re-create it but with my database. I do not know a lot about Oracle Forms Developer as I have not been using it long. Thanks, Darren

No, the form runs without errors in Internet Explorer now, the problem is that the query does not work, and I cannot find any reason why it shouldn't. I have linked all the tables needed for the query using the Data Block Wizard, but when I select a value from the combo box the other fields from...

Hi, Sorry I can't believe I didn't think of adding my database schema, nobody can help me without that. At http://www.geocities.com/bobothechimp2001/db.zip I have now also added an SQL file with all my tables, data and constraints so that u can re-construct my database, and of course the form...

Hi, I have a small problem with a form I am trying to create in Oracle Forms Developer. I have uploaded the 2 files here as a zip: http://www.geocities.com/bobothechimp2001/d7.zip When I try running it in Internet Explorer from the traffic light button I get a compile error. It looks simple...

It's OK I have now figured out the SELECT clause problem using a tutorial that I found on a website. The problem I have now is with the last line. Here is what I have now: SELECT Student.StudentName, SingleRoom.RoomNo,HallManager.Name FROM Student,SingleRoom,HallManager WHERE...

OK here is the structure of all the tables that are needed for this query CREATE TABLE Student ( StudentNo VARCHAR2(9) NOT NULL, StudentType VARCHAR2(13), FirstName VARCHAR2(20), SecondName VARCHAR2(20), Sex VARCHAR2(6), DateOfBirth DATE, HomeSteet VARCHAR2(20), HomeTown VARCHAR2(15)...

I have tried that but there are not many good ones. Any recommendations? Thanks, Darren

It has to be in the same query, it just has to include values in attributes from different tables, is there no way of doing this? Thanks, Darren

I want this query to display 3 attributes from 3 different tables depending on the value of an attribute given at the beginning of the query, but I can't get the syntax right for the SELECT clause. this is the latest version: SELECT StudentName FROM Student,RoomNo FROM SingleRoom,Name FROM...

I am running Oracle 9iDB on my PC. I have created a number of SQL tables and put them into Oracle, I have then created a form in Oracle Forms Developer to insert records into 1 of the tables. I have put Submit New Record, Clear, and Exit Form buttons on it and they all work as I have run it in...