Recent content by apoll0

I have figured out a simpler solution to my problem... My default printer was set to be a printer at work, so everytime I'm in report design page, Access would try to communicate with this network printer. This is what causes the network activity and 'freezes' in Access. So what I do now is...

I figured out what the problem was! So, for some reason, when I was in safemode, everything was working fine. Back in normal mode, I started disabling services - one by one... but the process was slow and painful. All of a sudden, I realized that everytime Access 'freezes', my network...

So it appears one or more other processes are interfering with the operation of MS Access. I started the computer in Safe Mode and tried opening reports in Design Mode and played around with it, everything works fine. Let's see if i can figure out what's causing the problem.

1 GB Ram with 80 GB 5400 rpm HD. Not a hardware performance problem.

I think it's just this machine. (IBM Thinkpad X31). My desktop has the same Windows & Office version, and does not show this symptom.

it's not the database, it's Access's setting. It's slow on ALL reports, with NO datasource even. I don't have any problem when I edit the reports on another computer (even if that computer links to the back end data file over a network). I don't think that is the problem because my "Name...

I have the exact same problem. Whenever I'm in disign mode for forms or reports (especially reports). Everytime I resize the page size, or making any small adjustment to the form, Access takes about 15-20 seconds to refresh. My back end DB is on the same local drive. This happens with...

I tried what you suggested, but the raw number with long decimal places is still there if i click on the field to edit. So for now, Round() works, because I also formatted the form to display currencies after rounding. Thanks Guys.

I've settled with using Round() in my query instead, which round up the number so it doesn't look messy, and it allows me to sum up the field... Wonder if there's another way.

Ok, I formatted in the Query call using either FormatCurrency() or Format() and it works fine. However, now I can't sum up the field value at my form footer because apparently, the fields are represented as String... Is there another way to format currency that I don't know of?

Yeah, I did the calculation in the query it self. I didn't know you can format it in the query also. Thanks. I'll try that.

Ok, don't know what I should title this problem as, but maybe you guys can help. The data stored on my table is formatted as Currency, however, when I Queue up the data, I also multiply it by a factor (exchange rate). Which turns the data into just a regular number. When I display this data...

thanks rak

Problem fixed. I tried opening a particular form in design view and it always crashes, all the other forms didn't. Opening any other form that contains the damaged form as a subform aslo crashes the program. So I went to the backup I made yesterday (luckily) and replaced the damaged one...

So here's my situation: Tonight I opened the file I was working on this morning (which was in perfectly fine state)... I opened a form - CRASH!! I press ALT+F11 to go to the VBA editor - CRASH!! I open another form - it works fine... So i select a button and tried to edit the action script -...