Search results

Many thanks Bob !

I am creating a field in a report query where I wish to form the string result to appear as several lines in a report field. eg. multiline: ([field1]&Chr(10)&[field2]) I just get a square block character showing in the report field. Is it possible to do this ?? (Reason for the expression is...

There are hundreds of replies and a number of on going surveys, so at a minimum there would be a survey table and a results table.

The Doc Man - thank you for coming back with these ideas - for now I'm just going to let the user both set the flags and also choose from standard text wordings that they can 'decode'. I'm sure it could be done along the lines that you suggest, but it's a tiny part of the system. My main focus...

Thanks Pat, it seems passing the pk is the only way.

Rabbie - thanks, but this is not the problem I have - I just would like to access columns in a VB Module function, when called from a db query.

Doc Man - in terms of design the thirty flags don't violate any basic principles, think of them as a list of specific abilities - such as 'likes to swim' 'likes to ride' 'likes to jog' etc. and the descriptive text might result in 'Active Leisure Sports Enthusiast'. But hey - your comments...

Adam - the flags are indeed yes/no fields and the table is simply 'contact' information, however the contact has a series of attributes (one per flag) and this text would describe these attributes in a standard way. The volume of data is not great (under 1000) and so i'm not worried about...

thanks, I can do all this in one place for now - so reasonably neat and not difficult.

thanks for the suggestions RG - I may well end up 'decoding' when added or changed for the moment as it's a horrible thought to be passing so many flags !

Good point - yes, and that was considered but (so far !) rejected for other reasons. So are you saying that it is not possible to 'pass' a whole query row down to a user function ? I would have thought there would have been an Access object of some sort that would be around at this point.

Thanks RG but this query is invoked when filling a combo box - also this 'translation' of flags into descriptive text will be needed in other queries. I am keen to set up a function that can be used in any query and by non technical report writers.

I have a lot of query fields that I need to compare in a function that I call as part of an expression in a db query column. I am wondering if it is possible to pass the entire row to the vb function (or can it somehow be accessed) ? This is what i'd like to do (if this was the right...

The way to do it seems to be in the query using a column expression entered into the query builder instead of a table field name, for example: Expr1: IIf([is_dept_head],"Department Head",IIf([is_section_head],"Section Head",.......and so on) ) and of course you need all the 'tested' flag...

Depending on flags in each incoming database row I'd like to be able to assemble descriptive text alongside other columns taken directly from the database row. Is it possible to intercept the assembly of each listbox row, and insert the descriptive text ? "Department Head" | Joe Ninety |...

Thank you, thank you ! Now working like a dream.

Many thanks - that now works fine when opening the form at the starting out page of the sheet, but even with default set for the combo's on the other pages - when you click on the page tab - the combo box values start out null until dropped and selected from !

I have four pages on a tab sheet, each page has its own combo box that has its own rowsource query. When I open the form each page's combo box value is 'null' until I make a selection. How do I get each combo box to show 'the first' row in its box, ie have the first row as its value ? I've...

Many thanks Bob - this is now working fine and I can move on ! Private Sub Form_BeforeUpdate(Cancel As Integer) MsgBox "Before Update the selection is: " & Me.Combo69.Column(1) End Sub

My first post, and hopefully a useful one ! I have a combo-box (Combo50) in my form that has its own RowSource query. [Combo50].Value correctly gives me '2' which is the record id of my selection, but I want to pick up the text of the field that's shown which is 'Prospect'. Can I simply...