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 Chriss Miller 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: rickgalty
  • Content: Threads
  • Order by date
  1. rickgalty

    Using a variable as a cell address

    Hi, I am looking at a list of options using a "Select Case" function in VBA, and based on the result, want to put data in a certain row on the spreadsheet. I could put Case 1 Range("h3").Value = txtDate.Text Range("i3").Value = txtTime.Text Case 2 Range("h4").Value = txtDate.Text...
  2. rickgalty

    Updating, or not, a cell in Excel

    How do I use an "If" to either copy the contents of a cell into another cell, OR leave the destination cell untouched, depending on a certain logical test. I see the syntax of the "If" fnction is "If(logical test, value if true, value if false)", but what if I don't want a 'value if false'? If...
  3. rickgalty

    VBA / Excel .... put text-box value into cell

    Hi, if I write a quick pop-up form in VBA, how do I then move a string value from a text-box on the form to a cell on the Excel workbook? Richard
  4. rickgalty

    seperating strings in Excel

    I have been sent an employee listing as an Excel file. The first column is in the form of: Jones, Peter A Smith, Richard Alan Johnson, Bert etc etc...... I want to split this into three columns. Last name, First name, middle name or initial (Which will sometimes be a name, sometimes an...
  5. rickgalty

    "Can't open a database created with a previous version"

    Hello, this is kind of a follow on to my previous thread about moving a project in development onto my laptop. After ensuring that the Microsoft DAO 3.6 Object Library is properly referenced, I no longer get the "ActiveX component cannot create object" error - this was a critical error that...
  6. rickgalty

    "can't create object"

    Hi there. I have a VB5 database application that I've been working on for a while on my desktop, and it has been coming along ok. When I run it (uncompiled) it runs as expected. I have now installed VB 5.0 on my laptop to work on it on the road. However, when I try to run it now, it crashes as...
  7. rickgalty

    DBGrid column width

    How can I set the width of individual coulmns at runtime? It seems to me that the line dgRecords.Columns(1).Width = 2000 Should set the width of the second column to 2000 pixels, but it has no effect at all. I have DefColWidth set to 0 in the design time properties window. As a follow up...
  8. rickgalty

    Extracting data from a spreadsheet

    Hi everyone.... This is more of an Excell question, really, but I hope someone can help. I am ready to populate the database for an application I have written. My HR dept have sent me the data they currently have in the form of an Excell spreadsheet. Each row of the spreadsheet has an employee...
  9. rickgalty

    Problem with RecordCount

    Hello again, everyone. Can someone please tell me what I'm doing wrong again? In my app, the user can put in part of the name of a training class to see records. If the database doesn't find a match, or only matches one class to the search criteria, fine, but if it matches more than one, I want...
  10. rickgalty

    Bringing a form to the top

    Good morning. When my applications main page opens, there is only one line in the "Form_Load" sub - it reads "frmLogin.Show". It is supposed to open the mini form that alows the user to enter his username and password. The problem is that frmLogin opens BEHIND frmMain, and I can't figure out...
  11. rickgalty

    Using a variable in a SQL Query

    Hi, I'm getting a "data type mismatch" error when trying to use a variable in the "WHERE" clause of a SQL "SELECT". The code line that fails is :- ("SELECT * FROM Employees WHERE EmployeeNo = '" & empno & "'") empno is a variable declared by "Dim empno As Integer", and the field "EmployeeNo"...
  12. rickgalty

    Inserting a date into Access

    Thanks for the help on my previous question, everyone.... now I have another problem. I dumped the bound data fields as advised, and am entering new records using SQL. I can't, however, get it to insert a date. This... db.Execute "INSERT INTO Records (EmployeeNo, Training) VALUES ('" &...
  13. rickgalty

    Case insensitive search

    Hello, I want to look up a name in adatabase. I've got it working, as long as the user enters the name just as it appears - ie entering "Smith" will return hits for "Smith", but not for "smith" or "SMITH". How do I allow this to find matching entries without regard to case? Richard

Part and Inventory Search

Back
Top