Search results

The only way I've found around this before is to loop through the string for each character and replace it, eg replace " with "", although you could also try replacing with StringBefore & Chr(ChrNo) & StrAfter.

Alternatively, you can set it so that the Report header and the Page header don't appear on the same page, so that the first page shows only the Report header and not the Page header, and the other pages show just the Page header as normal. To set this, get the Properties up for the entire...

You are correct that, unless you're working in Access 97 or earlier, you cannot develop the front end while other people are using it. Incidentally, queries can still be created and changed with other people in the front end.

I did email you but haven't received a reply. I'm about to disappear for the weekend I'm afraid. I can pick this up on Monday if you like, otherwise good luck putting it together, I hope you get it sorted.

Are your notes pages just text in labels/text boxes? If so, use text boxes (not labels), in the ControlSource type an equals sign, quote marks, then your text, then another set of quote marks. If any quote marks appear in your text, either change them to single quotes or for each set enter...

It looks like you can just match up the fields. It depends exactly how the child's details are stored in the table, but as long as you're going to have the SelectCriteria form open (or another form that has this data behind the scenes) and on the right record when you run the query, here's what...

I would suggest using another field, something like OptionWin, to record which option the candidate wins in. Then you can write a sub to run through all the candidates in whatever order you specify and assign them to the options by putting 1,2 or 3 in the OptionWin field. If you want to show...

Excellent, glad you've got it sorted :)

The built-in functions are only built in if Access knows where to find them, so you seem to be missing a reference. Open your database, then open any module. Go to Tools -> References. In my Access 97 I seem to have a default of three references ticked at the top. These are (in order)...

Sorry, should have said before, you need to replace the words Sheet1 with the name of your first sheet. I think you have a different name for your sheet, so it's asking where Sheet1 is. Alternatively, type in: =1+ without pressing enter, and then go to the sheet and click on the correct cell...

For a loop you need a Do While or Do Until, so try something like: Do Until Not IsNull(Me!Combo) And Me!Combo <> "" ... Loop or alternatively: Do While IsNull(Me!Combo) Or Me!Combo <> "" ... Loop If you just want to make your code react to the combos value though, you may find it...

I have also posted this answer in your thread on the Queries board. So to answer, yes you can do what you're asking. Choose the cell on the first sheet where you are going to enter the date. For my example, this is cell B2. On the second sheet, go on to the date cell and type: =1+'Sheet1'!B2...

Hi Pixie, I can answer your question, but you might have more luck in future if you post on the correct board; there is an Excel board on these forums. So to answer, yes you can do what you're asking. Choose the cell on the first sheet where you are going to enter the date. For my example...

OK, fair enough. I know if you're using SQL strings in VBA then you need the semi-colon or it won't run, so I've always assumed you need it in the queries themselves too (even thougth you don't need the masses of brackets), but you clearly know more about this than I do.

But don't forget to put a semi-colon (;) on the end!

I *think* you'd be OK with this, but to be honest you're in a better position to test it than me! Alternatively could you use just your one original subform, but apply a filter to it depending on what was chosen in the main form? Then I'm sure you'll have no problems with adding records.

One way would be to create a query that lists just students that HAVE got a Y next to them (for any course), eg: SELECT StudentName FROM StudentTable WHERE Passed = "Y" GROUP BY StudentName; Then you can use this query to find the remaining students, ie those without a single Y, either by...

For your two subforms, you need to limit the recordsource for each, so for one you would have something like: "SELECT * FROM YourTable WHERE ProductCode = 5;" and for the other you'd amend the 'where' clause, probably to "WHERE ProductCode <>5".

Also, the controls you are showing/hiding, do the need to be editable? I not, could you leave them visible, but change your recordsource so that in certain cases they show "N/A" instead of the field value?

It really depends what you're hoping to see... Could you make the form be a single-record-view form instead? Then you can set the visible properites in the OnCurrent event. Could you move the controls that change onto a second (single-record) form which is accessed from a button on your...