Replies

Thanks, Charlotte. Your recommendation gets me part of the way there. I placed a transparent button on the opening form and placed the code in the event procedure. I opened the database and clicked on the button. It did open the database window and highlighted the opening form, but since the opening form stayed open, the database window was frozen until I closed the opening form. So, I guess I will add a close form command on the button. That should take care of that part.

The other thing I really need to do is to completely disable the shift key so that it can’t be used to open the database window. Can that be done? Or, should that be done? I just don’t want anyone to be able to open the database window, period.

Hi, Adam. That worked perfectly. Thanks so much.

Hi, graeme. Thanks for your help. It has gotten me a long way, but I need a little more help.

This is your code that I revised slightly:

****************************************************
Sub CopyItems()

Dim CopyYes As Range

For Each CopyYes In Range(“I38:I200”)
If CopyYes.Value = “y” Then
CopyYes.EntireRow.Copy Destination:=Sheet2.Range(“A65536:J65536”).End(xlUp).Offset(1)

End If
Next

End Sub
*****************************************************

What I would like to do now is to copy and paste to the destination just the values that exist in the EntireRow. I can’t seem to find where in the CopyYes line to place a PasteSpecial xlValue thingy. It may be that the PasteSpecial goes on the next line. I don’t know. Anyway, I just need a little more nudge.

Thanks again.

Hi, OldDog. I read a Woody’s article in ZD dated in the year 2000. He said to do just what Dave said to do. In the folder column on the left side of Outlook, right click on the file you want to compact (my files is the Personal Folders file), click on Properties, click on Advanced, and you open a window with a few options.

Thanks for the feedback.

I give in. Thanks Charlotte. I didn’t see the problem with the C:drive table not being connected to the main tables.

I do have code to filter the database so that users only see their stuff. I think it will work well. I will look at the partial replica route, also. Again, thanks and thanks to Francois and willyboy.

Thanks for the front/back end explanation, willyboy. I still think what I want can be done, unless Charlotte says it can’t.

Thank you for the response. I am not going to give up, quite yet.

Yes, that is what I want to do. What I am trying to set up is to allow users to update their own records without letting them have access to other user’s records. I thought that if I had a MakeTable query make a table on their C: drive that only contained their records and then have the Record Source of a form that is on the network be set to their table on their C: drive, I could let them update only their records. I can’t figure out how to refer to the C: drive database. (In Paradox this would be easy to do ).

I don’t know if I have a front/back end. What I have is a database on the network that contains the tables and a database on the network that contains all the forms, etc., with links to the tables. I think this is called a split database. If I can’t do what I want (as explained above), I may have to push the database with the forms and links to their C: drive and go from there. I think that would actually be a front/back end arrangement.

Edited: What I need is to know is how to write the path in the Record Source to the database on the C:drive.

Peter, I did this in a form. On the date field, in Properties on the Data Tab, in the Order By box, I placed the name of the field with DESC at the end of the field name.

Example: dteLastUpdate DESC

This worked for me.

Howard, have you tried the Tools|Startup box? You may be able to over ride the student changes there. If not, why not create a splash screen (just an introduction form that opens when the Access application opens that could say “Hi, you are using Access”) and place the Call to the module that controls the toolbars. That way, Access would act like what you want.

Howard, I got this recommendation from somewhere. Probably this forum.

Create a module that contains the following:

Public Function WebToolBar()

DoCmd.ShowToolbar “Web”, acToolbarNo

End Function

Place a Call WebToolBar in the OnOpen event of your forms and the Web Tool Bar will not be visible. If you have a start up form for the database (a Switchboard), place the Call WebToolBar in that form.

You can also add other tool bars to this Public Function.

Maybe you need to place the fields that your Director keeps current in a separate table. You could then link this table to your tables that have to be updated and you wouldn’t over write the Director’s info.

BAM, Good articles. If you know Dian, you might let her know that Part 3 and Part 4 do not print out correctly, at least on my machine.

Roberta, I don’t think you need the If statement. In the OnClick event of each option button, just write in the DoCmd.OpenReport “ReportName”.

See if that works.

Good for you, Princess. What did you do to make it work?