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: *

  1. vbpadawan

    help with importing from excel

    In my code, I import data from an excel worksheet into a SQL table. My code has worked fine up until yesterday. I haven't made any changes to my code and my customer says that they haven't made any format changes to the worksheet. The problem is when I open the recordset with my excel data...
  2. vbpadawan

    Check to see if file is open and close it

    I know that I have run across this question before but can't seem to find it now that I need it. I need to check to see if and excel file is open and if it is, I need to close it. Can someone help me out. Thanks.
  3. vbpadawan

    minimize all forms related to a project

    You need to actually add a new form. The new form must be the MDIForm. The MDIForm is a container for all the MDI Child forms. You can load your first form inside of the MDIForm when your application loads so your application looks the same. Let me know if you would like any help making it...
  4. vbpadawan

    minimize all forms related to a project

    Are you loading the MDI form when the app loads?
  5. vbpadawan

    I need some help with Logic.

    I have a table of loan amounts. There are times when I need to find the group of loans that total or come closest to an amount I specify such as $2,000,000. I am trying to come up with logic to do this and need some ideas. Thanks.
  6. vbpadawan

    minimize all forms related to a project

    You could create your main form as MDIForm and all other forms as MDI Child. This way, all child forms would be inside of the main form.
  7. vbpadawan

    calculation question

    Ok, I just found another thread that gave me the answer. AndyGroom, here is the solution: Add a reference to the Script Control 1.0 Dim objSc As ScriptControl Set objSc = New ScriptControl objSc.Language = "VBScript" 'Evaluate the expression Dim dblResult As Double strCalc =...
  8. vbpadawan

    calculation question

    No, I'm not using excell. I am using a grid control. I know how to loop throgh the selected cells but the calculation that the user enters could use any operation (+, -, *, /). They actually enter the operation and a number ie: "+ 3" or "-.05". I need to be able to take...
  9. vbpadawan

    calculation question

    I have a grid that i allow the user to select cells that contain numeric values to perform a calculation on. When they click a button, I bring up another form that they enter the calculation in ie: "+ 1". That tells me that they want to add 1 to all the cells they selected. I do...
  10. vbpadawan

    How to populate Janus Grid

    Correction: GridEX1.Columns(2).ValueList.Add 0, myRS!Name NOT GridEX1.Columns(1).ValueList.Add 0, myRS!Name
  11. vbpadawan

    How to populate Janus Grid

    I am evaluating the Janus grid before I purchase it. I have never used it and don't even know how to populate it. I have two columns; the first is just a text field and the second I want to be a dropdown list. I have set the second column to be a dropdown in the properties box. I don't even...
  12. vbpadawan

    close form after 10 min.

    I need to be able to close a form after it has been open for 10 min. How can I determine how long it has been open?
  13. vbpadawan

    Sort MSFlexGrid

    In doing some searching around, I have discovered that you can only sort consecutive columns and all in the same direction. If this is the case, this won't work for what I need to do. Does anyone have any ideas on a different way to do this? I have a recordset that I load into the flexgrid...
  14. vbpadawan

    Sort MSFlexGrid

    Is there a way to sort two columns in the flexgrid? I need one column sorted ascending and the other sorted descending. I populate the flexgrid with a recordset but several of the columns are calculated fields that I compute in code and not in the query.
  15. vbpadawan

    Can I overwrite with no prompt?

    Thank you so much Hypetia. It works great!!!
  16. vbpadawan

    Can I overwrite with no prompt?

    Is there a way for me to save a file and overwrite an existing file without a prompt to overwrite? I am creating an excel file and when I saveAs, I do not want it to prompt to overwrite but I do want it to overwrite the existing file. xlSheet.SaveAs "c:\FileName.xls" Thanks.
  17. vbpadawan

    Import from XLS to SQL through VB

    Is there an easy way to import data from a worksheet into a SQL table through VB? Currently I open the table and the worksheet and loop through the worksheet and add a new record for each row. This is too slow and am looking for alternative ways to do this. Thanks.
  18. vbpadawan

    dir list box and drive list box

    I know this is an easy question but I forgot how to do this. How do you change the drive in the dir list box after you have selected it in the drive list box. Thanks.
  19. vbpadawan

    VB6 - Excel Help Please

    I am attempting to open an excel worksheet and update the links using VB6. For some reason the Excel.Application is not being created and I receive the following error: <Object variable or With block variable not set> Below is my code: Private Sub UpdateLinks() Dim ExAp As...
  20. vbpadawan

    mathematical calculation help

    Yes, this is a mortgage payment calc and the part that I posted was only a small part of it. I broke it up to make it easier to read and follow. I did get it working this morning, though. I now need to calculate the APR but cannot find the formula to do this. Does anyone happen to have this...

Part and Inventory Search

Back
Top