Search results
-
D
Refer to field value within text in a text box on a report
Hi Bob, I tried it in the on format event for the detail section of the report, but the error (3265 I think it was) - the same one as before keeps coming up, the code seems to do the splitting no problem, it must be something I'm doing with text box I'm referring to on the report as it says... -
D
Refer to field value within text in a text box on a report
Many thanks for that, I've put it in the on load section of the report but alas nothing happens - not even an error report for me to research. Any ideas as to what I might be doing wrong? Actually just noticed I've put curly brackets instead of square brackets for the bit referring to the... -
D
Update Query - uses selected record to make calculation and uses this to update all!
I should point out that I have no idea how to make it loop through the records, I've looked around on the net and found things about a loop being a code thing and SQL to do with queries and other things about integer tables, not really sure which if any is the direction I need to go to get the... -
D
Refer to field value within text in a text box on a report
Thank you for your reply, good to know it is possible but I think I may be messing up the method. I've created a table called ReplaceFields and titled a column ReplaceFieldTexts where I entered {ClientName}|[Text18]. I then went to the form opened a letter and in design view for the report, I... -
D
Refer to field value within text in a text box on a report
Does anyone know how to do this? I have a table which holds the text for letters in its fields. I have a form where the user can edit this text and add 'letters' (records). I then have a form where the user can select the 'letter' he/she wishes to use and on a report template have the letter... -
D
Update Query - uses selected record to make calculation and uses this to update all!
Thank you for your quick reply, I use Access 2007 but the programme I'm trying to create is in 2003 format. I am storing the results of the calculation in a field as I need to go on and use it later repeatedly at various points, I'm OK with it not updating the vales automatically, in fact I... -
D
Update Query - uses selected record to make calculation and uses this to update all!
Dear All, This is my first post and I hope someone will be able to help as I've searched as best I can and can't find the answer to my question in any existing post - though sometimes finding the right way to ask the question is all google needs to throw up the answer - so maybe the answer's...