Alaska Cowboy
asked on
adding a non-d.b. value to a list view in an Access form
I have a simple form, "Positions" for hiring, it's a simple list of open positions.
I want to have a field that displays "number of candidates being considered", but this isn't working out.
I was able to create a query that shows the count, but when putting this as the recordsource for the form, then I can't create new records.
So the data should look like this
Position Department Num of Candidates
Mktg Director Mktg 3
Sales Director Sales 2
What's the approach for this ?
I have a query with the number but not sure how to implement.
I want to have a field that displays "number of candidates being considered", but this isn't working out.
I was able to create a query that shows the count, but when putting this as the recordsource for the form, then I can't create new records.
So the data should look like this
Position Department Num of Candidates
Mktg Director Mktg 3
Sales Director Sales 2
What's the approach for this ?
I have a query with the number but not sure how to implement.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wouldn't the other way of doing be an unbound form ? Just wondering, I wouldn't attempt to do that, just getting started with Access 2010, I was half decent on Access 2000 about 4 years ago but really rusty now, plus using Access 2010 for the first time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, thank you. but I think I'll have to get some more of the basics down and kind of need to go with the hint tip for now, can you help with that.
do you do all your forms unbound ?
do you do all your forms unbound ?
Yep unbound forms reduce data corruption issues that could result from having a bound form sending data across a network.
Everything you need to know about ToolTips is here: http://support.microsoft.com/default.aspx?scid=kb;en-us;119991
Best regards,
MV
Everything you need to know about ToolTips is here: http://support.microsoft.com/default.aspx?scid=kb;en-us;119991
Best regards,
MV
ASKER
MV, ok, thanks. still beyond my skill level and time constraints.
can you help me with this ?
dim numCandidates as Integer
sql = "select count(*) from position_candidates where position_id = " & Me.PositionId
[run query]
numCandidates = sqlrResult
Me.PositionDescr.HintTip = numCandidates & " candidates for this position
can you help me with this ?
dim numCandidates as Integer
sql = "select count(*) from position_candidates where position_id = " & Me.PositionId
[run query]
numCandidates = sqlrResult
Me.PositionDescr.HintTip = numCandidates & " candidates for this position
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent ! Thank you.
ASKER
lot of work to do custom tooltips., will have to put on back burner.
ASKER
I would try
dim numCandidates
sql = "select count(*) from position_candidates where position_id = " & Me.PositionId
[run query]
numCandidates = sqlrResult
Me.PositionDescr.HintTip = numCandidates & " candidates for this position