Search results

Thanks for this. I'm not having much luck with this simple task. Where is my reference from the code to my unbound text object? Also - does this code actually generate the title based on the parameters I have chosen in my query form? I only have one report template that my QBF loads, but I...

Hello, I have been producing some reports with my new found 'query by form' skills. Thanks to everyone for helping me out with that. I would like to be able to add some sort of title automatically based on the parameters chosen on my QBF search form. Can anyone tell me how to do this or post...

Hello, I've attached my DB - I must be missing something obvious but would be grateful if you or somebody else could have a quick look and tell what I have done wrong. I just can't get this query by form technique to work and I'm pulling my hair out. Thanks very much

Ok, modified my DB to include code from your sample, replaced the relevant fields and references and tried it out. When I press my preview button, which the code is assigned to nothing happens. Not even an error message. I got this far with my last attempt at a QBF. I don't know what I'm doing...

Thanks a million. I'll have a play with this and see if I can work it into my DB, I'll let you know how I get on tomorrow. Thanks very much for taking the time to do that, very much appreciated. Fraser

I'll have an attempt with some of your code first though!

Hello, Thanks for this, I see this is full code for a QBF as well. I tried the QBF a couple of times but never managed to get it to work. I tried sample databases and then replicated these and tailored to match my DB. This method has helped me learn a lot with Access. Unfortunately I couldn't...

I have tried your code and replicated it for the other combo boxes but it doesn't allow me to only select some combos instead of all. I therefore still have to fill all four combos with exact info to return records for an exact tool group, manufacturer, model and condition. Any other...

Hello, I have a query set up as the record set for a form containing combo boxes. The form has four combo boxes with various drop downs. I have linked these combo boxes to the query using this syntax in the query: [Forms]![frmToolStats]![cboModel_Number] I have a preview button report on...

Thanks Hayley, I also found another post of yours. Once again providing some excellent assistance. I think I will probably leave this until tomorrow. You're right, it's quite a large post and I need to get my head around it and then my own setup. I may (and almost certainly will) be in touch...

Yeah, well I had already accepted that, but wasn't entirley sure what the best method was to use. However, it is the only method I know at present and for the time being gives me the results I want. I am under no illusion that this needs changed before I add more data. I have been doing a...

Hello, I am trying to get useful data out of my database now. One of which is the number of employees and their details based on specific criteria in a query. At the moment I have a query for each single criteria and then a report for each query. The query and reports are identical except for...

It was the quotation marks. I removed them from the "queryname" automatically in the first instance. Assuming that that just meant to input teh queryname in as [queryname]. Sorry, simple mistake to make. Got there in the end though. Thank you all for you inputs. I won't bother any of you for...

I've tried Kempes syntax and I get the same error. I've double and tripple checked the spelling and it's fine. This box isn't for the report, I have one for each report. This box and amny other like it is for a form of statistics i.e. one form which shows the total number of employees for X and...

Hello, I am trying to set up a statistics summary of my database. Part of this is the number fo records counted in a query for various queries. I found this on the forum: To show the number of records returned by a query, you can use the DCount() function. Put a text box on the form. Put...

There you go! Perfect. I knew it had to be my Access ineptitude somewhere. Thanks very much for your help.

I am indeed, but I'm from the Kingdom of Fife, a Kirkcaldy Lad. That didn't work. See what I mean, simple things just don't seem to work for me. Here's a run down: Report based on query. Query reports all employees (name, payroll no. etc based on a criteria) Report shows all information as...

Hi Hayley, Tried that, but it doesn't like that either. Still get the same error for some reason. I seem to spend all day trying syntax in queries and reports that should work, but never do. Maybe it's just my rubbish Access skills.

I am still trying to get a total count of the number of rows in a report. The report lists employees as defined by my query. I wnat the report to tell me how many rows i.e. entries there are for that report/criteria. I have put this in the footer, in a text box: =Count(Location) I just...

Thanks Le.