Replies

I don’t have a problem giving the user permissions to a mapped drive – the problem is preventing others who use the same machine, logged on as the same person from gaining access to the mapped drive too.
What I need is for the mapped drive to become unavailable unless a password is entered for it – and without reducing the automatic disconnect time for a mapped drive for all other users of the server.

I’ve had a quick look at Truecrypt, but it seems that this will always encrypt the data. The folder is shared by others whose machines aren’t used by others, so I don’t really want to add truecrypt to their machines just so it works for one person – and I guess if the data is encrypted I HAVE to use truecrypt to unencrypt/decrypt(?)
John

The problem with this from what I can see is that the autodisconnect applies to everyone who connects to the server. If I shorten the time to 2 minutes for the person I really want to disconnect it affects everyone else in the same way.

I presume you mean that the person has to have 2 logins, the first, to login to the domain which DOESN’T have access to the shared drive I’m trying to protect and then a second which does have permissions to the folder – is this correct?

Edited by HansV to present data in table format.

I will have many more Groups/Tests in the proper spreadsheet.

Students are in groups, Red, Blue, Green and Yellow. Their group and names are listed in columns 1 & 2.
Students sit exams (test1, test2, test3 etc). The exam name is shown in the top row.
Against each student a mark (A, B, C or D) is entered in the column for the specific test.

I need to count the number of As, Bs, Cs and Ds (there may be more scores at a later date) and place the totals for each group at the end of the spreadsheet.
I tried COUNTIF and COUNTA, but I can find no way to force either to pays heed to the groups which each person is contained in.

Any suggestions? Example follows – I couldn’t shrink the file size to less than 100k, though there is very little in the spreadsheet;

Group	Name	Test1	Test2	Test3	Test4	Test5	Test6	Test7	Test8	Test9	Test10
Red	Adam		A	C							A
Red	Adrian				D	C			B		A
Green	David			D					A
Red	Amy			A			B
Red	Amelia			C			C			C	C
Blue	Bob		D		A	D			B		B
Blue	Brian
Red	Andrew	D	B							B
Yellow	Cheryl	B	B				D
Yellow	Christopher						A			D
Red	Amanda				D				A
Green	Davina					B
Green	Donna				B			B		D	A
Yellow	Carol			A	A		A	B

Group	As	Bs	Cs	Ds
Red
Blue
Yellow
Green

I sometimes wonder if you are looking over my shoulder waiting for me to press the “Post It” button to reply straight away!
Many thanks.

Many thanks Mark, I’ll have a look at the utilities later with another copy of the database.
John

Thanks Hans
I have a blank copy of the database, so I used that to check what each index should be and reapplied these to the “faulty” database. All the data now seems OK. Would it have been preferable to copy the data to a blank version, rather than fixing the original?
Any feelings about a cause for this type of problem?
John

Thanks Hans, I obviously didn’t look far enough back when I was searching for previous posts.

One thing I did find with your solution was that if I didn’t include the field containing “Page x of y in Report” then the ‘ctlGrpPages’ field wouldn’t display. I just made the “Page x of y in Report” invisible as I don’t need it, but I couldn’t find any reason why it wouldn’t work with this removed.

John

Make sure that PopUp for the Modal form is also set to NO – having it set to YES seems to ignore the Modal property and just continue running the code which is calling it

Sorry Hans – I’d added a few columns already so didn’t notice the extra column it had added.

I continued the form with 3 extra columns for which I added the same criteria (names changed). When I tried to run this, it would only work correctly if I had selected a product from the first list I’d set the combo box for. I checked the query and found that it had added a matrix of additional selections when I’d added the criteria for the 3 extra columns, but the product box wasn’t included in the bigger matrix. I removed all of the criteria and reapplied it to all 4 at once. This provided an even bigger matrix which then worked correctly. I’t all makes perfect sense once someone has shown you how!

Many thanks for you advice

Thanks Hans – that part is now working, though when i went back to look at the criteria it only had one line saying [Forms]![ViewComplaintsBySelection]![SelectProduct]

I’m now adding 3 other combo boxes, SelectCategory, SelectType and SelectComplaint

I want to be able to use these along with the SelectProduct combo to filter the records. Any of these may or may not be null – when null it shouldn’t filter anything, when not null it should be used as the filter. I tried just adding the same criteria, with the names changed, but obviously it requires more than this.

Any thoughts?

Excellent – many thanks. I did think it was something about the OnDirty function, but didn’t know what to use to do the record update.
Looking at the options available for RunCommand they seem to be the choices available via the Access menus – is this correct?
John

I would like the record to be updated when I move to either of the unbound fields.
When I update the unbound fields, they run queries to append new records to the table (these include a date and also look up the values of the previous day and if neccessary amend todays values. The problem is that if I didn’t move to another record before changing the date in the unbound field then the values I look up haven’t been modified, hence I need a method of forcing an update when I move from the detail section to the unbound fields.

Hans
Should it save even when I haven’t left the record? or should moving to the unbound fields in the form be enough to update the record?
John

Thanks Hans. Worked wonderfully.
Rather than now having to wrestle with the selection of the weeks as part of the selection query I can append the data and run it just on the subset i need. It’s cut the time to run the selection query from 13 minutes down to under 2 minutes as i had to include another table in the report to help calculate the current week.
Many thanks (again)