Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mo2783
  • Content: Threads
  • Order by date
  1. mo2783

    Number Rows in Access 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...
  2. mo2783

    Dynamic multi dimensional array

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

    LoadPicture Function or Sub not Defined Error

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

    Problems With list box

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

    HELP

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

    Query Results For items NOT associated with a record

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

    Help With Listbox

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

    Find Method in Excel

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

    Mapping Users Personal Folders according to Site.

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

    Clone Reocrdset to query based on combo

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

    Closing Access Database on server

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

    Help Excel 2007 error

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

    Reading textBox value

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

    Dynamic 2 Dimensional Array

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

    Folder Picker

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

    Combo Text Colour Change according to item selected.

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

    Date in excel

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

    Find method in if selection

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

    Find Method in excel

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

    VBA Query problem

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

Part and Inventory Search

Back
Top