Search results

Unfortunately no, although I am happy to report a failure to report but cannot work out how to do it. Effectively I could list ones that fail their last inspection and ones where the last inspection is indeterminable. Effectively: ABC00001 Pass ABC00002 Fail ABC00003 Unknown This is for an...

I suspect I am going to run into a real issue here. On the old data I may have two records from the same day from different pieces of equipment. Record Date Serial No Result System 00001 21/01/19 ABC10003 Pass 1 00002 21/01/19 ABC10003...

Many thanks CJ, will take a good look.

Please find attached details, the latest or last record should be the most recent by date. Unfortunately I now realise that modern records have full date and time in this field but older ones assume the time as 00:00 so on those I would have to use a combination of date and then highest primary...

Hi JDraw, No, some parts do just fail but then they would still be unique serial numbers where the last inspection of them failed. Effectively this will list all the serial numbers that should have been sent to scrap. The table does have a primary key which is an auto-number showing the order...

I have a complex question and am hoping that somebody stuck at home will be able to help. I have a process where parts may be tested and fail, a repair attempted and the part retested, possibly on more than one occasion until such time as the part has satisfactorily passed final inspection...

Move the control, if a label is attached it will move with it.

I only changed the date bit, if you look at the data source of the report you just need to change the other bit there.

There is an odd issue in access with filters and the like only working when you open the report, not when you export it. I would put the date from and to in the data source of the report as date betweens. See attached

Make a date from and date to on a form and configure your report to work between them, make a button with the following on-click event: Private Sub Command25_Click() On Error Resume Next DoCmd.OutputTo acOutputReport, "ReportName", "PDFFormat(*.pdf)", , False, , , acExportQualityPrint On Error...

Many thanks Arnelgp, I may be a while working that out but will give it a go.

Well, I am beginning to think no :rolleyes: I was hoping I had missed an obvious easy solution but thanks to all for their help.

Hey, you learn something new everyday, this gives you the primary screen. Unfortunately I was looking for something that allowed a button press to just dump an image to a file in case it were ever required. I can obviously screen-dump, insert into another package and save out but was looking...

Well no, print screen would capture the content of both monitors as it is in extended mode, this is why I was hoping to grab just the form or even the database window.

Many thanks Arnelgp, I had basically done this as follows: DoCmd.OutputTo acOutputForm, "frmQuoteNew2", acFormatPDF, "z:\test.pdf" My trouble is that I am using a full screen and it is too wide for the PDF so goes to two pages, it also only prints the header to PDF, not the detail section. As I...

I have a strange question. I have a form that I use as a calculator for quotes and happily store only the data I usually require in a table but throw most of it away. Occasionally I want to keep a record of the maths for everything. The easiest way to do this would effectively be to just dump...

There is a setting in the chart for 'Primary Values Axis Format' which you can set to currency, this seems to achieve the $ sign rather than your universal currency setting.

It's only for my use so I don't care too much, suspect it is a bug from our friends at Microsoft but just put it out there in case I had missed the obvious.

I guess I am using a modern chart then :banghead:

I have a chart in a form that displays monthly figures from a query. All aspects of my database that are currency display as currency with the symbol set to £ as per my windows settings, the chart has $ Any ideas would be most helpful.