Search results

I have attached my access data base for you to see., how do you add an action query

I have attached my access data base if that helps

How do you do that

Same error message

' strSql = "Delete * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate strSql = "Select * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate MsgBox " strSql=" & strSql DoCmd.RunSQL...

Sorry, Column 1 contains The Id field

Form is spelled correctly. form will be opened when running query.

gives a box to enter the from date and the to date

gives error massage The expression you entered has an invalid .(Dot) or ! operator on invalid parentheses

Getting this error massage in a criteria field in a query Between[[Forms]![frmSelected_Statistics]![(CDate lst_From_Date.Column(1))] And [Forms]![frmSelected_Statistics]![(CDate lst_To_Date.Column(1))]

Changed my keyboard and it works

tried it again and it did not work

tried it again, hold down the shift key and it worked ot work

Thanks but did not work

Thanks but did not work

trying to split a database get this error message the data base engine could not lock table 'tlbblood pressures' because it is already in use. I am using a stand alone computer. nothing is open in access

Sorry, Did not need it.

Can you give some code

Gives a Compile error Expected: identifier