Search results

  1. G

    add 1 to last fileid

    hi all i have a fileid that i dont want to make a autonumber, but i want to act like an autonumber ,take the last id and add one when you choose new record only on a form with a subform. thanks in advance
  2. G

    Ucase help

    I click twice in the left corner of my subform in form view nothing happens , and then I tried in design mode and the properties pop open but I only get Enter or Exit events
  3. G

    Ucase help

    hi all I have a form that has textboxes, a combox and a subform, when i complete a record, I will like everything to capitalized in the table but I can't seem to figure out how to do this on the subform fields. I tried the ucase function for the after update but the subform doen't have an...
  4. G

    Form help

    thanks thanks worked like a charm, now im wondering if on the same form, i have a subform and i want all info to be in uppercase dont no where to use the UCASE FUNCTION FOR THIS
  5. G

    Form help

    I have a form with a combobox when CHOOSE A SPECIFIC NUMBER 008, 3 new boxes become visible, the problem is when I move to a new record I want the boxes to to become invisible again I have in form load for them all to invisible so they start out invisible but if that number is choosen then they...
  6. G

    forms and combo boxes

    Hi, How do i use a combo box to list all the records from a particular field so that when you select a item from the list it then populates other text boxes on the form relating to that particular record? For example, if i have a customer table and i have 100 records. I want to put all the...
  7. G

    Form Data

    form the table after i complete a new record on the form the tables info is incorrect
  8. G

    Form Data

    form it is already a textbox
  9. G

    ComboBox VBA

    I Had That Problem , You have To Go To The Properties Of The Combobox And Set The Col Count To 2, Don't Mess With The Code
  10. G

    Form Data

    I Have A Form With A Combobox When I Choose A Record Form The Box The Matching Info From The Table Populates A Textbox Example I Choose The Acct Number From The Box And The Company Name Goes In a Textbox looks like it is fine on the form My Problem Is That When I Look At The Table The Company...
  11. G

    runtime error 94 invalid use of null

    New Error Thanksz For The Help But Im Getting A New Error That States That The Field Cannot Be A Zero Length String IT WONT LET ME ATTACH THE DB -------------------------------------- THANKS FOR ALL THE HELP ADDING THE 3RD COLUMN WORKED
  12. G

    runtime error 94 invalid use of null

    I Dont See Where To Attach
  13. G

    runtime error 94 invalid use of null

    Please Help ive tried all the tips but to know avail can anybody show me where im going wrong please the code Private Sub cboAcctName_Click() Dim strPopulateTextbox As String 'Declares a string variable Dim strPopulateTextbox2 As String strPopulateTextbox =...
  14. G

    runtime error 94 invalid use of null

    combobox help thanks for the tips but the problem is there how to do I declared the variable if thats the problem if the record is a phone number
  15. G

    runtime error 94 invalid use of null

    combobox help hi all i created a form from a table with 3 columns . I have a combo box on my form that is populated from column 1, and a textbox that is populated from column 2 when you choose a record from the combobox but the third textbox keeps generating an error - runtime error 94 invalid...
Top Bottom