Search results

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...

Thanks llkhoutx, I'll try and review same when I go down to my Son's this afternoon. However if it is as you suggest set to Draft mode, why do Excel and Word documents print in normal print mode, as does an earlier version of my ACCESS program? Cheers, Dylan

Hi im a newbie with an odd printing problem. I have written an invoice printing application that prints perfectly on my colour printer. When I try same on my Son's printer it comes out too light or perhaps in a draft format. On his printer (Black and White only), if I print a word document...

Pat, Many thanks for your prompt reply and taking the time to look at my issues and suggest some solutions. I am hay carting today so will have a look at implementing your recommendations tonight. Cheers, Dylan

____________________________________________________To populate the foreign key field - Me.TheForeignKey = Forms!YourFirstForm!TheKeyValue ____________________________________________________ What is the command string if you want to move data the other way from the open form to the first...

Thanks in advance to anyone that can help. Background: I'm working with Customers (Parent form), each of which can have several orders (1st subform), each of those can have numerous parts (2nd subform shows all of the parts for the WorkOrder). I then had a 3rd subform with list of all parts...