Issue with Dlookup- Help Please! (1 Viewer)

[eocean234]

Hi I am new to access and trying to include a Dlookup in my coursework but I can't seem to get it working, I keep getting #Error. Its just to lookup a value in a table. Any help appreciated!

 

[plog]

Only use alphanumeric characters and underscores in names. When you put spaces in them (Exam ID), it makes you need an additional step when working with them. That step is surrounding the name in brackets. So put brackets around Exam ID in the Dlookup ([Exam ID]). Or better yet, fix all your names to comply with the rule above.

 

[eocean234]

Only use alphanumeric characters and underscores in names. When you put spaces in them (Exam ID), it makes you need an additional step when working with them. That step is surrounding the name in brackets. So put brackets around Exam ID in the Dlookup ([Exam ID]). Or better yet, fix all your names to comply with the rule above.

Hi thank you for the help but I am still a bit confused, I've tried and will insert below. I am still getting an error.

 

[plog]

Are your ExamID's text? Is 'Trinity' a value in ExamID? You need to treat text differently than numbers when you build the DLookup. You need to surround the value from the form in single quotes like so:

=Dlookup("Grade", "TblExam", "ExamID='" & Combo25 & "'")

 

[LarryE]

That DLookup does not have a clue what Combo25 is. So:
=DLookUp("Grade","TblExam","[ExamID]=Forms![FORM NAME]![Combo25]")

 

[June7]

Why use DLookup()? Is this required for the exercise?

Embedding full path in the criteria will work, until you decided to use form as a subform and then the path is no longer correct and gets more complex.

Also, domain aggregate functions can slow performance with large datasets.

Include Grade in the combobox RowSource then reference that column by its index. If Grade is in third column, its index is 2: =Combo25.Column(2)

Don't use spaces nor special characters in naming convention, nor reserved words as names. Also, give controls more meaningful names.

 

[mike60smart]

Hi I am new to access and trying to include a Dlookup in my coursework but I can't seem to get it working, I keep getting #Error. Its just to lookup a value in a table. Any help appreciated!

Why is the Combobox Unbound ?

Normally the table would have a field named GradeID - Number datatype.

Then you would have a separate table that lists all of the Grades.

On your form you would create a Combobox and you would lookup the value you want from the Grades Table.

 

[Gasman]

Why is the Combobox Unbound ?

Normally the table would have a field named GradeID - Number datatype.

Then you would have a separate table that lists all of the Grades.

On your form you would create a Combobox and you would lookup the value you want from the Grades Table.

Search form?

 

[eocean234]

That DLookup does not have a clue what Combo25 is. So:
=DLookUp("Grade","TblExam","[ExamID]=Forms![FORM NAME]![Combo25]")

I have tried this and the error message is gone but it appears blank

 

[arnelgp]

=DLookUp("Grade","TblExam","[ExamID]=" & Nz([Combo25], 0))

 

[eocean234]

I have tried this and the error message is gone but it appears blank

I’ve tried this again and it’s worked!!! Thank you so much !!!

 

[eocean234]

Got it working now, thank everyone for helping !

 

[June7]

Did you read post #6? Any response?

 

[eocean234]

Hi back again, unfortunately I had to delete the table as I didn’t think I’d need it but now I do. So I’ve remade the table and form and now the dllook up only works when you try it once. Any help appreciated)

 

[June7]

Ask again, did you read post #6?

 

[eocean234]

Ask again, did you read post #6?

My teacher used this in his example, I don’t know much about it to be honest I’ve tried adding the column and it resulted in #Error

 

[June7]

Can you provide db for analysis?
Follow instructions at bottom of my post.

 

[eocean234]

Hi, I have it working now the problem was I had the combo box finding the values from another table or query instead of record on my form
I am now having problems with my DCount (sorry for being such a hassle) I wanted it to count the number of lessons that the member on my form is in but I am getting #Error. If anyone has any suggestions

 

[Gasman]

You have your parameters backwards, if I read your prefixes correctly.
Lookup the syntax.

 

[MajP]

Yes you have it backwards with the table name first
should always count "*" not a field name

dcount("*","table or queryName",Criteria)