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!

  • Congratulations Wanet Telecoms Ltd 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. bjarvis

    Updating database design

    So if I install the new version of the database over the old version on the users machine, then the data on the users machine will transfer to the new database?
  2. bjarvis

    Updating database design

    I am creating a program that is connected to an access database. My question is, if in the future the user wants to add some new fields to the database, when I install the new version of the program how will I update the modified database with the information that the user has already entered.
  3. bjarvis

    maskededit help

    I am connected to an Access database using ADO. When I edit a record if I accidently delete information in a text box and then hit the undo button the text box is filled with the information that I deleted. Now the problem is if I do the same thing to a maskededit the information that I...
  4. bjarvis

    Excel Help

    Thanks for the help.
  5. bjarvis

    Excel Help

    What I'm saying is that when the user goes to the next row to enter more information, I want the total cell to jump down a row and delete the previous total cell. So in a sense the total cell is always two cells below the information that the user enters. Hope this helps clarify it.
  6. bjarvis

    Excel Formula

    Here's my formula, =IF(D2="","",(D2+E1)), now after this formula runs I want to delete the value in E1. How do I do this.
  7. bjarvis

    Excel Help

    I have a worksheet that the user well be entering numbers in. When the user enters a number I want the total row to move to the next row and total everything up that the user has entered so far. How do I do this. I'm using Excel 2000.
  8. bjarvis

    Printer Help

    I want to be able to print a frame object. I would like to be able to print it on paper when the user presses the print menu item. What code do I use to do this.
  9. bjarvis

    sstab question

    I've got 8 tabs, when the user opens the form I want the #1 tab to have the focus. How do I do this.
  10. bjarvis

    Opening and Saving a Form

    ...saving. Private Sub mnuSave_Click(Index As Integer) On Error GoTo ErrHandler Dim IFile As Long CommonDialog1.Filter = "Cost of Production (*.cpd)|*.cpd" CommonDialog1.FilterIndex = 2 CommonDialog1.ShowSave IFile = FreeFile Open CommonDialog1.FileName For Output As IFile...
  11. bjarvis

    ToolTipText Help

    I and doing some tooltips and I am wondering if there is a way to have 2 or more lines of text instead of having it all on one line. If there is a way could you please tell me how.
  12. bjarvis

    Array help

    I have an assingment for my qbasic class. I have to have a two dimensional array. I have to have six columns and five rows. The rows are different departments and The columms are filled with each days sales for the departments. The problem I'm having is in the fifth row and sixth column I...
  13. bjarvis

    Help with Function

    ...the average speed in the field.", "Equipment Speed") If cboEquipment0 = "Combine" Then EF = 70 F = (((S * W) * (EF / 100)) / 8.25) txtEquipment0.Text = F ElseIf cboEquipment0 = "Disk" Then EF = 85 F = (((S * W) * (EF / 100)) / 8.25)...
  14. bjarvis

    Replication Error

    When I open a replicated database I get a message that says, "This member of the replica set has exceeded the maximum number of days allowed between synchronizations and can't be synchronized with any other member of the replica set. Delete this replica set member and create a new...
  15. bjarvis

    Tab Control

    Thanks that did exactly what I wanted it to do.
  16. bjarvis

    Tab Control

    I've got a tab control with it's visible property set to no. When the user selects a certain value from a combo box the tab control is visible. Here's my code. Private Sub Carts_Change() If Me!Carts.Value = 73 Then TabCtl17.Pages(6).Visible = True End If End Sub Now when the user goes to...
  17. bjarvis

    Command Button

    That's what I was afraid of. Thanks for the help.
  18. bjarvis

    Command Button

    I have a form that has a bunch of Combo Boxes. Most of the time the user will select the same thing in each combo box. I want to have a button that the user will push and it will fill the combo boxes with the same selection. Here's an example of my code, but I can't get it to work...
  19. bjarvis

    InputBox Error

    Thanks it worked.
  20. bjarvis

    InputBox Error

    When a user clicks cancel on the inputbox, an error message pops up. How do I get around this so the inputbox just closes without the error message.

Part and Inventory Search

Back
Top