Search results for query: *

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.

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

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.

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.

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.

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.

I am having some trouble with opening and save my form. I am able to save it but then when I go to open it the information that was saved is not in the form. Here's my code for opening and saving. Private Sub mnuSave_Click(Index As Integer) On Error GoTo ErrHandler Dim IFile As Long...

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.

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

I have some code that will be used with many different combo boxes. The combo boxes will be named cboEquipment0, cboEquipment1, cboEquipment2, etc... I would like to create a function so that I didn't have to write the code for every combo box. Here's my code. Private Sub cboEquipment0_Click()...

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

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

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

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.

I've got a text box in a form called Part#. I would like to create a command button so that when the user clicks it a input box will show up and the user will be able to type in the part they're looking for and it will take them to that record. Any help would be appreciated.

I've got a form with a date text box. I want to write my own error handler for the date if the user trys to go to the next record without entering the date. Here's the code that I tried but I don't know which event procedure to put it in. If Err.Number=3314 Then msgbox("You must...

I have created a database to keep track of the maintence that we perform on our trucks. On The form I Show the part numbers for the specific truck that is selected. I then have a combo box to select if a part has been changed or greased. In my inventory I want it to automatically update if...

I am trying to make the format in text1 currency. Here's my code any help would be appreciated. Private Sub Command1_Click() On Error Resume Next Dim AnhCost As Currency, AnhRate As Integer AnhCost = InputBox$("Enter the cost of ahydrous.", "Anhydrous Cost") AnhRate...

I am having trouble figuring out how to set my margins for my print job. Here is the code I have. printer.scalemode = 2 printer.scaleleft = 72 printer.scaletop = 72 printer.print "Message" printer.enddoc I have run this program but my margins do not change.

I am wondering how I can update a database on another users computer without updating or erasing the information they put in it.