Search results

yes W: one of the user did not have Access application installed on his PC. he can access the form, do data entry, modify entry, view report. but the version of front end changes, he gets the pop -up window saying version is outdated.. then nothing happens.... does this code need access to...

Thanks sos. i have been trying to make it work today. but i cant.... when i change the version on BE and FE table, the user will have the mde from his desktop deleted. but then nothing happens... he gets the pop up box saying that "not current version and will be deleted"... then nothing...

the instruction is as follows: For future front-end updates, every time you make a change in the front-end and want to distribute to your users, you will need to open the version table - 'tbl-fe_version' - on the front-end master and change it to a new number. Then, you need to open the...

I have created a pivot chart and then saved it as a Form. i then created a command button which is to open this form to view the pivot. So the user open the pivot when he click this button. Now the user can drag/drop some fields... like they drag out a row field. he exit. when he re-presses...

I am using this calendar so that the user can pick a date from this calendar to put in the text box. Is it possible i can disable past dates on this calendar so that user can pick dates >=Now() ? if yes, how? for example when you book vacations online, the internet website will not allow...

thanks sos... the reason i asked is because if you look in the database.. the path is stored as F:\xxxx\xxxx\xxxxx for the location of the master FE directory so what why i am wondering if it would work for another user who map it on a different letter....

thanks a lot it works.. i tried it on two pc.. the instruction in red was overlooked...it was not red enough.... :p i have a last question.. now i am going to distribute it.... the FE_master is stored on a shared network which has been mapped to G:\Accessdatabase\ but if one used has...

ahhh.. i dont have this in my front end .. which step did i miss from the instructions?? i did follow the instruction line by line how do i link it now....but also i want to know which step i missed.

1.03 is the value in the tbl-version_fe_master when i run the front end mdb.. i get this error run time rror 3078 the microsoft jet database engine cannot find the input table or query 'tbl-version_fe_master'. make sure it exists and its name is spelled correcntly

i debug and only the first line[one in red] does not work.. the one in green works.. ' looks up the version of the front-end as listed in the backend strFEMaster = DLookup("fe_version_number", "tbl-version_fe_master") ' looks up the version of the front-end on the front-end strFE =...

i am still getting this debug error :( the debug stop at strFEMaster = DLookup("fe_version_number", "tbl-version_fe_master")

can the FE file and BE file be in the SAME folder?? i am nearly there... When you change the frontend file.. do you need to re-do the mde?? because the file you provide is mdb not mde... i think there is syntax error the debug stop strFEMaster = DLookup("fe_version_number"...

Thanks.. i downloaded it and trying to use it. In the documnetation there is only two open file buttons.. i dont understand the third button. when you split you create a BE and FE... but why would you want to specify another folder where the master FE will be... should it not be in the same...

Is it the same if i do that? if i create a lot of folders on the shared network folder 1 => copy of user_FE.mde folder 2 => copy of user_FE.mde folder 3 => copy of user_FE.mde folder 4 => copy of user_FE.mde folder 5 => copy of user_FE.mde and then i ask the user 1 to run the mde from...

I have a column in the field which is the date the data is uploaded and is not sorted by this date. How do i display the latest date on a form in a text box? 1 Jan 2009 2 Mar 2008 2 May 2008 so on my form latest uploaded date should be 1 Jan 2009. how do i do that? do i have to query the...

I have followed this forum advice and i have split the database into FE and BE. Converted the FE into .mde Now i have emailed the FE/.mde to all users of my department so that they can do data entry. after distributing, i have modified a report/query. So i recreated the .mde and then i need...

this is the number formatting i am using:- _($* #,##0,_);_($* (#,##0,);_($* "-"??_);_(@_) how can i make this simpler and avoid rounding problems? if i divide it by 1000 and then round down ..... how do i change the number format above?? I am scared to mess everything up...

thanks. but it does not help me... i will be fired if i do that.. :). management team get together around a table with the report printout to discuss strategy etcc... is any other solution for the rounding problem?

because when i send this report to management team, they are picky people... They take out their calculator and get 777. they see only the numbers on the report not on the excel cells. they print the report and check my numbers. I always have a problem with this and wondering if there is a...

Cell A2 value:- 3503470.54999995 but when formated it is 3503 T Cell A3 Value:- 2725770.01999996 but when formated it is 2726 T When i do "=A2-A3" in A4 it is 778 T it should be 777 T... How do i change the formula in A4 to show 777 T instead of 778 T... this is rounding...