Recent content by Flea

That's what I was thinking the answer would be. Thanks!

Did anyone ever figure this out? Trying to solve the same issue now.:eek:

Finally found a post on another forum with the same problem. For the record: When a database is saved/compiled with a breakpoint phantom breakpoints can occur even though you have removed and saved the code. Solution: Select Remove All Breakpoints and change code in any module then...

There is an option to compact automatically when the database is closed. Tools/Options/General tab - Compact on Close. It will not compact the database if someone else has it open. Also, if you have a split database then this would not compact any attached databases.

We use remote updates and I haven't seen any messages that my system needs to update anything. Just in case I ran the Install New Patches and Install New Applications then ran a repair on Microsoft Office. Unfortunately, the problem is still there. I'll have to check with IT on anything else...

I have a 2002 database that has been working for several years. When the front end database is opened a form opens that grabs the user id and their security level then goes through coding to re-link the back end tables and then opens the switchboard form. Starting today, when the database is...

Hans, You can use the DatePart function to get the the week number: DatePart("ww", date). As for the rankings, the only thing I can think of off hand is to sort descending by a particular field.

DeepTrouble, Couple of things with your code: 1. You do not want to close your table and db until after the code is run. So I would move this to after the Wend. 2. This code will run for every record in the table every time. So your numbers will change each time. Is this what you want? Have...

I don't know if this will completely help you but on the form if you set the Cycle proper to Current Record then the user is not able to page up. They can page down however. I have not worked with multiple forms so I'm not sure how this will affect it.

I use a drop down box on a form to indicate my parameter data. I have to place the parameter data in 2 places in the query - in the QBE grid criteria and in the Query Parameter listing. That may be why you are getting an error. Hope this helps

You can do this, if I understand correctly by having a drop down or combo box with the row source with "SELECT prospectname FROM ProspectTable". Then on the afterupdate action do a DoCmd.ApplyFilter , "[ProspectName] = Forms![yourForm]![lstBox]" This should allow you to have manual input.

Finally I've found someone having the same problem that I am having, or close to it... I can get the chart title to change by using the following code: Dim sOffice as String sOffice = Forms!frmImport.lstOffice 'a list box on my form Me!graCompAT.ChartTitle.Text = "Whatever Title - " &...