🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #548

Re: #NAME? on bound controls with gotorecord acnewrec

#548
From: Karl Donaubauer
Date: Fri, 15 Dec 2000 15:48
27 lines
2479 bytes
Bj�rn Fabritius wrote:
> I got a problem with a form:
> when I open the form I use the DoCmd.GotoRecord ,,acnewrec - method in my
> Load-Event to show an empty dataset.
> No problem, would you suppose, but somehow all values in bound controls
> change to #NAME?. And: I can't edit them.
> All recent records of the sourcetable are shown without problem. i.e. I can
> switch through the records using the navi-buttons.
>
> Even stranger is, that this effect only occurs on one single computer. All
> computers refer to the same database (linked tables) and all use Access
> 2000.
>
> What the @%*# can cause such a strange behaviour ???

Do you use Default Values in the controls/fields?
Maybe by using any functions in expressions?
Then it could be bug #1 = references.
http://www.mvps.org/access/bugs/bugs0001.htm

Check the references anyhow.

--
HTH
Karl
*********
Access-FAQ (German): http://www.donkarl.com
Technical Details
Message-ID: <q3r_5.25423$oO6.1334847@news.chello.at>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!nmaster.kpnqwest.net!blackbush.xlink.net!newsfeed01.sul.t-online.de!t-online.de!newsrouter.chello.at!news.chello.at!not-for-mail
References: <976892859.215423@www2.ExperTeam.de>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff0ac,865f85faad15ea01
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 101bdd,865f85faad15ea01
X-Google-Attributes: gid101bdd,public
X-Google-Thread: fe218,865f85faad15ea01
X-Google-Attributes: gidfe218,public
X-Google-Thread: 1163bd,865f85faad15ea01
X-Google-Attributes: gid1163bd,public
X-Google-Thread: 10f31b,865f85faad15ea01
X-Google-Attributes: gid10f31b,public
X-Google-ArrivalTime: 2000-12-15 07:48:40 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!nmaster.kpnqwest.net!blackbush.xlink.net!newsfeed01.sul.t-online.de!t-online.de!newsrouter.chello.at!news.chello.at!not-for-mail
From: "Karl Donaubauer" <admin@donkarl.com>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.formsprogramming
References: <976892859.215423@www2.ExperTeam.de>
Subject: Re: #NAME? on bound controls with gotorecord acnewrec
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <q3r_5.25423$oO6.1334847@news.chello.at>
Date: Fri, 15 Dec 2000 15:48:38 GMT
NNTP-Posting-Host: 212.186.147.250
X-Complaints-To: abuse@news.chello.at
X-Trace: news.chello.at 976895318 212.186.147.250 (Fri, 15 Dec 2000 16:48:38 MET)
NNTP-Posting-Date: Fri, 15 Dec 2000 16:48:38 MET
Organization: Customers chello Austria