Search results for query: *

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

That is not a good idea. You could program all the light switches in your house to start playing the 7th symphony of beethoven (without providing any light), granted that's user specific but what about the light? If you want a possibility to jump to the next record at any time, either leave...

Whatever your purchase and sales forms/procedures, if you have transfers from one location to another, seems to me you cannnot get around a location ID. So this is where design/concept comes in. Basically, company has locations, locations have wickets. For the transition phase, you could have...

I came across the same problem, wanting to set relationships in the backend, which does not seem possible. On the other hand, you can set relationships in the frontend, even for linked tables. so at the end of the day...............

First of all, close all programs (even reboot) and relaunch msaccess (it can happen that you inadvertantly open another instance and thus will not have exclusive access). Second test, change your workgroup to the system default, can you access it now? Keep trying....................... cheers Riny

There are no shortcuts. The extravagance is mostly in the queries. Running down the queries that feed reports and forms is probably not an overburdensome excercise (surely not all that many). An idea is to replace each with the sql format. After that, change all query names to "whatever...