Search results

Thanks Pat, I’ve looked at your sample database but sorry to say I don’t fully understand the coding Attached is my table in design and a couple of manual sample entries Dont know if it’s possible for you to show what my coding needs to be thanks

Hi, I have a main form INSPECTION which has a field COMPONENTQTY With each Inspection, the ComponentQty is totally variable, 1 off, 2 off, 10 off, 100 off etc On the same form is a single form subform COMPONENTDATA and this has a field COMPONENTNO along with other fields of data What I’m looking...

Hi again Pat, please ignore my previous message, I just searched on the site and found previous question and answer(y)

Hi Pat, just about to try the two crosstabs but can you help what settings i use for the NOTES on as the field is text thanks

Pat, I’d really appreciate that thanks btw what’s PK & FK, probably obvious but maybe a brain freeze😉

It’s so difficult to show the exact scenario required but I need to obtain a report that shows the feature data along with the component data to its right, all in line etc See photo

I’m not sure if it can work with one table as there could be multiple components from 1 to 100 per feature

Hi Pat, Yes 1.1 thanks

I am, but to make matters worse, I wanted to place a different single column subreport on the left of the main report and the 3 column one next to it I never do things easy😉

When I view in report view it displays the results in portrait but in print preview, it displays the results in landscape which is what I want, however when the subreport is positioned with a left margin, that margin appears on all three records Back to the drawing board!!

Hi, tried that but no joy

Thought I’d managed to sort this but still a little problem😬 When I run the report on it’s own the data displays as landscape which is what I want however when I add the report as a subreport, it changes to portrait🙁 anyone got a solution or idea why

Hi, Attached are details from a table NISInspectionData which I’d like to produce a report, in landscape as attached sample spreadsheet I’ve tried a cross tap query but I can’t get it to include the notes colum any ideas thanks

Please see attached photo I have two questions thanks Firstly, on datasheet subform (Feature Information) to action as follows..... The first field (No) in the first row wants to start as #1, then I need the second row LineNo to be #2, third row LineNo #3 and so on Currently I enter these...

Hi, I need to run a macro several times based on a starting variable number Would a good method be to create a counter starting at that variable number and reducing after every macro run Examples would be good if you could assist thanks Truly hope I’ve described my issue clearly😉

Hi Pat, I’m not good in describing criteria’s and in this instance, the status field is simply text, I should have used other words as true & false have other uses I’ve managed to solve my issue with the update query thanks, I now move on to next stage I’m sure I’ll have more questions later😬

Many thanks for these answers Never considered an UPDATE, makes so much sense, sometimes the obvious is miles away😉 I’ll try tomorrow and let you know

Hi, Wonder if someone can help me with a vba Do While Loop..... Even though I’m quite experienced in Access, I’ve not done anything like this I’ve attached a screenshot of a form which has variable results I need some code that will change the WOClockStatus field from TRUE to FALSE Presume the...

I live in Lancashire, England and have been using Access for over 15 years, self taught and have wrote three different operating systems used by companies within the Engineering group I used to work for I am now retired but still work for one, when required, to modify/improve their system Access...