UtterAccess.com
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    
 
   
Jonny43wakey@sky...
post Jun 30 2020, 05:00 AM
Post#1



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?

Thanks

Jonny


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
 
theDBguy
post Jun 30 2020, 09:43 AM
Post#2


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


Hi Jonny.

Welcome to UtterAccess!
welcome2UA.gif

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