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

    Synchronizing

    I'm having a hard time getting an answer to this because I don't really know how to explain. I need a combo box that will have two tables with one field from each in the same column ( i can do a union query ok), the fields are (subContractors & primeContractors). I need this combo synchronized...
  2. ramondrumon

    Combo box sync using a union sql

    I want to synchronize three combo boxes and the information needs to come from two different tables. I made a union sql from the tables and this is where I am stranded, anyone have any ideas? The two tables need to be separated other than for this purpose, I have access 2000.
  3. ramondrumon

    Update more than one record.

    Combo box titles: 1001 Demolition 1001 1.1 Concrete demolition 1001 1.2 Wood Demolition I have a combo box which will show [1001 Demolition only], if I Pick 1001 demolition it will update a list boxt to this: 1.1 Concrete demolition 1.2 Wood Demolition This in turn is...
  4. ramondrumon

    Inserting info from list box to text box

    I have a text box that can take 3 lines of information, I have a list box that when I click on a row the info is inserted into the text box, then I click on another in the list box and it is inserted too. My problem is that when I insert some info to the text box, the info can be broken in half...
  5. ramondrumon

    Set focus to a text box in a subform

    I have this code in the current event of the main form to set focus to a text box of a subform. Forms("FrmSubmittalLog").SetFocus Forms("FrmSubmittalLog").SubmittalIDNo.SetFocus I get an error saying it can not find the FrmSubmittalLog, and I can't figure it out, so some...
  6. ramondrumon

    Continuous form

    I have a continuous form (form view) and new records are inserted after the last record. I would like a blank record line inserted between two records, then I would be close so I could copy some of the related information to fill out the new record and (2) it would then be next to the record I...
  7. ramondrumon

    I'm trying to do something like thi

    I'm trying to do something like this in a continuous form and report: 02900-1 HEADING 1.2 Some info 1.2 More info 1.3 More info 03440-2 HEADING 1.2 More info 1.3 More info Every line will...
  8. ramondrumon

    Expand a text box?

    I would like a text box in form view to expand when it has focus (show 55 characters)and then shrink back (to about 20 characters) when it looses focus. I found the code to make it zoom, but I need to limit the characters to 55 and the zoom box lets you add more letters and then truncates it...
  9. ramondrumon

    Tool box has disappearped!!

    I was moving my tool box around and lost it. It is in computer cyber-space. It is hiding some where and how do I find it. The button says it is here, it is just being hard to find.
  10. ramondrumon

    Name & address concatenation

    I have my Name and address table and this goes into my different forms, so it is foreign, but is related. I am trying to make the table into address form with name row, address row and city state and zip concatenation into the report. Every example I find uses individual text boxes for this...
  11. ramondrumon

    Navigation Buttons

    All the ways I have seen so far to make incremental numbers can eventually be different than the navigation button number on the bottom of the form. I am afraid this will confuse the end user. This number always seems to be accurate, is there any way to use this number in our form, then they...
  12. ramondrumon

    Making a main form and sub form both fillable?

    I have two tables that are related, and I am trying to make a form with a combination of the two. I can change the information of both tables on the form of existing records all I want, but when I scroll to the last record, and go one more to make a blank form, it will only let me fill in new...
  13. ramondrumon

    Trouble understanding Forms

    Got through realationships, got my tables normalized, thought forms would be a snap. Wrong!! I am probably missing something, but as I see it, I can only have one table on a form. I can have sub-forms, but they can only be viewed. I tried a query, but when I made a form of it I ended up with...
  14. ramondrumon

    Sequential number formula explanation

    I found this formula: =DMax("InvoiceID","Invoice")+1, where Invoice is my table and invoice ID my number field. It works good, I just can't find out how it works. Whatis DMax and why "INvoiceID","Invoice" and the quotation marks. Also, can you have it...

Part and Inventory Search

Back
Top