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

  • Users: Omono
  • Order by date
  1. Omono

    Mouseove in module

    I have a number of forms each with the following mouseover code: Private Sub Form_MouseMove(Button As Integer, shift As Integer, _ x As Single, y As Single) frmInfoActMPH.Visible = False End Sub Private Sub Image1_MouseMove(Button As Integer, shift As Integer, _ x As Single, y As Single)...
  2. Omono

    Multiple ComboBoxes

    I have a single form with three ComboBoxes. The form displays the UserName, Company and Department. There is a table for each field - TblUser, TblCompany and TblDepart. I want the UserName to be the main source - when a user is selected from the drop-down list the appropriate company and...
  3. Omono

    DataContol to access multiple forms (tables)

    I have an inventory access db for which I am creating VB user forms. The main form consists of a number of DBCombo boxes in conjunction with DataControls, successfully retrieve data from other tables. One combobox on the main form is “PlaceofPurchase”. On the main form this box is bound to a...
  4. Omono

    Search 2nd table for match in main table

    Thank you LambertH. I finally got your suggestion to work. Sorry it has taken me so long to respond.... Thanks ever so much for your help.
  5. Omono

    Search 2nd table for match in main table

    Thanks LambertH for your quick reply. I neglected to tell you that I'm using Access 2002 (Office XP Pro). It's looking for macro 'cmdbutton' I'm researching now how to perform dlookup's in Access 2002.
  6. Omono

    Search 2nd table for match in main table

    I have a main form, inventory, with its accompaning table. I have a second table, peripherals, which list the other equipment. The primary key in the main table is the inventory asset number which I have joined to a field in the peripherals table called location, which is the asset number of the...
  7. Omono

    Linking Pictures to records

    I have a house inventory table with associated forms and reports. I am trying, unsuccessfully thus far, to include pictures of each inventory item. I have read that it is better to link to a picture than to embed it in the table. I cannot figure out how to do this. I have seen other postings...
  8. Omono

    Form AllowEdits property

    Mickyjune26 - Thanks for your quick reply. You mentioned that using AllowEdits may not be the most efficient way to do what I want. What do you suggest?
  9. Omono

    Form AllowEdits property

    I am trying to add an Edit Record Command button on a input form so the user must take some action to edit the information. I have the form set to AllowEdits=False. On Click event for the cmdbutton sets AllowEdits=True. My problem is that I cannot figure out a way to reset AllowEdits=False when...
  10. Omono

    Command button problem

    Thanks everyone for the suggestions. I favor the one from johnwm - putting the validation code in the cmdCalculate click event. It works great! Thanks again to all.
  11. Omono

    Command button problem

    I have a form with txtboxes into which data is input. I validate the data; something has to be entered into the txtboxes. After data is entered, either the tab-key or enter-key can be pressed to go to the next txtbox. Once the boxes are filled, the user can press a "calculate&quot...
  12. Omono

    Excel - extract data from multiple worksheets

    I have a financial expendures workbook. There is a worksheet for each month. Each monthly worksheet has the following columns; date, description of expendure (normally a single word) and the dollar amount spent. The items are paid at different times during the month so the description and amount...
  13. Omono

    Renaming table Tip

    I have a lot of queries that extract data from a table. I had some problems with a query because the main table is named 'Computer Inventory'. I needed to rename the table to 'Inventory' to solve some problems, but dreaded doing it because of all the queries involved. What I did was to copy the...
  14. Omono

    Address book report

    Where to start....this is long... I have tried to accomplish this task using the form wizard but just can't seem to figure it out. A landscape page will fit nicely into a three ringed planner. I want to print addresses from a mdb, so that I will end up with four address pages on one sheet of...
  15. Omono

    VB6 - Force user input

    Thanks again CajunCenturion. The code you provided works just like I want. Thank you....
  16. Omono

    VB6 - Force user input

    Thanks for the quick response CajunCenturion and Dazz22. However, I don't understand how to validate. Is that coded or set in textbox properties? Thanks... O'Neal
  17. Omono

    VB6 - Force user input

    Hello, On a form I have multiple text boxes, all of which must contain data so that a calculation can be made and put into the answer text box. I have code that permits only numbers to be entered into the text boxes, however, I do not have code to prevent the boxes from being left empty. I have...
  18. Omono

    Clearing text boxes

    Thanks to all of you now everything works the way I had envisioned it. I had neglected to set the focus. ONeal
  19. Omono

    Clearing text boxes

    I have multiple forms into which users enter numbers to calculate. I want to put a reset button on the form. Once they have calculated and wish to try different numbers, they select the reset button which clears all text boxes and returns them to the first box to enter new data. Any help is...
  20. Omono

    Form "Refreshment"

    Hi I'm doing basically the same thing you're doing. The way I eliminated the "deleted" lines was to base my form on a query. To keep my query simple I included all fields and made it sort on one column. My macro includes the following: setwarnings - no hourglass - yes openquery -...

Part and Inventory Search

Back
Top