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!

Recent content by Alpha03

  1. Alpha03

    Boolean Question

    I inserted the code given by mrmovie exactly as he gave it and it worked perfectly. I should've done that in the first place. It just didn't seem like it would even come close to accomplishing what I wanted, but it did exactly just that. Now that I know it works, I'm interested in knowing...
  2. Alpha03

    Boolean Question

    I might be misinterpreting what mrmovie's code is supposed to do. Can you explain it to me? Or better yet, if it isn't too much trouble, can you tell me exactly what code I would have to insert into my already existing program to achieve what I want. Keep in mind that I am working with an...
  3. Alpha03

    Boolean Question

    Na, that doesn't work. Thanks for your help though. Does anyone else know how to check to see if the file is open or closed?
  4. Alpha03

    Boolean Question

    Below is a VB program I wrote to add records to an Excel file. Under Command3_Click() you will see that I have programmed the button to simply open the file to view it's contents. Now lets say I click that button, open the workbook, then close the workbook (manually, not through the VB...
  5. Alpha03

    Quick boolean question

    Oh whoops...the code that I placed in my previous post was the current VB code that I have. The one I'm working with is below: Dim objExcel As Object Private Sub Command1_Click() If Text1.Text = "" Or Text2.Text = "" Or Combo3.Text = "" Or Text4.Text = "" Or Text5.Text = "" Or _...
  6. Alpha03

    Quick boolean question

    Below is a VB program I wrote to add records to an Excel file. Under Command3_Click() you will see that I have programmed the button to simply open the file to view it's contents. Now lets say I click that button, open the workbook, then close the workbook (manually, not through the VB...
  7. Alpha03

    Excel file not saving correctly

    I wrote a little VB program (below) to input a row of data into an already existing Excel file based on the information I provide through the FORM of the VB program. The only problem is that it doesn't save properly. When I go to open the file to see if the changes are made, the file isn't...
See more

Part and Inventory Search

Back
Top