Search results

Dear Sir/madam(s) For security reason I have written following set of codes to open the form called editRecordF. Is it possible to use this single set of same codes to open other forms? Private Sub cmdOK_Click() Set db = CurrentDb Set rs = db.OpenRecordset("UserT", DB_OPEN_DYNASET)...

I am sure nobody else could understood what I mean to say in my earlier statement. Now I am going to expalin in other way. I actually wanted to write code for password to open form named , frmAddRecord and frmDeleteRecord. When I click control button named AddRecord, I want that it prompts...

Dear all, I'm self learning ms access Person. I am in the course of learning more about module.I understood that module is used when we think that there is repeated codes to be use. meaning to reduce the repeated codes. I have Following set of code for allotting password for opening different...

Dear Mark, Please treat my second request as cancelled. because with the idea and suggestion that you have provided helped me to solve now. i have written seperate function or code for that. thank you once more. Sangpo

Dear Sir, I have corrected my original code above with following code you have suggested: It solved about 95 % of my problems ie it calculates total amount of salary after adding allowance.. But it is not displaying or showing total amount of allowance in the desinated textbox named...

Hi all Yesterday one Sir had expaline me when to use and atvantage of module. Since then Im working hard to learn Module piece by piece. So I have written following code in the module for calculating the increase of salary (percentage wise base on current salary) and simuentaly to calculate...

Dear John Sir, Thank you for your prompt response. I am exploring the link. Now i understood advantage or concept of using module which it would basically reduce repeating of action or code Further I would appreciate you, if you could list down/provide me the list of what kind of actions...

Dear all, I love to work with Ms access. and learning it by myself since last 1 and half years. I am leaning from internet and by looking at other's simple database sample. I have googled manytimes to learn how to use Modulle . i mean what is the atvantage of using module. Therefore , Ill be...

Sir, my two problems solved. ie wild card seach and single date type data. I use # instead of single quoate and my problems solved. But my another problems for 2 dates. ie. I want filtter from date and to date. where we used to write in qurey design like , between date..And to date somthething...

Hi , sir ((VbaInet) Hoooree. It does work well. Thank you. With this idea, I want to filter data from Date to Date with foll0wing code but not working. please Sub fromdatetodate() Dim SQL As String SQL = "select * from qc_logT" 'SQL = SQL & " where fromdate = #" & txtdate & "#" And...

sir, thanks. you a lot. now it works perfectly for wildcard search.. I have not type the correct code that you have suggested. Thanks u so much. But my second problem is that. name of field is= resultreceivedate . Type is date. name of combo box is =txtdate purpose is= to display data...

Sir, Ok as suggested by you. Following are the codes I have tried This is code wildcard searching from the text box. eg. If i enter A then all item with A must dispaly nad if I type AC then all item starts with ac be displayed. The displays are in the form. I have used the format of form as...

Please refer to my statement where i have said I" i have uplaoded my pice of database. but seems not upload. CCould anyone tell me how to attach the data base? sorry

Dear Sir, Thanks for your resposne to my qureies. I have tried a lot as suggested by you. However my problems did not solved. For your reference and further suggestion, I haved uploaded the my pice of database . Please kindly make the correction. Thanks a lot Im from Bhutan

Hello, 1st Question : I have following codes written in access 2007 to display the items that iI select from Combo box named combo62. This works well. But i am struct as to how to change code for displaying items .eg. to display all item begines with A,AE, B or BB ect I tried this SQL = SQL &...

I am from Bhutan.coordinates of my place is 27 27.264 lat 89 39.216 Long I am learning ms access by myselves since 2 years back. Now i know little more, but still I have many probles that encounter during work or learning. Thank you all