Search Result

I've seen many similar threads, but despite repeated efforts I cannot figure out my problem. I am running Access 2003, VB 6.5, Office XP Pro. Code excerpt is below (you can see where I've tried debugging myself). My problem is in the DLookup command.

UserName = Me.cboUserName. Value
Debug.Print "User Name is "; UserName
strPassword = DLookup("Passwo rd", "Employees" , "EmpName...

I am using DLOOKUP to bring up the value of VAT rate applicable in a particular date period. but it is not bringing expected values.
Can someone help me resolve the issue. Thx

I have a table: "tVATRate"
VATId RateDateStart RateDateEnd VATrate
1 01/12/2000 30/11/2008 17.5
2 01/12/2008 30/11/2009 15
3 01/12/2009 31/12/2099 16

In a form, I am using dlookup to find the VATRATE...

i have a form bound to a table, with a primary key(autonumber) "recordno"
on this form, i have a dlookup that looks up a specific "recordno".

how can i get this form to open up the record corresponding to the value that the dlookup outputs.

Foreign key from another table, and a primary key from the one being used.

i am still sort of a novice to access programming,

I have “tblMain” with a primary key “tracking number”
“tracking number” has a one to many with the table “tblPend”
“tblPend” has a primary key “RecordNo” and a status check box “status”

Status...

i have a form that is being designed to pend requests in a requests database.
the pend form is opened from an update form used by an employee to enter updates. when the pend form is updated, the tracking number of the current request is imported to the pend form, and query results are displayed at the bottom(all previous pending records for the imported tracking number)

the pend button saves either the start pending date or...

I have a field that retrieves information from an expression in a
query. I have used a DLookup function to get the calculated field
from the query. However, the relationship is 1-to-many so one site
could have many units. How do I have the DLookUp field value change
to a newly calcuated field when I navigate through the units? please
see example below:

On the Form:
A site can have many units....