Search results

Hi there Can anyone help me, how to control the numeric field range e.g. number 00.01< and > 99.99 I am looking for some simply code under On Change() event Apart from this, would be help full, how I can restrict the field should only take input number no character or special characters Thanks...

Hi there I am trying to learn different feature of form "Controls" in access during my free time, nothing particular in order Right now I am trying to play with "Tab Control" My Tab Control have two tabs "Page1" and "Page2" Here's what I am looking for My "Page1" have two fields What I want...

thanks pr2-eugin There's nothing specific reason, I am just trying to learns control using unbound form What I do during my free time try different scenarios and play with the code (nothing else) like field formats, duplicate record, popup messages, change field colour upon specific colour...

Thanks CJ_London Autonumber is numeric field, I am just trying to learn e.g. user have its own access to create its own ID, could be numeric or could be alpha numeric

Hello there I am just trying to learn during my free time and need help from Access Guru I am trying to learn the controls therefore, my table consist of only 3 field customer ID, Name, Relationship (all fields are text) form is unbound I put two checks at customer ID 1) duplicate id - working...

Sorry for late reply, I was quite busy with my life routine

HI JHB Thanks for response, but it seem I am still missing some controls, as when i press tab or press enter button to exit the field (Yes or No confirmation not working) The input mask of the txtcid (text field) = >CCCCCCCCCC;; (I am not sure if input mask making some problem, but i am using...

Hello Guru's of Access again i need your expert guidance I am just trying to learn (during my free time) My training table consist of 3 fields and using unbound form 1st field custid (text field) This can't be NIL or Can't duplicate What I am looking for learning point of view (duel check at...

You're the best thank you

Hello Guru's of Access I am totally green in Access, just trying to learn during my free time I am trying to set focus the field, but unable to do can anyone help, where I am making mistake Case1 I want to make ensure that unbound form make ensure the record is already exists yes or no, if...

Yes, THANK YOU ALL

Thanks Any help Now I am getting Runtime error '3075' Syntax error in string in query expression 'Customer_ID='11111111' "11111111" or Customer_ID is a text field when i click the debug it say dbfailonerro = 128 here's the code Private Sub Cmdupdatecustomerbillto_Click() Dim dbs...

Thanks Paul after updating the information provided by yourself now, i am getting "Compile Error", Method or data member not found and upon clicking the debug button txttelphonenumber highlighted with Blue i attached the database for your review its in 2003 (please don't convert it, since i...

Hi there I am totally beginner in Access, just trying to learn myself during my free time I am using unbound form, to update the record, but I am unable to update the record, as when i try to run the codes, Access giving me following error The form, first pull the customer details from list box...

Hi there I am using access around after 15 year, now I am trying to build small databased for my budget purpose Here is the situation example FY2013 = Total working days Period 1 = No of working days & expected Exchange rate Period 2 = No of working days & expected Exchange rate so on...