Replies

Hans…. As usual I have to bow to your supreme knowledge!
Thanks a bunch! I thought it had something to do with the labels being attached but I never would have thought of just cutting and pasting them to break that attachment…. It would have taken me ages to figure out… Thanks again!

Thanks!

That actually was my first thought… However I spent a ton of time on the dynamic updates to the front-end before I realized that I can’t change the start-up options …disable menus and right click and all that (for two of the three groups only) … as the database opens… It won’t work until the NEXT time the database is opened… which is a waste of time in this situation… I tried all kinds of ways around it but no go… Plus my friend has images and labels with hyperlink addresses all over the place so it wasn’t as simple as making things invisible or disabled… We want them to still show (so that there aren’t a lot of blank areas on his main forms) … and since there’s no enabled property for images or labels… that wouldn’t work…

The programming is not an issue… I believe I’m quite competent in that department… I’m trying to make it easier for my friend to maintain and more esthetically pleasing for his users…

Anyway… I guess it doesn’t really matter what order we do this in… since we can use the same workgroup file with all of the separate split parts… I just thought I’d ask in case I was missing something… Thanks again!

BTW… I have read your paper on Security in the past… I’ll look through it again… It was a great help the first time I secured a db… Terrific work Jack!

Thanks!

That actually was my first thought… However I spent a ton of time on the dynamic updates to the front-end before I realized that I can’t change the start-up options …disable menus and right click and all that (for two of the three groups only) … as the database opens… It won’t work until the NEXT time the database is opened… which is a waste of time in this situation… I tried all kinds of ways around it but no go… Plus my friend has images and labels with hyperlink addresses all over the place so it wasn’t as simple as making things invisible or disabled… We want them to still show (so that there aren’t a lot of blank areas on his main forms) … and since there’s no enabled property for images or labels… that wouldn’t work…

The programming is not an issue… I believe I’m quite competent in that department… I’m trying to make it easier for my friend to maintain and more esthetically pleasing for his users…

Anyway… I guess it doesn’t really matter what order we do this in… since we can use the same workgroup file with all of the separate split parts… I just thought I’d ask in case I was missing something… Thanks again!

BTW… I have read your paper on Security in the past… I’ll look through it again… It was a great help the first time I secured a db… Terrific work Jack!

Thanks Shane!

I think I’m going to bring my laptop to work tomorrow and try this thing in SQL Server… I don’t have a lot of experience with SQL Server but I think it’s worth giving it a shot… I learned on DB2 at school but don’t have that available here at work…

Thanks Shane!

I think I’m going to bring my laptop to work tomorrow and try this thing in SQL Server… I don’t have a lot of experience with SQL Server but I think it’s worth giving it a shot… I learned on DB2 at school but don’t have that available here at work…

Thanks Tom!

I did think of setting the hyperlink property to a null string but there are quite a few of these images and labels to deal with… I also had the idea of removing the value from the hyperlink address property itself… and adding some code in the click event to deal with it… I could do a boolean test in that procedure… I like your second idea… Creating Image and labels over top of one another… and making the right ones visible at the right time… I could name all of the “disabled” ones with the same prefix and see the visible property to true on demand…

Hmm… Gotta think this one through… I just wanted to check with others to see if I was missing some obvious and simple way of accomplishing this…

Thanks again! Have a great day!

Thanks Tom!

I did think of setting the hyperlink property to a null string but there are quite a few of these images and labels to deal with… I also had the idea of removing the value from the hyperlink address property itself… and adding some code in the click event to deal with it… I could do a boolean test in that procedure… I like your second idea… Creating Image and labels over top of one another… and making the right ones visible at the right time… I could name all of the “disabled” ones with the same prefix and see the visible property to true on demand…

Hmm… Gotta think this one through… I just wanted to check with others to see if I was missing some obvious and simple way of accomplishing this…

Thanks again! Have a great day!

Thanks Jim! I thought about that… It might end up that I have to do that… I’m helping someone else with their database and I was hoping to not have to get them to change form design at this stage… but… whatever works right? lol…

Thanks Jim! I thought about that… It might end up that I have to do that… I’m helping someone else with their database and I was hoping to not have to get them to change form design at this stage… but… whatever works right? lol…

Forget my last post… I went back into the xls file…and guess what?… I’m getting the error about the old path again… WTH is going on?????
There’s no way this should be this difficult…

Forget my last post… I went back into the xls file…and guess what?… I’m getting the error about the old path again… WTH is going on?????
There’s no way this should be this difficult…

Just gives me… Run-time error 13 – Type Mismatch…

Well I have it fixed now… Don’t ask me exactly how…

Here’s what I did… Copied the worksheet… Deleted the pivot table on the new sheet… Used the wizard to create a new pivot table with the new source… Started playing with formating and totals and things… Refreshed the data… etc…. (all on the new sheet)

But check this out…. On a whim I decided to try refresh the data on the old worksheet… and instead of the error about not finding the external database, the data updated from the location specified on the new sheet… Go figure?!?! …I’ve deleted my copied sheet and left the old one (since it’s in the right format and sort) … and it’s fine… ?!?!?!
It drives me batty when I fix things and I don’t know how I did it…

Anyway… Thanks for all of your help Steve…

Just gives me… Run-time error 13 – Type Mismatch…

Well I have it fixed now… Don’t ask me exactly how…

Here’s what I did… Copied the worksheet… Deleted the pivot table on the new sheet… Used the wizard to create a new pivot table with the new source… Started playing with formating and totals and things… Refreshed the data… etc…. (all on the new sheet)

But check this out…. On a whim I decided to try refresh the data on the old worksheet… and instead of the error about not finding the external database, the data updated from the location specified on the new sheet… Go figure?!?! …I’ve deleted my copied sheet and left the old one (since it’s in the right format and sort) … and it’s fine… ?!?!?!
It drives me batty when I fix things and I don’t know how I did it…

Anyway… Thanks for all of your help Steve…

The datasource is a table in an Access 97 database… The only thing that has changed is the path…
I can change the path in the SQL statement in MS Query… but it doesn’t save it… I’ll try with the database open and see what happens…
I’ve started trying to recreate the table from scratch… but what a pain this is…

The datasource is a table in an Access 97 database… The only thing that has changed is the path…
I can change the path in the SQL statement in MS Query… but it doesn’t save it… I’ll try with the database open and see what happens…
I’ve started trying to recreate the table from scratch… but what a pain this is…