Search results for 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...

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

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

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

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

Hi I have a 2 list Box, Which i can populate without any problems and move data between them. I am having problems with the following code, where i am trying to display the results of the Applications installed on a specific Computer on the lstSoftwareLoaded listbox and those Applications...

Hello All I am having some problems with a find method I am using in excel VBA. I have many lines in this file which begin with - “TEXT /OUTFIL” and the other text. I need to find the “Part Name” from this string within this file From this file I am using the following find method...

I have a script which maps drives and creates or maps to the users personal folder. We have 2 sites one in Warwick and another in Basildon. I want to be able to map the users personal folder according to the site they are from (I.e. Warwick, Basildon) as the user folder are located on...

Hi I have a combo box on a form which has values when a user selects a value i am running a SQL statement which brings the data. I was wondering whether i could clone that recordset so the form is populate with the cloned data? i have the following code Dim rsFoundSerachDescription As...

Hello People I am new to scripting, but i have a task to write a script to close a Access database or make sure its closed on a server before the backups run. I have no idea how to do this, what editor i would need to use etc. Any help would be much appreciated. Thanks Mo

Hello People Someone created a program in excel 2003 and an earlier version of excel. Since we have updated to Excel 2007 and in some case updated excel 2003 to Service Pack Level 3 we are getting the following error The formula you typed contains an error. For information about fixing...

Hi, I have the following code which checks to see if the user log in on to the system matches the user id enter in a text box. Public Sub CheckedUserLoggedIn() Dim strLoggedUser As String strLoggedUser = (Environ$("Username")) strUserID = txtCDSID.text If...

I am trying to use a dynamic 2 dimensional Array to hold the following information Model - X250 X350 X150 Cell Ref - B2 C3 F3 The size of the array varies dependent upon the models so the array can be 2x2 or 1x2 or even 4x2. I can hold one item in the array...

I am trying to create a dialog box that will select a path to a folder which i will then use to open a series of excel files. I have the following code, but unable to return the path from the function, can anyone help me please? Public Function cmdSelectInput() As String Dim...

Hello All I have been trying to solve a problem, I have a combo box with 3 Priority settings (High, Medium, Low) I want to change the colour of the text so if High is selected the text would be red, if Medium is selected then text would be Amber, and if Low was selected then the text would be...

I have a worksheet which contains data of all invoices sent out and amount sent to customers. I am trying to automate by adding a column which will show the date the invoices was sent. I have the following if statement in the cell =if(isNumber(s4),today(),"") so every time i load the...

Hiya All I have a worksheet with functions created by the user called =PutValues(), what i am trying to do is write some code to find these function and count how many are on the worksheek. I have something like 30 worksheets full of them. i have wrote the following code: Public Function...

Hiya All I have a worksheet with functions created by the user called =PutValues(), what i am trying to do is write some code to find these function and count how many are on the worksheek. I have something like 30 worksheets full of them. i have wrote the following code: Public Function...

I have two tables, one is called Sample and the other Results. With a relationship of one to many. (One sample can have many results) What I am trying to do is select a date and display the results of the test for the next 14 days. (Eg Say a user selects 10/10/2002 then the next 14 days will...