Recent content by Dylan

Filo65, I can't remember how to remove record selector. But here is the solution to the filtering on the form that you asked for. Cheers, Dylan.

Namliam, Thanks for your help mate. It is greatly appreciated. :D :D

I am trying to put the name "B & E Smith Pty Ltd" into a text box for a report. The output report appears as "B E Smith Pty Ltd" What do I need to do to fix same please??

Doc, I was having problems even accessing the site for the past 2 days from here in Australia. I tried several times from both home and work without any luck. Cheers, Dylan. :confused:

Please excuse the ignorance. I am trying to learn from the great information provided by Pat and others in this forum. But where do you insert this code? Is it in the main form or the subform. It's just that I can't see a Event called RESIZE

Mile-O and Max, Thanks guys for the prompt response. I sort of knew what the answer was going to be, but wondered if it was possible? Thanks again.

G'day, I'm hoping that someone can help me please. In the attached database I calculate Costs for campsites based on days spent at site and the number of Adults, Children etc on the booking form. Although the results are correct on the subform I don't seem to be able to get the values for...

Betheball Take results from your first query giving you MaxId and employee. Then make a new query based on the first query results and the other information you need from the source table you used in the first query to get the other employee information that you require. I.e. Use results...

Phish, Try this I think it will solve your problem. Dylan

G'day Pat, Many thanks for the pointer. The issue was documented in the Known Bug database as BUG: Conditional Formatting Community Solutions Article - 555033 Once again thanks for your prompt reply and assistance. It is really appreciated. Cheers, Dylan

Hi, I have just upgraded to 2003 from 2002 and found that on one of my forms two calculated fields appear to be repainting themselves in a subform almost continuously. In fact I have a digital clock on this form which normally updates every second and a label on a check box that does likewise...

Hi llkhoutx, Any chance of attaching a working example??

G'day Pat, I did as you suggested. It worked a treat. Many thanks again for your prompt help and suggestion. What a bonza site to have folks such as yourself and others providing guideance and coaching. Cheers from Down Under, Dylan.

Just a quick update. I am using ACCESS 2002 on Windows XP I found using search a recommendation from GHudson to download JETCOM.EXE from the microsoft site. I did this and was able to compact the database successfully. I then opened the newly compacted database and found that it works ok. But...

Hi I am wondering if the resident guru's can please help me with another problem? I have started to get the following popup message when trying to compact the database automatically on close or at any other time I try to do a Compact of my database. 'Table "TempMSysAccessObjects" Already...