Search results

  1. F

    Auto Title My Report

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

    Auto Title My Report

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

    Form to select report content

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

    Form to select report content

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

    Form to select report content

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

    Form to select report content

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

    Form to select report content

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

    Form to select report content

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

    Form to select report content

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

    Select Features - Print Custom Report

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

    Select Features - Print Custom Report

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

    Select Features - Print Custom Report

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

    DCount on Form - Error

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

    DCount on Form - Error

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

    DCount on Form - Error

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

    Count/Total Rows

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

    Count/Total Rows

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

    Count/Total Rows

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

    Count/Total Rows

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

    Multi Criteria Search

    Thanks Le.
Back
Top Bottom