|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 18th, 2008, 08:20 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#Name?
Hello.
I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen 
|
|
#2
December 18th, 2008, 08:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name?
What is the name of the control?
"JB" somehow@somewhere wrote in message ... Hello. I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen
|
|
#3
December 18th, 2008, 09:00 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name?
Date
"M Skabialka" wrote in message ... What is the name of the control? "JB" somehow@somewhere wrote in message ... Hello. I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen
|
|
#4
December 18th, 2008, 09:06 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name?
WEIRD!! I've just opened the database on another computer, and no error on
the date control!!! am I going mad? Jen "JB" somehow@somewhere wrote in message ... Date "M Skabialka" wrote in message ... What is the name of the control? "JB" somehow@somewhere wrote in message ... Hello. I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen
|
|
#5
December 18th, 2008, 09:43 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name?
I'm not sure why it is working elsewhere - you should NEVER use a reserved
word as the name of a control. Date is a reserved word. Try renaming it to StartDate or whatever is suitable and see if that works. Mich "JB" somehow@somewhere wrote in message ... WEIRD!! I've just opened the database on another computer, and no error on the date control!!! am I going mad? Jen "JB" somehow@somewhere wrote in message ... Date "M Skabialka" wrote in message ... What is the name of the control? "JB" somehow@somewhere wrote in message ... Hello. I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen
|
|
#6
December 18th, 2008, 10:13 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name?
Ok will do Mich, thanks for the tip
Jen "M Skabialka" wrote in message ... I'm not sure why it is working elsewhere - you should NEVER use a reserved word as the name of a control. Date is a reserved word. Try renaming it to StartDate or whatever is suitable and see if that works. Mich "JB" somehow@somewhere wrote in message ... WEIRD!! I've just opened the database on another computer, and no error on the date control!!! am I going mad? Jen "JB" somehow@somewhere wrote in message ... Date "M Skabialka" wrote in message ... What is the name of the control? "JB" somehow@somewhere wrote in message ... Hello. I imported tables and forms from another database. All works ok except for one thing. There is a date control in a subform whose default value is set to Date() which should default to 'today', but show's the dreaded #NAME? I have compared the control on the other original form, and every other control property in the main form and the subform, I've compared the queries that are the sources and everything in VB but they are identical and so are the tables so I'm at a total loss. Please can anyone tell me what this could be. Thank you Jen
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
