Search results

Yes I am currently assigning each user a number which represents a group (1 through 8). Using the table in my original post, I would assign newuser the number "3" for the Secretary level. Doing that works with the site perfectly. I only got stumped when I tried to present the hierarchy in an...

dcx693 - I thought of this one day when I was creating a secure Web site. I have users assigned to different levels - what shows up on the site, and what you can do with it depends on your level. I then started thinking that it would be nice if I could create something like what they do in...

Hello everyone, I'm a little stumped on something. I would like to know how many levels down something is in a hierachy. Table_Hierarchy ParentID ChildID Here are some typical entries (1 for President, 2 for Manager, 3 for Secretary) 1 2 2 3 If you follow this, 3 is a child to 2 which in...

I do like Kevin_S's idea (and that's what I would do in your place), but if you don't like that route then try used book stores! When I took VB in school I got a working copy with my textbook (VB 6 - How to Program - Deitel & Deitel). I know that the help files were absent and probably some...

Thanks llkhoutx, I do have a solution in my head - but it's a bit of work. I just didn't want to invest a lot of time only to find out later that I could've right-clicked and selected "read-only" :) If there were just a few more property options for Linked tables! Another thing I don't like...

Hello, From my front end, I link to several tables from various databases. I just need for one of those tables to be read only in case a user opens it through the database window and tries to edit it. It does however need to be editable in the original database (where the table comes from)...

Hey tsh, are you by chance using using something else other than Access as the front-end? I had a similar problem where I was using Access as a backend for a web application and I couldn't delete or modify the ldb file until after 10 minutes (which is what the set timeout of the ODBC was)...

Thanks for answering Igor - but as I said in my original post "I can still control it with VBA" (just like you showed). What I would like to prevent is the max/restore/min buttons that usually appear in the top right corner of a form from disapeering when you maximize it. I would like the...

Hey Gumby - thanks for answering! I looked where you suggested and after playing with the settings (I even restored the default settings), I still get the same symptoms! Anything else I should be looking at? Thanks again! -Sean

Hello all, I'm not sure what I might have changed, but I cannot seem to restore or minimize my windows in an Access app after it's been maximized. The buttons just disapeer after you maximize it (see attached screen shot) - including the db window! (note though that I can still control it with...

Hello all, I have a form which displays 2 date fields in the following format (in the textboxes): mmm dd", "yyyy hh:nn AM/PM They both display the way I want - the strange stuff happens when I click in the textbox to edit the date, one remains in the same format while the other switches to...

Hey Len, you may very well be right because the users of my group seem to be able to do everything with one exception - change their password in the mdw (which is what prompted me to post this question). I will post a new thread on the subject if I don't solve it soon. Thanks for answering...

Hello all, I have created user accounts - assigned their permissions - and then assigned users to those groups. I'm having some problems though - when I check the permissions for the groups it seems fine, but if I click on the individual user they have no permissions! Should they not inherit...

Thank you Travis! -Sean

Hello everyone, I've been able to add a form to allow users to change their passwords from this thread (thanks Autoeng!) http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37534 Now I would like to create a new form that would allow one to add or delete users. I can handle...

Thanks for answering ghudson, I did try that, and it kind of worked. My subform is a continuous form, so it does refresh if I click on another record - but not if I just change fields. -Sean

Hello all, I've made it so that my form refreshes after any updates to any of the records on my continuous form occur. This works fine, but it was a pain to put in an after_update event for each field. Could I not have done just one? ie Private Sub current_record_after_update() me.Refresh...

Hey David, you could trap the error by getting the error number - but I have heard that this isn't recommended as those numbers might change in future versions. What I would do is make your first listbox based on a query rather than just on the table. The query would select all records from...

Thanks for the replies guys! I've seen others suggesting to check the "Read-only" property - but I was foolishly looking in Access for it! (D-oh!) As you both suspected, it was a read-only issue - only with the entire C drive! I believe the reason is because he switched PCs with another...

Hello everyone, I have a split db in a network environment. My FE gets copied from the network and pasted into a folder within the users C drive (the method posted by Autoeng). This has worked great for everyone except for today when one of the users got a new pc. It worked the first time (a...