Recent content by RobSindle

Don't know if there is a permission that allows R/W but not delete, but if so, that would be something to try. I'd recommend a book by Garry Robinson. Title is "Real World Microsoft Access Database Protection and Security" Rob

No that's not what I was looking for. I was looking for basing the recordsource for the whole form on a value in a text box or combo box. Its interesting though, that the recordsource for the combo box can reference the form directly (Me.cboComboBoxName), but the code under the recordsource...

Forget the second half of my last post... I was changing the recordsource after the fact. When I put in dam I only get the exact match (if any) that you would expect. Rob

I got the answer from another post. I was not putting anything in the "Input Parameters" property for the form. Once I did that it worked fine as is. Thanks. Rob

Thanks, I tried option 1, above. The missing piece was the "input parameters" property. I wasn't aware of it. I put in Forms!frmProjects!txtProject in it and it worked as expected. Now, here's the weird part. I tried a new sp from scratch. It is: ALTER PROCEDURE dbo.spProjectsList...

Changing the * to % was the first thing I did. No difference. I am not CALLING the function per se. It is the recordsource behind my form.

I have developed Access front-ends (forever) for Access backends and also for SQL backends via ODBC. This is my first attempt to work with an ADP. I'm having trouble with the syntax for something that I do often in Access front-ends, i.e., base a form off of a query that references a control box...

I have developed Access front-ends (forever) for Access backends and also for SQL backends via ODBC. This is my first attempt to work with an ADP. I'm having trouble with the syntax for something that I do often in Access front-ends, i.e., base a form off of a query that references a control box...

From my earlier: You can always brute force it by creating an empty, identical table, and inserting all records (and all fields OTHER THAN THE Autonumber field) ordered by the autonumber. That will resequence. Rob

I agree with PHV, but I do use the autonumber as a means of only determining order of input, no real meaning. In which case, it doesn't matter that there are big gaps. However, to answer to your question. It looks as if you ran some insert queries that failed and were "rolled back." When this...

Yes, you can do it, but can get quite painful. What I have done in the past is create a query for each table that translates old (bad format) names into new (good format) names. Then reference only the queries in my new code/forms/queries. In query designer for field 'due date' just put in...

Essentially, yes. But you CAN set the permissions separately, if you want. For instance, if you permissions for a group on a table (link) in the front-end to Administer and set the permissions on the table itself (in the backe-end) to Read-only, then anyone from that group accessing through the...

What I do when I split a secured database is essentially copy it (via the file system), calling one MyApp.mdb and the other MyData.mdb. Open the Mydata.mdb (while logged into your secured workgroup) and delete all forms/reports/queries/(most) modules. Open the Myapp.mdb and blow away the...

If you HAVE to share a front-end (I ran across this too, and had to share some temporary tables). I just added a username column to each table and most of my stuff worked with minor modifications. I just filtered on the username. However, I have HEARD that even with Citrix it MAY BE better...

Not sure, I'd never done an ad-hoc relationship between 2 tables via mfrm / sfrm. Rob