Search results

Thank you arnelgp, your suggestion fixed my problem.

Thanks JHB, but it made no difference. I am still getting numbers instead of names. I cheated for the time being and made a jpg of my legend and pasted it on the graph.

Hi Ranman, Thanks for getting back to me. I don't think this will work, because the heading can be one of 8 items. Regards, Poco

Hi, I would appreciate some input on this, I have a Graph that uses a crosstab query to generate the data. Its only a simple query. One of the fields is project type, but in the query this changes to a number instead of text? I would like to have this as text but don't know how to go about it. I...

Hi, I have a query that is wrecking my head, it is the format of my query that is my problem. I have a form that a users has an option to select a trainee name and filter the data, now I want to add a start and end date, sounds easy but no matter what I try, my query is showing all the results...

vbaInet thank you for your help. It is just what I needed.

Unfortunately that isn't an option. This report and several others in the same format will be automatically printed to PDF and displayed on screens each day. I'll try and format the report differently. Thanks for all your help.

JHB, thank you for getting back to me and thanks for making the change I asked for. One question, when I print the report on a monday, the second page is completely blank. It is probably because of the way I have 5 graphs in the report design. Is there any way around this?

Here is a stripped down version. I'd appreciate any feedback you have.

JHB, thank you for your reply. I haven't used record-sets. I just Googled record-sets there and I wouldn't know where to start. Is there any other way to hide the graphs?

Hi, I have a report that contains 5 graphs, one for each day of the week. I run this report daily. When I run the report on a Monday, only the Monday graph displays data and the other graphs are blank as there is no data for that day just yet. Is it possible to hide these graphs if there is no...

Thanks for getting back to me. If I do get it to work the aim was to run a query to generate a list of items required to make a part and have a button on the form to merge all these PDFs into one from the hyperlinks.

I am hoping someone can point me in the right direction? I have searched but cannot find a similar request to this. I Have a table with 15000 entries. This table lists components we use. This table is used to generate queries/forms. I have been asked to add a hyperlink to this table to link...

Hi Namliam, That is perfect, thank you. How can I repeat this code 10 times in the one form for each product? Thanks, Poco

Namliam, your code is beyond me and I tried to get it to work but couldn't. I don't know how to jump between or combine functions, no mind linking it to tables with file paths etc. so I have to give up on your method. I have Nigel's code working only because Nigel spoon fed me. What I would...

Thanks for all your detailed replies. Just when i start getting places, my brief is changed. Now I have to send a daily report on the file counts of the previous day. Thanks for all your inputs. Poco

Hi , I have being requested to create a from that displays the number of files in different folders. I can accomplish this somewhat with the code below. In the example below it is only showing the code for the first 3 folders. I have 7 folders in total to count. I have 2 problems that I hope...

I have to admit defeat on this one. I can't seem to get it to work. I'll try and go at it from a different angle and get the 3 queries to load into a form/table one at a time. Thanks for all your help with this.

I,ve had to put this on the back burner. Thanks for getting back to me. I will try again with your suggestions. Regards, Poco

Hi Pat, I tried a query with thre Rand function on my union query SELECT TOP 15 Query2.[ID], Query2.[Weight], Query2.[StockCode], Query2.[CurrentQty], Rand([ID]) AS Expr1 FROM Query2; and I get undefined function Rand in expression. I am using access 2010. Poco