Yes this was homework.....

When tried to solve problem I determined the relationship between Employee and Benefits is many to many but I cant determine the bridge class. I mean what...

well its working right now. there is no problems with the database.

I found the solution yesterday. thank you for your help. here is the query

SELECT [Austin Police Department].Name, [Austin Police Department].Location, [Austin Police Department].[Phone Number], [Austin Police Department].District, [Austin Police Department].[Position...

The list box is retrieving the data from the query. Right now the list box shows every district(1,2,3,4). I want the list box to show district 1 only. In other...

BUT I dont want district 2,3,4 to show up in list box before I search. When I search it only shows district 1.

thank you everyone

thank you very much. It works now.

I tried to use something simlar to that.

SELECT DMax("[AssetNumber]","Waste Hauler Number","+1") AS Expr1 FROM [Waste Hauler Number];

I am getting two 4001. What I am doing incorrectly? I have 4000 and 4001

I made myself confused and you. I need more coffee. I thought you were referrring to another field.

Right now my problem is how do I validate against another table? How...

Basically what I am doing is I am parsing 0000-V/C 0000-AT-YR and then putting each section into its field in a table. I need to know how I can determine...

Actually my autonumber starts at 1000. You are right. How do I automatically assign random numbers for a 4 or 5 digit number? How do I determine if I have...

I would like to this in...

This is the solution.

Private Sub Command45_Click()

Dim db As DAO.Database

Dim rst As DAO.Recordset

Dim varTextData As String

Dim varTextData2 As String

Dim varTextData3 As String

Dim varTextData4 As String

Dim varTextData5 As String

Dim varTextData6 As String

Dim...

I know how do this. I need to change Primery Key in the table to autonumber.

thank you very much.

I think the problem is related to BoundColumn Property

http://office.microsoft.com/en-us/access-help/boundcolumn-property-HA001232723.aspx

let me see what I can do