Search results for query: *

Thanks Lee, What would be the best way to avoid this and to allow different permissions?

We have a database that is on a server with four users two users have read/write/update permission and the other two have only read permission to it. Depending who accesses the DB first all other users get the "The database 'xxx' is read-only" message. Anyone have any ideas why? Any help...

Trendsetter, That's extactly what I needed; Thank you very much

Trendsetter, Thanks this is what I'm looking for the only thing is all my request records load into my form I just need the one I Double_Click on any suggests. Thanks Ez.

I have a database with requests from customers. When a new request is needed I have it that you view the customers make sure they are in the table in form (Schcustomer) from that point you select which customer the request is for by clicking a button next to record that brings up all information...

Vic, The string appears at the beginning. Thanks, Ez

VicM - I tried it like your example before and had no-luck. Mstrmage1768 – I know to use the exact match, but if I don’t pass a parm I would like to see all the records in that range.

Could someone help me on using the “Like” expression against a text field that contains Roman Numerals (I, II, III, & IV)? When I use the “Like” expression for example (I) it selects all records and that’s because it does match the other numbers. But I would like to run this query if this field...

Beeps, Works great just what I was looking for thanks.

Beeps, I want to try you suggestion, where do I put this bit of code? Thanks

Craftsman61, I looked into using calendar control but I liked the idea of the drop down box instead of showing the calendar on the form. And I double-checked the date format of my table and date picker and both are short date. Thanks again for your input.

Okay, Till tomorrow, thanks a bunch.

I tried it without the "like or wildcard" and still no success. Any other thoughts? Thanks

Craftsman61, thanks for your respond I tried that and I can not get it to work. This is what I put for my criteria Like [Forms]![form1]![ActiveXCtl0] & '*'. Do you see anything wrong.

Could someone help me use the “ActiveX Datepicker” to pass date to a query to select records based on the date selected? Thanks in advance.

Thanks, I tried that and it doesn’t work for men when I open the form the textbox has (#name) in it.

Could someone help me on setting a default value on an unbound textbox? Thanks in advance.

Thanks for all your help it works great just what I needed..........

I added the line of code debug...... I hope this is what your looking for "SELECT * FROM tAccount; "

Hi allanon, one more error - Run time error '3131': Syntax error in From clause. when i select Debug line with - qry.SQL = strSQL & strWhere is highlighted. thanks again for your help...............