Recent content by Becca

In case it helps in jogging someone's memory of having a similar problem - here is a screen sump of the error message. It seems to happen no matter how simple or complex my table is. I am starting to wonder if I am just missing the point in how to use it in 2002, or if there is just somethign...

Well after the first heart attack at Doc's caps, the computer seems just fine. I would have been suprised if there was anything wrong with it, I only got the laptop two months ago and so far its been a dream. I've backed up things just in case. But thanks for the warning Doc Man! As for you...

Reply - better late than never Just in case anyone needs an answer to this problem - you don't need to have the linked controls pasted into a subform in order to link the subform to the parent form, in other words, if you have controls you don't want to appear but need them there to link, have...

Thanks guys Doc Man, Kevin and Ecniv Thanks for you help, I have just given in and just imported the stuff that wasn't schmeared into a new db. Unfortunately, i had tried the repair thing, but it didn't help. Interesting by word on this - my problem sounded more like Ecniv' experience with...

Hi I was working on my most fantastic form, had attached another subform to it (no.5) and was changing the view to view the result, and *boom* access shut down on me. I reopened the file and now the form no longer is listed in my list of forms, instead I have about 15 phantom form icons with...

Hi I am usually pretty good wih pivot tables in Excel,and had no issues in Access 97, but using PTs in Access 2000 has got me stumped. I have a query with the (simplified) feilds [activity] [Year] [totalPrice]. The source of the query is another query that has a parameter linked to a parent...

At the moment my option group does not hold my code for the updating of the main form. The option group has three buttons - which when pressed updates control [status] with either 1 (Reset), 2(Authorise) or 3 (Finalise). I also have a checkbox on the main form only available to the...

Hi I have a form which has a field called status. There are 3 status buttons in an option group which allows the user, depending on their access to: 1. Authorise, 2. Finalise, or 3. Reset to unauthorise. Once the user clicks on Authorise, it will disable all controls from entry. Clicking on...

Thanks JJ its just beautiful

Never mind - I found what I was doing wrong almost straight away - nothing wrong with the code, just hadn't changed my back style to "normal" duh-oh

Hi I would like to conditionally format specific records in the detail section of my report. The records have a yes/no record associated with them indicating if the entry is blocked for entry and hence should be highlighted in the report. I don't want to highlight the entire Detail section -...

Will try that - thanks for your help.

Hi I have a form with a multi - column list box on it. What I would like is to be able to click on one of the column headers and be able to dynamically sort the data in the list box. I have seen this done in other programs for reports - but I get the feeling a list box doesn't have this...

A weird one I have a DB of about 10mb on a server. I can print out reports fine on my computer, and so can another one of my team members, however about 4 other ppl in the team have Access97 freeze on them when they try to print out from my DB. This seems weird as all our pc's have the same...

Hi I have just finished formatting a tremendous report in my DB to circumvent the old clunky one used in Excel. Unfortunately, it now tells me... ! Too many fields defined! Apparently according to the little paper clip, 255 is the maximum in my report.. which sux, pardon the french. Any...