Recent content by El Rebelde

I am recording financial transactions for several different people in a table with the following fields: AwardID (AutoNumber URN) AwardDate AwardTime RecipientID (Reference to recipient's personnel record) DispenserID (Reference to dispenser's personnel record) AwardCatID (Reference to...

Thanks Brian I simply created another column of 0cm width in my list box to hold a calculated field "Format([Recorddate],"mm/dd/yy"). That did the trick! Stuart

I need to select multiple records from a listbox which is designed to look like a datasheet. I will use the selected records to select records with matching dates in another recordset. A sample selection results in the following SQL statement, as seen the immediate window: SELECT * FROM...

Well, I've managed to achieve my aims by calling a new form from a button on the Response entry form. This Update form opens with the current CommentURN from the Response form entered as a default value and has an unbound list box from which I choose the Status. The on-click property of the...

Well, I have the database, the forms to enter the data and the reports to publish it. What I need to know is; having received a response, selected the specific Comment to which it relates and stored the data in a new Response record (created with a form), how to update the Comment record with a...

My database is designed to record Comments made by auditors and Responses to them made by the managers of the units that have been inspected. My process is: Create an Inspection record Record the inspectors' Comments Print a Report of the inspection Await responses by email, text or voice call...

So, that means that some people who answered "Yes" to question 44 did not do so for question 43.

My mother always criticised me for never knowing when to stop. Here's a script to insert a conditional tab, as wel as a conditional CRLF. =IIf([Orgtel]>"0","Switchboard" & Chr(9) & [orgtel],"")&iif([Orgfax]>"0", chr(13)&chr(10)&"Fax"&chr(9)&[Orgfax],"") This would create a really impressive...

sum(Iif[q44]="yes",1,0))/sum(Iif[q43]="yes",1,0))

That fixed it. Thanks RG! Stuart

Thanks Gemma, but the problem exists throughout the database; the function is not recognised in queries either. I'm sure there are ways round the problem, but it worries me more because other functions may compromised in a similar way. vbcrlf is not recognised by the problem database or those...

I have a database in which I am designing a report which includes a name/address block. I am surprised to find that the report does not recognise the Chr() function in the text box control source string "=[Organisation] & Chr(13) & Chr(10) & [Address]..."; designed to insert a CRLF between the...