Search results

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 .... :-)

Hi All, I have a form with several text boxes. In a textbox, named it by "current user" I typed = CurrentUser() in Default Value tabs so I hope the text box will show the user who is using the form, but when I switch the view into Form View, the text box remains blank ( didnt show any value...

Hi All, I have developed a simple MS Access application (many thanks for the assistance from this forum) and the application will be used by another member of my team work. PC's of Team members are connected each other by server. We have shared folder to storing or exchanging files, everyone can...

OK no problem, looks like I should ask my boss to communicate this network problem with IT guys, i am giving up now ...;-) thanks a lot for the nice discussion

I try my best to explain my problem to you I work as an employee in a team consist of five employees for example, each employee has their own PC. We have a shared folder containing sub-folders and files so all team member can access and use . I placed the mdb file ( I named it Employee_data.mdb...

thank you, it works now the new problem has just appeared, I worked in a team and I gonna share this form to entire team in a share folder. I am the only person who permitted to install access on my PC ( based on bussiness need ), so the other person will open and input the data on the shared...