Recent content by mhisma

I am sorry, here is the attachment

thanks for the answer, I have successfully linked the two combo boxes but how can I update the value on the text_box1 (ROOMS) based on the value selected on combo_box2 (HOUSE_NAME)? Usually I use the code as written on code sheet ( on the attached mdb) Kindly need your help, i am frustrating...

Dear All, I have two tables and a form described below ( example only) Table A Housing_Complex_Name Alpha Bravo Charlie Table B House_name Housing_complex_Name Rooms Doors Windows Alpha01 Alpha 4 5 10 Alpha02...

Dear forum, the given advise has worked so well but I still need some advise about how to handle this. I've put a command button on the form that will run UPDATE_LAST_STATUS automatically, it worked fine when I copy the FE and paste it on my own C:\ drive but when i copy the FE and paste it on...

Thanks for the nice advise and assistance

For example, I build a form to input the result of an oil well reviewing in a team meeting. So my form consists of 1. Combo box named OIL WELL contains list of oil well name in an oil field 2. Text box named PRODUCTION which containing last production of this oil well 3. Text form ( memo )...

updating front_end I am sorry for not remembering it before, the form consist of two part, the input part and properties data part. The properties data part is not static data,it may change daily and its source are several ODBC database ( linked to access application ) how can people with...

OK,it works well great thanks for the assistance

No, the copied front_end mdb is double clicked in the local drive,OK, I understand now why nothing happened when the copied mdb is double clicked by the user. Would you like to advise how to deal with this problem?

I am running Access 2003, the other did not install Access on their PC, they just install Access runtime. Can we use Access runtime to view splitted database?

Dear forums, kindly need some suggestions, I have a mdb file that has been splitted into front end and the back end for multi user database purpose. front_end contains a form named INPUT that will be shared to the other team member by locating it on the network drive ( M: for example). I put the...

would you like to share how to create a word document that enable copying FE to user local drive and also auto update tools? I think that's the safer way, coz i just worry about the reliability of data

Bob, thanks for the quick reply, is there any way to split database with VBA code ( not by wizard ), so the front_end contain only the AA_INPUT form, while the rest ( queries, macros,tables ) are in back_end mdb ? Kindly need your advice

Dear All, I have a mdb file, named by AA_DATA which I put it in the shared folder to enable another team member to access it. The mdb contains form named AA_INPUT to input data to table named AA_TABLE and I created a shortcut ( on the same folder with the mdb) from AA_INPUT so user can directly...

OK, both works thanks for the help .... :-)