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 strongm 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: Heita
  • Order by date
  1. Heita

    check dataentry

    Hi! One simple question. I have textfields which are bound to integer datatypes. If the user types in text i want my own msgbox to "override" the messagebox that Access produces since it´s not good for the unsers. E.g. check myself that the datatype is the correct one. If not, show...
  2. Heita

    check textbox

    Hi! I have a form for the user to tipe in information. When the user closes the form I want the "close" button to check if there are fields that are filled and if so,,ask the user if he wants to save that information or not. If all the fields are empty then no msgbox will show. this...
  3. Heita

    keyfield is number +1?

    Hi! Thanx. I can´t use Autonumber since the users kinda have started on 4578 and up so it dosen´t start at 1. So I made an question instead, But when I dry to put it in the control source of the textfield or as default value it just says ?Name, as it cant find it or something. Do u have any...
  4. Heita

    keyfield is number +1?

    hi! I have a primary key which is of a number type (long integer). When the form opens the text field containing the keyfield number should automatically be the latest saved number + 1. I.e. Last tiped number 7879 and when the form opens it should be 7880 in the field. Can the Default value...
  5. Heita

    BeforeUpDate, access 97

    Hi! thanx but I just get still the window saying " you can´t go to the specified record, u may be at the end of the record set". doh. And i´m sorry but I do u mean strSQL="SELECT textbox Or fieldname in table/Orfrom.checkfield FROM Table or Form? ´thanx again
  6. Heita

    BeforeUpDate, access 97

    Hi! I have Form where the user can tipe in information which is saved in a table by pressing a button. I want a msgbox appear if the keyfield has the same value as a field in the table (duplicate value) when the "Save" button is pressed. Can the BeforeUpDate be used in some way? I...

Part and Inventory Search

Back
Top