Search results for query: *

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

Hi I have created a query which will return all applications installed on a particular computer, i am trying to show all applications that are not installed on a particular Computer. I have the following tables: tbl_Computer_Main_Applications Computer_Main_Application_ID...

Thanks for the Direction, finally got it working with the Umatched query Wizard.

SORRY guys I have 3 tables Holding the following information: - tbl_Computer_Main_Applications Computer_Main_Application_ID Computer_Main_App_Name Computer_Main_App_Version tbl_Computer_Identification Computer_ID Computer_Asset_Number Computer_ID_Make Computer_ID_Model...

I have a query which will return the results if a computer has a particular software installed see code strSQL = "SELECT tbl_Computer_Identification.Computer_Asset_Number, tbl_Computer_Identification.Computer_ID_Make, " & _ "tbl_Computer_Identification.Computer_ID_Model...

Update: I have it woking to an extent with the following code, What i need to do is check which items are in the installed list and remove them from the Available list any ideas how to check that? Public Sub DisplayAllComputerDetails(ByRef rsDisplayComputerDetails As DAO.Recordset, ByRef...