Search results

hi, forget this, I think I will just save the report as html instead.

hi, I have a few reports with drop down boxes. They appear fine when viewing through MS Access97. but when I export to Word XP some rows show up twice on the report. Under properties of the report I have clicked Yes to hide duplicates. but this still happens. Has anyone seen this before ?

thanks Hi, that seems to work. thank you.

Hi, I am using Total_Time: Format([totaltime_mins]/60,"00") & ":" & Format([Totaltime_mins] Mod 60,"00") To display the time as hours and minutes but this formula doesn't always work correctly. for instance if the totaltime_mins = 90 then total_time is displayed as 2:30 also if...

cheers, I think this is what I need.

hi, I think I have figured the problem out, some error in my code. I have found this formula to work on the time difference : test: Format(([Start Time]-1-[End Time]),"Short Time") but I need to times by a multiplier to get the final hours : minutes. If I try Format(([Start Time]-1-[End...

Hi, I am trying to show the time difference between 2 times but the calculation is not working correctly. First I work out the totaltime on mins between 2 dates using datediff, then I am trying to convert to hours and minutes like : Total_Time: Format([Sumoftotaltime_mins]/60,"00") & ":" &...

hi, ignore that last message. this works fine. (I had the aclastrecord command in 2 places). Thank you so much for all your help..

hi, yes it makes sense, cheers. problem is I am now receiving the error, you can't go to the specified record when trying to goto the last record.. I hate access. :o)

hi, thank you thats brilliant, although where does the requery bit go > in formb or formC ?

Hi, just to let you know , I want to show the newly added record.. I can add the record, so starts showing 1 or 10 records, then it is added and shows 1 of 11. but I want to automatically display record 11.. If it is one form it works, but I can't get it to work with subforms.. thank you.

hi, how do I do the pause you mention ? I have formA then in there formB I click a button on formB to open formC to add the record. formB needs to then show the last record...

Hi, I have a form, with a subform in it. I am trying to add a record through the subform then once added I want to display that record.. at the moment I add the record but the first record is shown. I have tried adding : DoCmd.GoToRecord , Forms!frmviewscheme![QScheme_Establishment subform]...

Hi, I have fixed this.. If I right click the MDB there is a button to unblock ! click that and it will work ! thank you anyway.

hi, the bizarre thing is, if I copy the database to a network drive it then works ! so C:\test ( my local computer) doesn't work S:\test ( a server ) works !.

Hi, I am trying to open an access database (Access2002) from my computer ( C:\test\ ) and I receive the error : Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. how can I fix this problem ? regards, Jam

thanks Gemma, a simple IIF statement is all I needed !

Hi, After further investigation the problem with this is I have values like 0/0 and 1/0 how can I change my division row to work with those sorts of values ?

hi, I have dividing one int field by another and the results varies from 0 to 9999.999999999999 When I add a SUM(newnumber) into a group field in reports I get the error : This expression is typed incorrectly, or it is too complex to be evaluated. I think it might have something to do with the...

thanks Neil, I will add the dummy row, that might fix it !