Search results for query: *

Ah yes. Gotcha. Sorry...mistake.. Does what I tell it to do now! Thanks alot. A.

Hmm. Thanks Guys. Tried putting DoCmd.Maximize in the Activate property of my form, but it still happens. My question might possibly have been misleading. The form with the buttons is a 'Menu' form. I want this to be always Maximized and at the 'back' so that it is always filling the screen...

Hi - what do I need to do to stop this happening..? Button opens a report from a maximised form. When the rpt is open, when I minimize it (which I'd like to be able to do), the form(s) open behind it have shifted down about have a screen (not minized) just moved. How do I keep my forms...

Thanks Gary!. Just what I needed to do. Thankyou. Andrew.

HI Gary - I hope you might still pick this thread up....I have another question. I want to add a date selection criteria into the query that drives my report that you helped me with. This is fine. My user inputs 2 dates into unbound fields in a form, which selects records with values of the...

Gotcha....Thanks... Works out fine. Andrew.

Hello, What method should I use to do this? I have a form with 2 unbound date fields on. The user inputs two dates and then clicks buttons to preview reports based on queries that use the two unbound dates. But the queries only work if the form is refreshed before the buttons are clicked to...

Thanks again Gary. That worked just fine. Cheers for your help and easy to understand explainations. : ) Andrew.

Nice one Gary. That does just what I want....atlast!.... One more question. Is there a way I can put the values of HighQLevel on the report in a particular order...ie the order that they are in in the new table I created to hold the row sources? (Not a-z ascending or descending but a particular...

The field is stored in my main table, but the 12 values are entered into the lookup row source for that field. Do you mean I should create a small 'reference' table containing the row sources for this field? How do I a 'left-outer join' in my query to use as the rpt record source? ...Sorry...

Hi, Thanks for your advice Gary. That method does give me mostly what I am after, except... I have grouped on field HighQLevel - a field with a value list of 12 different possible values. At the moment, if one of these values has not been chosen at all in any record in the DB, then the report...

Hi. I have a list box on Form1 populated with fields ClientName, ClientID, with a cmd button to open in Form2 the record selected by the user in the list box. Form2 has a cmd button that closes it and opens Form1. When I add a new record in Form2 then close it with the cmd button to open...

Hi - I'm sure this is easy to sort out but I am a novice (still!). I have a report based on a query (which just pulls together lots of fields from one table plus a field [Ethnicity] from another query). I have a command button on a form that opens the report for that particular record, but if I...

Thanks Gary. Sounds promising. I'll give that a whirl and get back to you when I invariably run in to trouble... Andrew.

Hi - can anyone help? I am trying to produce a report showing various record counts from my DB. Each record in my table is a Client. Table name: client_table Field names: ClientID (PK) HighQlevel (has 9 possible text values... none, level1, level2, level3, level4..etc...) Gender - male/female...

Hi, On a form I have a combo-box field (EthnicityID), bound to Client_table, its values are populated by another table, Ethnicity_type, (fields: EthnicityID, BME), in which for each value of EthnicityID there is a corresponding BME value (yes or no). For each record in my client_table I want to...

No...thanks.....can you tell me a little more how a Pivot table would work? A.

HI - Can anyone help me with this....I'm am completely confused now.... Here's what I have: Each record in client_table is a Client (ClientID is the primary key field) Field names in question: HighQlevel (has 9 possible text values... none, level1, level2, level3, level4..etc...) Gender -...

Thanks Leslie, Right. Yes, sorry, I realise I have been misleading. I just named them so for ease in the post, but I guess that was a bad idea... My fields and values actually are: Qlevel: 1-9 Ethnicity: BME or white Gender: male/female LoneP: yes/no Homeless: yes/no offend: yes/no ref...

Thanks. I am trying this Cross tab query lark but don't seem to be getting it. My DB has: Qlevel : values range from 1 - 9 I have 8 other fields in the same table. Call them A, B, C, D, E, F, G, H. I need a count of records where: Qlevel = 1 AND field A = Yes Qlevel = 1 AND field B = Yes...