Re: #Name? Error... trying to link two fields in same form



That's a fair enough solution.

Could have been a corruption. SaveAsText/LoadFromText could achieve the same
result, but your approach is as good as any.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Regnab" <p.heywood@xxxxxxxxx> wrote in message
news:1136268008.301651.325760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks for your response Allen. Tried both things you suggested and it
> still wouldn't work. It's hard to know for sure what the problem is -
> I'm actually fixing up a database for a fella that didn't use naming
> conventions etc so there could easily be some clashes that I'm not
> aware of.
>
> I ended up taking another copy of the original database and pasted my
> text boxes with code into the same form in his other database and it
> works fine. So while its certaintly not a pretty solution, it seems to
> work.....
>
> Thanks again - and I'll be happy to try other changes if you have any
> other ideas because I would like to know what the glitch was.
>
> Thanks again,
>
> Reg


.



Relevant Pages

  • Re: DB Front End is extremely large !
    ... SaveAsText/LoadFromText is undocumented, but the arguments are ... Allen Browne - Microsoft MVP. ... Create a new database. ... Set minimal References under Tools | References (from the code ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Debugger not breaking
    ... > delete the module, compact the database, and create the module again. ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... >> I have an mdb file that will not stop on any breakpoint that I place in ...
    (microsoft.public.access.modulesdaovba)
  • Re: Grouping Information in a Report
    ... > Access 2000 and later have a feature called Conditional Formatting, ... > and past the function below into a standard module (Modules tab of Database ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.reports)
  • Re: Relationship not showing up in relationship view
    ... you can then rebuild the ones you want: ... > database so the problem does not recur. ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Multiple Databases
    ... "Allen Browne" wrote in message ... > probably the wrong storage database. ... > compacted it is more than 1gb, then splitting it into multiple mdb files ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)

Loading