Switchboard

[Matt Reed]

Hello, I'm fairly new to Access and am trying to work on some else's
project.
Most of the tables, queries and forms are already setup. I am trying to add
a Switchboard to make it a little more user friendly.

Now I have a Switchboard that opens with several buttons all working fine.
How can I add a textbox that shows the date of the last entry?
Also it would be helpful to have a different textbox showing the index
number of the last record?

When I and a textbox and set the source record to
=DMax("Date-","ReportingDate") I get #Error every time I open the form.

Thanks for any and all help.

Matt

 

[Elwin]

According to your example below, you've violated a golden
rule in field naming. "Date-" is a field name that we
only see in our nightmares. 'Date' is a reserved word
because it is a function name that returns the day, month,
and year of a given date value. '-' is the mathmatical
operational symbol indicating subtraction. My first
suggestion would be to change the field name to something
more unique. If you can't do that then you must always
remember to enclose the name in brackets so Access knows
your referring to a field name.

eg) =DMax("[Date-]","ReportingDate")

/lecture off

Good luck!

 

[fredg]

Great post.
You forgot to add...
Make sure the name of this control is not 'Date" or "Date-", or
"ReportingDate".
--
Fred

According to your example below, you've violated a golden
rule in field naming. "Date-" is a field name that we
only see in our nightmares. 'Date' is a reserved word
because it is a function name that returns the day, month,
and year of a given date value. '-' is the mathmatical
operational symbol indicating subtraction. My first
suggestion would be to change the field name to something
more unique. If you can't do that then you must always
remember to enclose the name in brackets so Access knows
your referring to a field name.

eg) =DMax("[Date-]","ReportingDate")

/lecture off

Good luck!

-----Original Message-----
Hello, I'm fairly new to Access and am trying to work on some else's
project.
Most of the tables, queries and forms are already setup. I am trying to add
a Switchboard to make it a little more user friendly.

Now I have a Switchboard that opens with several buttons all working fine.
How can I add a textbox that shows the date of the last entry?
Also it would be helpful to have a different textbox showing the index
number of the last record?

When I and a textbox and set the source record to
=DMax("Date-","ReportingDate") I get #Error every time I open the form.

Thanks for any and all help.

Matt



.