Search results

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 ?

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

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, 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 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

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

Hi, I am trying to import an excel spreadsheet into Access2000 using the import wizard. I choose my XLS file, I say whether or not the first row contains headings, (no is the anwser). Then I want to change some of the fields to data type of memo from text, but all I can see if Field 1 and data...

Hi, I have a spreadsheet with location, name and odb in the rows, eg : location name dob 1 Jo 10/02/78 1 Ste 12/03/82 2 Mik 01/11/59 3 Jop 11/11/90 3 Kat 02/05/78 3 Jo 14/04/84 How can I : 1 : Import...

hi, I hope someone can help me here.. I have a form with ID, town and address on it. I want to beable to type in an ID, press enter then if the ID exists in a query then populate the town and address text boxes with the correct info.. If the ID doesn't exist, then open another form so the...

hello, I have a strange problem with some access 2000 databases. I have 3 databases. when I open them all instead of 3 instances of access opening ( so I can view all 3 databases in separate windows) only 1 instance open meaning the open database I can see if the last one I try to open. has...