Replies

You are right, you don’t need login script to map drives, you could map it by hand, unfortunately, our users are blind and it is generally easier for us to use login script to map appropriate drives to their computers without user intervention.

Also, we map specific drives depending on their membership in security groups.

Brent

Guys, I just wanted to let you know that I resolved the problem by upgrading our Kixtart program and it did the trick…

Thanks for your help and advice. I really appreciate it.

That’s the kicker. I did exactly that and it still disappears next time she logs in, when I choose “Disconnect a drive” option OR try to map it again, I actually see the drive already mapped, but it simply refuses to show up as a drive. HOWEVER, when I log in as myself, it promptly shows up as a drive mapped to my personal folder! She is the only user that has this problem when logging into ANY XP machine.

This was done through her own profile as well. The User profile I was talking about, is the user account located on our PDC.

A: Floppy
C: Hard Disk Drive
D: CD-ROM

Nothing in Autoexec and Config. They are blank.

What is so puzzling about this situation is that when I log in as myself on the “problem” computer, it goes ahead and map the F: to my personal folder just as it is supposed to work. When the user tries this on other computers, it doesn’t map at all either. I am sure it is an user profile problem. I even deleted the profile and set up a new one. Any ideas?

The computer didn’t have basicws.inf file. However, I found those:

compatws.inf
hisecws.inf
hisecdc.inf
rootsec.inf
securedc.inf
securews.inf

Which one should I use? I tried securews.inf and still noticed no changes.

FINALLY LICKED it! Actually, it was a “mish-mash” of solutions from all involved.

Credits:

John H. – Thanks for the help on using query to pull all data together then using the Form Wizard to create the form. I decided to check out “linked tables” instead of using datasheets and it actually came even closer to what I needed and it set up VBA code that solved 75% of my problem (It set up filter).

Tom – Thanks for the code! I borrowed one line from you (Redefining the Row Source property) and it worked wonders!

Again, THANKS A MILLION to you both.

I am not too sure what you mean by subformControlname.Form?

Should I type: forms!frmA!fsubA!cboName

OR

forms!frmA!cboName.fsubA ?

Thanks.

That was the oddest thing. I knew that subform has to be open for this to work. When I open the main form, I see the whole thing (Main form and subforms), so I assume it is “open”? Or is it defined differently? Can a subform that I can see on the main form be considered “closed”?

Brent

When I followed your directions, the Form Wizard set up two subforms, both in Datasheet views. I didn’t want the Room subform to be in a datasheet form because it wasn’t too inuitive (You would need to click on the room you wanted to force the Bed subform to change) and I wanted to change the Room subform to Single Form, then change the field to a Combo box. When I did that, I suddenly lost “filter” (For lack of a better word) that was applied to the Room Subform whenever I changed Cabins in the cboCabin. Hence, the new topic that I created. I wanted to force the Room subform to list rooms that belong only to the cabin I choose via a combo box, not a datasheet.

Basically, I wanted what the Form Wizard was able to do: Change the Room subform to show rooms specific to the cabin I choose in the main form, but show the rooms as a combo box instead of a datasheet.

Brent

John – Your suggestion worked, I got it very close to what I needed, however, there is a minor detail that needs to be worked out and I don’t know if it is possible or not. Instead of listing ALL rooms, I’d like to change the Room subform from Datasheet to a combo box that would show me only the rooms that belong to the Cabin I choose and show those rooms as a datasheet. My question: How do I tell the darn combo box to look up rooms based on the selection I make in cboCabin?

Tom: Your suggestion came extremely close to what John suggested too but I felt that John’s was much more easier to do but, THANKS for your help! I appreciate it.

Brent

Wanted to let you guys know that I’m still alive and kicking…I had to put this project on hold for a while. I tried John Hutchison’s suggestion of using query as a basis, it came extremely close to what I needed. I need to assess what is wrong with the suggestion and get back to you.

Brent

Would love to post the database and have you help me make it snazzy -looking. Unfortunately, you are right, it does contain sensitive data.

But, do keep those suggestions rolling in. I’m now going to try out John’s suggestion and keep you all updated on the progress. I still also have Tom’s if John’s doesn’t work…

Brent

THANK YOU, THANK YOU, THANK YOU!

John and Tom, the suggestions you both gave me worked! I totally misled you yesterday on the relationships. I looked at the relationships today and it actually made sense, right up to the point where I started to populate the tblBed (I changed the name of the table), that was where I didn’t understand the relationships until I read John’s explaination, D’OH! I didn’t “see” the relationship inside the tblBed with the RoomID and I realized, that was EXACTLY what John meant! Grin.

Anyway, Tom, your suggestion worked perfectly. I am using Continous forms to show all “beds” for a specific room but I have two minor problems that I’m hoping you could help me out:

1) Access 2000 doesn’t allow me to create a continous form if there is a subform embedded in it. So, my fsubRoom has fsubBed (continous form), therefore, fsubRoom can’t be continous form either. That’s fine. I decided to use a Combobox to look up the room number I want which will then show me the beds in that specific room. Is there a better workaround than this?

2) I haven’t figured it out yet, hoping you could. When I set up the combobox in Rooms subform to “look up” rooms, it shows me ALL rooms in the table! I would like to tell the combobox to show me rooms ONLY for that specific cabin I choose. Because, right now, I have 5 different cabins with identical room numbers (1, 2, 3…) and it “repeats” itself (1, 2, 3, 1, 2, 3) and it is extremely difficult for me or user to figure out which room that belongs to. I’d like to filter it out so that it would only show rooms based on which cabin I choose.

Thanks so much to you both, John and Tom!

Tom: Now, I’m hollering.

I decided to start over and use your suggestion because I had tried a different approach that apparently doesn’t work. So far, I’ve created tlkpCabin which contains names of all cabins on the campground; tlkpRoom which contains CabinID FK and room number. However, this is where I really ran into a roadblock! In your message, you said:

“Create a third “bed” table that describes each bed (one bed per record) that includes a reference to the room that the bed belongs to. (Likewise, not that all beds for all rooms and cabins are contained in one table).” and later on: “Only at the “lowest” level do you need a field for the name of the person residing in that bed/berth. Set up a one-to-many relationship between the cabin table and the room table and then between the room table and the bed table.”

So far, I have done with the Bed table is: BedID (AutoNumber, Primary Key), RoomID (Number Format), Bed (Text format, each “bed” is labeled as A or B because each room can have one or more beds in a room) and Name (Text format, for names of person who is assigned to that specific bed). However, I don’t SEE how the database would know that that room belongs to a specific cabin?

The allocation will be indefinite. The previous poster (I’m sorry, I forgot your name. ) gave me the solution I needed. I actually was halfway through but had problems with the form, so I gave up. Now, I know I should have used subforms instead.