Setting Default Value in Access Issues Tracking Database Template

[rwalery]

I have been playing around with trying to set a default value in the Assigned
To field in the Access Issue Tracking template. When I create a new issue, I
would like the Assigned To field to default to a certain contact's name (as
most tickets will be assigned to him).

I have tried mimicing the other fields in that form that have a default
value but I still can not get the Assigned To field to default to a value.

Any help would be appreciated. Thanks in advance.

 

[Beth Melton]

I'm not familiar with the database you are using but I suspect you need to
use the Contact ID that is assigned to the Contact you want to use as the
default, not the name.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[rwalery]

Thank you for the tip.

In the row source, is the following expression:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts ORDER BY Contacts.[Last Name];

I have tried modifying the expression and entering it in the Default Value
field of that ComboBox but my syntax (or maybe approach is wrong). My snytax
is:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts WHERE Contacts.ID = "6";

I am trying to display the first name and last name of Contact.ID 6 as the
default value when a new ticket is created. I am using the following
template from the Microsoft web site:

http://office.microsoft.com/en-us/templates/TC012186931033.aspx

Thanks.
Rick

 

[Beth Melton]

Did you try typing only a 6 in the Default Value? That's all you should need
to do.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Thank you for the tip.

In the row source, is the following expression:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts ORDER BY Contacts.[Last Name];

I have tried modifying the expression and entering it in the Default Value
field of that ComboBox but my syntax (or maybe approach is wrong). My
snytax
is:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts WHERE Contacts.ID = "6";

I am trying to display the first name and last name of Contact.ID 6 as the
default value when a new ticket is created. I am using the following
template from the Microsoft web site:

http://office.microsoft.com/en-us/templates/TC012186931033.aspx

Thanks.
Rick

I'm not familiar with the database you are using but I suspect you need
to
use the Contact ID that is assigned to the Contact you want to use as the
default, not the name.

 

[rwalery]

Oh, you are good.

That works like a charm. Thank you very much for your help.

Rick

Did you try typing only a 6 in the Default Value? That's all you should need
to do.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Thank you for the tip.

In the row source, is the following expression:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts ORDER BY Contacts.[Last Name];

I have tried modifying the expression and entering it in the Default Value
field of that ComboBox but my syntax (or maybe approach is wrong). My
snytax
is:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] AS
Expr1 FROM Contacts WHERE Contacts.ID = "6";

I am trying to display the first name and last name of Contact.ID 6 as the
default value when a new ticket is created. I am using the following
template from the Microsoft web site:

http://office.microsoft.com/en-us/templates/TC012186931033.aspx

Thanks.
Rick

I'm not familiar with the database you are using but I suspect you need
to
use the Contact ID that is assigned to the Contact you want to use as the
default, not the name.

 

[Beth Melton]

You're welcome.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Oh, you are good.

That works like a charm. Thank you very much for your help.

Rick

Did you try typing only a 6 in the Default Value? That's all you should
need
to do.

Thank you for the tip.

In the row source, is the following expression:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name]
AS
Expr1 FROM Contacts ORDER BY Contacts.[Last Name];

I have tried modifying the expression and entering it in the Default
Value
field of that ComboBox but my syntax (or maybe approach is wrong). My
snytax
is:

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name]
AS
Expr1 FROM Contacts WHERE Contacts.ID = "6";

I am trying to display the first name and last name of Contact.ID 6 as
the
default value when a new ticket is created. I am using the following
template from the Microsoft web site:

http://office.microsoft.com/en-us/templates/TC012186931033.aspx

Thanks.
Rick

:

I'm not familiar with the database you are using but I suspect you
need
to
use the Contact ID that is assigned to the Contact you want to use as
the
default, not the name.