Recent content by hendrikbez

  1. H

    Add 1 or = to same as

    I do have about 14 textboxs inputs. The 123mag1212 is one of my records info, I getting stickers from a company to use for tapes that I send out to them. The last 4 numbers is the only ones that will change. I can use the number for 1 tape the next number for two tapes or next number for 4...
  2. H

    Add 1 or = to same as

    Sneusber, I have added it that is will show int the textbox when I press the new button, Can you please give more more information on what you ask me to do. I do not understand what I must do. Sorry English is not my first language.
  3. H

    Add 1 or = to same as

    I have a form with a few textboxes where I add info to a table. I want to know if I have a textbox that always shows "123mag1212" is is possible that when I add a new record it can ask me (button with +1 or =) if I want to increase the number by one "123mag1213" or leave it the same.
  4. H

    Append execl into database

    I do have a access database, and every day I have to put date in manually, how can I get to append it into my database, see my two screens 1a is my database table and 1b is my work sheet. What is the best why and how can I do it.
  5. H

    Dropdown list not working

    I am trying, but it is a bit confusing, I will go true it, but I have tried to add a normal text box, but It stop me from doing so, how do you add a column to a table that is been blocked
  6. H

    Dropdown list not working

    Mile-O Thank you for the sample
  7. H

    Dropdown list not working

    Namliam I have treid to get this to worked, but cannot do you maby have a sample for me to look at
  8. H

    Dropdown list not working

    I have done this see screenshot This one I am not sure what you mean. I did add the dropdownlist from one of my combo tables, and still not showing. in my table when I open it.
  9. H

    Dropdown list not working

    Thank You, I would have changed the naming convention, was just testing. This is a putty, as I need to send the main table out evry week, and that is only show the Id number is not good, How can I use it then to show the info that I need.
  10. H

    Dropdown list not working

    Using Access 2010 I have build a new form with textboxes and 5 dropdown list boxes. I have make a main table where all the info must go into that it is getting from the vorm input. I have also make 5 different tables were the info of the dropdown list is in. I have make each dropdown list to...
  11. H

    Show date in messagebox

    Thank you I did read it, but I still do not understand to get it to work. Here are my code, I have tried tow ways, but no luck.. Private Sub Save_Click() Dim LValue As String LValue = Format(Date, "dd/mm/yyyy") LValue = Format(DateSendOut, "dd/mm/yyyy") Dialog.Box "Tape # : " &...
  12. H

    Show date in messagebox

    I want it to be 15/01/2015 or it will be better if it can show 15 Januarie 2015.
  13. H

    Show date in messagebox

    I have a messagebox and want to know if it is possible that the messagebox give me a date as 15/01/2015 and not 15/01/2015. Using dailog box as messagebox Private Sub Save_Click() Dialog.Box "Tape # : " & Me.Tape & vbCrLf & "Sticker # : " & Me.Container1 & vbCrLf &...
  14. H

    Give info if one textbox if other textbox have certain info

    Thank for the info. I have try to do this Private Sub cmdSystem_Click() DisplayText: IIf(Eval([Tapes] In ("AAG*","NSW*","NJQ*")),"UNIX"," ") End Subbut is getting compile error, "Expectewd:list seperator or" at IN I am not so good with vba at the moment
  15. H

    Give info if one textbox if other textbox have certain info

    Is this possible, I have 5 textboxes in my form, in my fist textbox I am putting info in, so I want my last Textbox to give certain info if there is something in the first text box. Eg. in my first Textbox I have AAG123, so in my last textbox I want this to have this info "UNIX" in last...
Back
Top Bottom