Recent content by mo2783

I am still not getting the correct results the query looks like this SELECT tbl_Students.StudentID AS StudID, Format([StudID],"0000") AS StudentID, ignoreSpace(tbl_Students.StudentName & " " & [StudentMiddlename] & " " & [StudentSurname]) AS StudentName, (SELECT Count(StudentName)+1 from...

I have tried your Solution but i get the follwing results StudentID Student Name RowNumber 0003 Joe 0003 0045 Henry 0045 0029 Harold 0029 0134 Martin 0134 The query...

I have the follwing query SELECT tbl_Students.StudentID AS StudID, Format([StudID],"0000") AS StudentID, ignoreSpace(tbl_Students.StudentName & " " & [StudentMiddlename] & " " & [StudentSurname]) AS StudentName FROM tbl_Classes RIGHT JOIN (tbl_Students RIGHT JOIN tbl_StudentClassJoin ON...

I am trying to store information from a spreadsheet to use later but in another worksheet. The information i need to store relates to records as such so for instances I have a the following information on a worksheet A B C 1 400 400 400 2 428 378 421 3 1/6 10/6 22/6...

Cheers PHV It works that works.

Hi i have the following code which will insert a graph on an image box on a form in Excel 2003. Public Sub UserFormChart() fname = ThisWorkbook.Path & "\ Ch.gif" Set ch = Sheets("Data").ChartObjects(1).Chart ch.Export fname, "Gif" UserForm1.Image1.Picture = LoadPicture(fname)...

Thanks for the Help everyone. I have it working with SQL, but what if i was going to populate the listbox with "values" (Row Source Type as Value) via code, how would i populate the listbox with 2 columns? Mo

Thinking about it i dont really need to Remove items from list box as it populated when empty or do i? But how do i populate a multi Column list box in Access 2003? Is the code above any good? Mo

Remou I tried RemoveItem i get error "Argument not optional" if i delete RemoveItem then i get the same error on line which reads .AddItem am i not setting up a reference to something? thanks Mo

Hi I have the follwoing code which should populate a 2 Column listbox Private Sub Form_Open(Cancel As Integer) strSQL = "SELECT tbl_Computer_Main_Applications.Computer_Main_Application_ID, tbl_Computer_Main_Applications.Computer_Main_App_Name...

Thanks Remou Remou has already been given a star for the Excellent job, much appreciated Remou. Well Deserved Star. http://www.1keydata.com/sql/sqljoins.html

Thanks a lot Remou, that works fine can you breifly explain how this works if its not to much for you as i am not familier with subqueries. Thanks once again Mo

Remou Sorry but not to familier with Subqueries, how do i get the user to enter and Computer Asset number and display the end results according to the asset number? Mo

Remou I take it q1 is Query1? Mo

Remou Sorry remou about the title, i realize when i posted didnt know how to edit the title or delete the question and start again. Mo