Search results

Have you tried using the label wizard to create the report? This should do what you require. HTH.

Yet another helpful comment, Mile:rolleyes: :)

Thank you for your replies - I always seem to forget about the Nz function.

Hopefully I'm posting in the right place. I need to create a report with a tricky calculation and I just can't figure out how to do it. Whatever I have tried doesn't seem to encounter all of the null values. Here is the scenario..... The report will be used to monitor how well a scheme went. I...

Thank you both. I don't suppose you could convert the example db to A97? Cheers.:)

I intend to set up a help system for my db, where users can press a help button on a particular form, and then a pdf document will appear with the relevant help file.I tried using the following code Private Sub Command1_Click() FollowHyperlink "c:\pdf\project1.pdf" End Sub and this works fine...

Cheers Fizzio, I'll have a go tomorrow. Currently sorting out 'dumb data' which I've just found in one of the other versions...:rolleyes: Users. You try to make their lives easier, and they make yours harder! Thanks again.

Any ideas? Anyone? You lot are a lot more knowledgeable than me!:)

Thanks for the prompt reply Fizz. I've been having this argument with ISG since March, when it was decided that other offices were to use my db. I wanted to have one large db that covered all areas North Kent, West and Mid, and then people at each office and at HQ could access my db. But the IS...

I apologise in advance if this has already been covered (did a quick search, but haven't found anything), and if I've explained my problem badly. For reasons known only to IS, I am not permitted to have my db on a central server where different offices can view their version of it. Therefore, I...

I apologise in advance if this has already been covered (did a quick search, but haven't found anything), and if I've explained my problem badly. For reasons known only to IS, I am not permitted to have my db on a central server where different offices can view their version of it. Therefore, I...

Set the field format to medium date. That way, the user types in 02/09/03 (or even just 2/9/03), but it appears on the form as 02-Sep-03. The field in your table can just be left as short date format, or whatever you want. The same goes for reports. I hope that's what you were after.

You need to type &&, not just &. That should do it.

Have you checked the columns in your listbox? If for instance you had the search results in the first column (column0), and the unique id in the second column (column1) then you would have a problem as the code you have posted refers to the bound column as column0. So if this is the case, it...

I have replied to your other thread on General, just in case you didn't see it.

I guess the easiest thing for you to do is to create a new table which just contains all of the table names you want to appear, then simply create a form based on this new table, put a combo box on it with the record source as the field name for the table names. Hope I haven't lost you... The...

I am guessing you are using a check box, rather than the words yes and no? I had a quick look at formatting the checkbox, but couldn't see any way of doing it.

In design view, click on your subform, look at the properties box, and you should see 'link child fields' and 'link master fields'. You'll see a little box with three dots in it (ellipsis?), click on it and a box will come up where you can choose which fields you want to link - your ID number. HTH.

Have you linked the child and master fields in the subform's properties with the ID number?

For example. If on your main form, the scheme type = A, then you want subformA to load, if scheme type = B, then you want subformB to load? Build all of the forms you want to use as your specific subforms (eg, subformA, subformB etc). Then place a subform control in your main form, calling it...