Recent content by riny

Hello Pat B, Your first comment makes sense to me but does not give the presentation jawshark wanted, which is what the question was, so I just wanted to answer the exact question as a purely technical matter. You pointed out family members could have their own phone numbers, I might add that...

Sorry for double post, I corrected query3 regarding member4 Riny

I am assuming you want two alignments, one for the people, one for the telephone numbers. 1>Make query1 (input tables that join family table and members table on "Family ID"), output fields: [Family ID]: FamilyName: UCase([Family] & " " Member1: [First member] Member2...

I am assuming you want two alignments, one for the people, one for the telephone numbers. 1>Make query1 (input tables that join family table and members table on "Family ID"), output fields: [Family ID]: FamilyName: UCase([Family] & " " Member1: [First member] Member2...

Sorry if I'm being over simple, but you could also append it, do whatever, then delete it.

Sorry for being over simple, but just make sub queries that feed into a main query. Another thought is to reduce the field name sizes. Eg a field called "customer reference ID" could win space if it is changed to "C ID"

Hmm, just an idea: How about making your report an image. An image can be clip format so forced to fit in the allocated space. Riny

Andy thanks so much! It works beautifully, thank you so much! Note I had to move the Public Const SW_SHOW = 3 from declarations to the private sub (Const is not accepted in declarations). Fyg whilst waiting for someone to help I browsed many forums and found this one liner method...

I have a field with a file name in it, the file could be any type (.doc/.xls/.tif/.mp3). What I am trying to do is open it with the default software program (as it would double-clicking on it in windows explorer) with the "on double click" event. I tried this but doesn't work...

Don't know about access2, but the way I did it is as follows: 1) I have a table containing the location and name of the pics (I do this in vba according to the contents of a certain directory) 2) My records form contains an image control. 3) In the "On Current" event, I check if the...

Chr(34) is the quotation character. So you were on the right track !

Does anyone have some code to output data from msaccess into a outlook calendar. thanks for any help

I had a similar objective. See "Append data to a table from VBA" in this forum, it may guide you.

No problem if you launch the query from an event. Just add the DoCmd.Setwarnings before and after the query you launch like this: DoCmd.SetWarnings False DoCmd.OpenQuery "xxxxxxxxxxx" DoCmd.SetWarnings True hth

Do some testing. Replace your IsNull([Field]) query temporarily with: Msgbox [Field] to see what it says, then maybe you'll understand what's up hth