Search results

The code is in the CLICK event yes. I get a 'compile error' now with the Risk_ID inside the brackets highlighted.

I'm trying to make this work through a list box in a form, with the code in the 'on click' section: Private Sub Combo3_Click() DoCmd.OpenReport "rpt_risktype", , , "Risk_ID = " & Me.Risk_ID End Sub

Yes. I'm sat puzzling over this and trying that single line of code where I think it ought to be but am still getting the error. As I say, I'm probably making very basic mistakes. I'm trying to educate myself here as well, so would like to understand why things work and don't work.

Sorry, it's a number. I didn't realise a primary key could be anything but a number, every day's a school day :)

DoCmd.OpenReport "rpt_risktype", , , "Risk_ID = '" & Me.Risk_ID & "'" Same error. I'm beginning to suspect I'm misunderstanding something embarrassingly basic...

Risk_ID is the primary key field name. I will try what you suggest, thanks

I would really like to crack this because I'm doing COSHH reports in the same way and I really need to print those one at a time. Am I doing things the right way by recording them all in one table?

Yes, Risk_ID is the primary key so each one is one row of data in the table. It errors at the moment with 'the expression may not result in...'

DoCmd.OpenReport "rpt_risktype", , , "Risk = '" & Me.Risk & "'" Ok. This is way over my head but I'm trying to understand. I've read and re-read the link and the example posted ( thanks for both ) and came up with the above. The report name is correct, 'Risk' refers to the identifying...

Ok. So I can run the report from a form; I can see that now. But, what I'm getting is a report that has all the data in the table in it, so if I have 5 'Risk Types' they all display in the report. What I would like to do is select one Risk Type and have that display in a report so that I can...

Ok. So the form can open a report that will display the one set of data? I never thought of looking at it that way. I will give it a try and report back, thanks.

Hi guys. Probably dumb question time again so apologies in advance if that's the case. I'm building a risk assessment database and it's going quite well, but I'm struggling to get the reporting to work the way I want. I have a form that adds data to my table: frm_risktype & tbl_risktype. What...

I will give that a go, thanks.

I have a stock control database and am starting to want to tweak it a little. We often work in dozens and have always rounded up or rounded down so that our closing stock will go to one decimal place, 23 would be entered as 2.0 while 22 would be 1.9 What I would like to be able to do is...

Hi guys, I wonder if some of you clever folk could help me out again? I have a stock control database that I'm very happy with. When I need to set up a new site, I just copy the database and re-name it. All the databases sit together in a single folder called 'Stocks'. What I want to do now...

I can't answer this from a database point of view because I'm not a database genius. From an understanding what you are getting at point of view though I can help. I wrote a stock control database specifically for bar and food stocktaking within pubs and restaurants. I will PM you some...

This hasn't done the trick. It shouldn't be the size of the number , they are just not that big.

Brilliant. I will give it a whirl and report back.

Bit of an odd problem, but I'm hoping someone has the answer. I've converted my 2000 / 2003 DB into 2007 so that I can use the developer tools and create a package. Before it's packaged, all the numbers and reports appear as they should, but when I create and install the package a couple of my...

Brilliant, thanks.