Recent content by nightwalker

hours conversion i would do it by VBA: on a button click or any other event's sub procedure i would use MOD and / to get the quotient and remainder of the hours ... i dont perfectly understand what you are actuall lookin for but i just thought of this silly way : convert the field in the table...

stuart i am not sure if i got u right but i would do it in VBA: in the Onchange event go to the code builder and private sub combo1_click() ' if not set the recordset then set rs=.... text1.text="" if combo1.seletext="A" then text1.text=rs![fieldname] else if combo1.seletext="B" then...

Dear members, i want my fields to have colors ... when i apply colors to the fields it works but as soon as i click refresh, the fields get white again ... does anybody know how to let the color settings be fixed and how to change em when required ... Thanks walker

Dear members, i want my fields to have colors ... when i apply colors to the fields it works but as soon as i click refresh, the fields get white again ... does anybody know how to let the color settings be fixed and how to change em when required ... Thanks walker

Re: pivot refresh the options... dialog box on the pivot table with the "Refresh on Open" option if this is not what u r lookin for lemme know thanks walker

Re: pivot refresh the options... dialog box on the pivot table with the "Refresh on Open" option if this doesnt help lemme know thanks walker

Re: Re: got it is it the options... dialog box on the pivot table with the "Refresh on Open" option that you are talking about or is there any other way ... thanks walker

Re: got it I didnt knew there was a way ... i am having the problem but havent found the solution yet ... could you please lemme know how did you solve that ... thanks ... walker

hi, i am tryin to use pivot table for a display like: |TYPE1 |TYPE2 |... |Name1 | Name2 |Name3|Name1 |Name2 |Name3 |... C1 | | ---------|------------|------------------------------------------------------- |A |X1 |X2 |... | | | | ... C2...

pivot refresh what i have found and i believe is that Access pivot table uses OLE to only connect to Excel and the refresh event is in Excel and not in access ... i havent found but am tryin to find a way to control refresh event of excel from access or a way to automatically generate it ...

you have two ways: 1> use many subforms on the same form and make their source as these piviot forms u have made 2> use tab control and on seperate pages use seperate subforms and this way ur data si gonna be more organised thanks walker

pivot refresh pivot table just links to Excel through OLE and the refresh event doesnt occur in Access but in Excel ... this is based on help browsing i did on access97 ... i am tryin to find some other wayu but i believe that has to be in excel to do that automatically ... walker

pivot refresh pivot table just links to Excel using OLE but Refresh event has to happen in Excel ... not in access ... This is based on the help on Access 97 ... i havent found a way to refresh in excel automatically ... sorry

password protection sorry but i havent understood the workgroup way of password protection ... i am lookin for ways for this database in network to make it password protected ... what other options u think are possible ... your help would be appreciated ... thanks, walker

There is a Pages Collection which has Page as the Object ... and then you can specify the number of the page you actually wanna see ... its same concept as Forms Collection ...