Recent content by FISHiEE

Hi, I am in a similar situation here and would be interested to see if you ever solved the problem. I am currently accessing the suitability of Office 2007 as an upgrade for my company and am finding our Access database performance is terrible on it whereas it is fine on office XP/2003. I have...

Perfect. Fixed the problem straight away. Bit annoying to have to do that but I will remember for the future. Many thanks!

Hi, This is really annoying me as it seems to be a very simple filter but I can't get it working correctly! I have some code that produces a text string filter for a report depending aon what users enter for filter conditions on various fields on a form. All works fine except the date...

Hi, I have discovered a problem with my database and wonder if anyone here can point me to the best solution... The problem is this... when I took our company database over about 3 years ago it was around 45MB... now it is almost 350MB and growing steadily. I have today discovered the main...

Hi yes I tried those options already but made no difference

Hm... it does help on some screens but it is still noticeably slower than when run on office 2002/2003....

Aha, looks like the can grow option is set to yes on some forms. This doesn't look to be the default setting so I guess the guy who set the database up set it to yes on some forms for some reason. Will see if this fixes all problems. Ceetainly there are performance gains on some screens.

Hi, Office 2003 will be going on shortly if I can't fix the problem as 207 is just soooooo slow that it's not worth bothering with. I shall check the can grow and can shrink options, but unless they are turned on by default then they should be set to no. It's not just when running the...

Hi, I have an access database that runs fine on our current systems (mix of office 2002, 2003 and windows xp/2002. However we have one new machine here running windows vista and office 2007 and the database runs super super slow. just about every operation takes 10 times plus to run! I have...

Hi, I have a database here that is run by users who use either Access 2002 (XP) or Access 2003. I have noticed something which to me seems odd and dunno if any of you guys could explain why or how to resolve it? If one of the 2002 users opens the database it opens fine first time (I use 2002...

Ah... I'd searched this forum for a while with no joy but as soon as I post this question it suggests similar questions of which the first had the answer. Dunno what I was doing wrong when trying to find it! The solution is to format the date as follows: Format([MyDatefield], "mm/dd/yyyy")...

Hi, I have what to me seems to be a very wierd occurance in my work database. I'm trying to fimler a report to display data over a certain date range. the user enters the start and end dates on a form and then code runs a rport and filters it based on the dates (and other fields) on a form...

Thanks for the quick response ken. Not really easy to post as it's quite well tied into a 125MB database. I'll see if compact and repair makes a difference. I have managed to get around the problem by simply setting the tab stop field to no.

Hi, I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum. The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have...

Actually managed to find this in the built in help! The following is how to determine if it's a new record you're on: Dim int_newrec As Integer int_newrec = Me.NewRecord If int_newrec = True Then MsgBox ("New Record!") End If