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 TouchToneTommy 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
  • Content: Threads
  • 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

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. Omono

    Form to search table

    I have a table with 7 fields. I envision that from a main form a user can select the "search" function. I have created a form with an option group permitting the user to select on which of three possible fields to conduct the search. Upon making a selection from the option group, lets...
  14. Omono

    Password a Delete Record Cmd Button

    I have a computer inventory database that uses forms to navigate/edit data. I have a delete record button on the main form. Pressing the delete button calls up a form prompting for a password that looks like an inputbox but is a text box so I could use the password mask (*****). My problem is...
  15. Omono

    Registry search

    I am a vb novice. I am attempting to write a simple utility to push down over my network that will extract Microsoft Office ProductID and ProductName from each PCs registry and enter it in a db. The problem is that each office suite puts the info in a different key location. For example, on my...

Part and Inventory Search

Back
Top