Recent content by hokkienmee

Hi all, I have finally found my whole package of installation CDs and ready to re-install every single thing, beginning with my windows 8. Just a last attempt before re-installation, I tried to tabulate all the possible combinations that results in the mysterious error. The error is simply not...

I am wondering if there is anyway I can rename the thread? The way it looks the problem is not what I initially thought it was. Is there anything that I have not yet tried?

In the Format tab: Short Date: d-M-y Long Date: dddd,d MMMM, yyyy Short Time: h:mm tt Long Time: h:mm:ss tt First Day of week: Sunday In the Example, it shows: Short date: 9-4-14 Long date: Wednesday, 9 April, 2014 Short time: 2.01 PM Long time: 2:01:03 PM In the Additional Settings, Date...

I have made further tests. I created blank database in 32-bit access with a new table with field Date/Time, format Medium Date. If I entered the date manually into the field, the date is shown correct. But if I enter the date using the date picker, the date entered into table is wrong. Date...

Hi JHB, Thanks for the reminder. I have opened the back-end database directly using the 64-bit version. I have uninstalled the 64-bit office and installed the 32-bit instead. Opened the back-end directly with 32-bit access. I have cut-and-paste the back-end table from 32-bit access into...

Would very much appreciate even if its a suggestion or hint. I have completely no idea. Thanks.

Hi, Sorry for the somehow confusing title. I tried to be as descriptive as I already can. I have also somehow lost touch with what I did, so please forgive me if I am describing my problem the wrong way, or using the incorrect terms. This is my problem. I wrote a database years ago for my...

try setting the default value in field EQUIPMENTNO to =DMax("EQUIPMENTNO","ASSETT1")+1 that's what i did.

I have managed to extract a sample from my database to show the error. at first it seemed consistent with the errors i mentioned with the report without creditor address. but after i removed the actual creditor address from tblCreditors, the behaviour appears on both reports using qryStatement...

thank you llkhoutx, i think i might have got the solution. i'll try to attach a sample database to explain what i saw and what i did.

Kevin, There are 4 views in Access 2007 1. Report View 2. Print Preview 3. Layout View 4. Design View

Thank you for the reply.:) i have no details to show in this report, so in it's property visible is set to 'no'. 'Debit' itself is a sum of the Price x Quantity. 'Balance' is supposed to be a running balance of Debit. Both are already grouped into the header TrxRecID which is essentially the...

Hi, I have 2 columns in my monthly statement, Debit and Balance Debit =Sum([tblTrxDetail]![WSPrice]*[tblTrxDetail]![WSQty]) Balance =Sum([tblTrxDetail]![WSPrice]*[tblTrxDetail]![WSQty]), Running Sum Over Group It works just fine if the report is in Print Preview. But if in Report View, the...