Dear Tobi, I checked it already but ... nothing Thanks anyway Best wishes Bill --- In AccessDevelopers@yahoogroups.com, "Tobi Hoffman" <[EMAIL PROTECTED]> wrote: > > It looks to me like you have a missing reference in the notebook. Check in > the Code window for Tools/References on that machine, and see if any > reference shows as "Missing". You may simply need to copy a file from the > desktop to the notebook; I've seen this at times, especially with the Format > function. > > Tobi > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of billkond > Sent: Monday, December 12, 2005 9:32 AM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] A very strange situation > > > Dear friends, > I deal with a very strange case. > I have a report, dependent on a union query. In that report I have a > text box with data source : =Format$([Item];"mmmm yy"). Item is a > “field” from union query that’s can be either a date or an > item. So, > if the value is an item, I get the name of the item & if the value is > a date I get the date like this: December 05. > Now, when I run my db from my desktop pc everything works ok. > But when I run it from my notebook, I cant put the above text box on > my report (asks me about Format$…) so I put just the > “field” from the > union query and I get the name of the item or the date like this: > 12/1/2005. > Nota bene that both of my machines (desktop & notebook) run WinXpPro & > MsAccess 2000. > I am really confused! > Any ideas? > Thanks in advance > Bill > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > SPONSORED LINKS > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Microsoft > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=M > icrosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ac > cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access developer > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+acce > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Micros > oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+access+ > programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi > crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc > ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access database > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi > crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc > ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access training > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micros > oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> access > training course Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Microso > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4 > =Microsoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ > access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> access programming > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ >
------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
