X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> #name? Error, Access 2010    
post Jun 30 2020, 05:00 AM

Posts: 13
Joined: 8-June 20

Hi i hope someone can help as i have hit a problem in my MS Access Database form

As you can see on the attached image i have developed a form which simulates a Gantt Chart, each textbox which should colour black according to its SQL has been working until row 8, week 13.

The Chart has a reference date in [Text1159] and uses this to identify the start week number for the chart, each texbox refers to this; however even though each textbox has worked until now it appears there is a conflict but the only value in the textbox SQL which changes is the reference to the previous week numbers textbox

SQL in each textbox is shown at the bottom of Gantt3 image

Any ideas on why i am now getting the #Name? error?



Attached File(s)
Attached File  Gantt2.JPG ( 109.67K )Number of downloads: 7
Attached File  Gantt3.JPG ( 173.78K )Number of downloads: 10
Go to the top of the page
post Jun 30 2020, 09:43 AM

UA Moderator
Posts: 78,438
Joined: 19-June 07
From: SunnySandyEggo

Hi Jonny.

Welcome to UtterAccess!

Just curious, is this related to this other thread?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    2nd July 2020 - 10:29 AM