Search results

I checked the database on the actual users machine and removed the missing reference there. That worked! Thanks a lot!

That didnt seem to work. I tried it both checked and not checked. I wonder if I just make a office\12 directory and drop a copy of my vviewer.dll in there will make the message go away even though they have 2003? Also, I didnt find any references with "MISSING:" so im probably good to go there...

When access 2003 opens the database an error about not finding vviewer.dll comes up. When you click ok the database opens and runs fine. I believe this happened after using my 2007 copy of access to test the active x control for visio viewing thing. I googled and searched the crap out of this...

I am looking into creating a company dashboard linked to many databases. A shortcut is going to be pushed out to all the systems in the company. What would the best way to design this company dashboard be? I am looking into html/java right now but having some trouble. I dont have visual studio...

I ended up just copying my back end and using the linked table manager to switch back and forth from the back end that everyone's using and the back end only I use to develop with. It increased speed and now I am able to develop at a normal speed again with the lag in between every change. Not...

I imported the module and updated it. I also imported the form. I go to login with the form and ive got it to the point that it runs all the way down to giving me an error saying I dont have the correct password. It says the following when I use my login info or Training info. Any ideas...

Awesome! I will give it a try here. I visited your website and found some other good examples there. I appreciate your help and glad you responded! I hate little database show stoppers and I have had a couple lately. I am working on subforms within subforms right now and trying to figure it...

It looks like I will need to import the module and form into my database, update the module to include the names of my tables and links the the back ends and then I can use this form with the logins to switch back and forth. Is that exactly what I need to do or am I off base here?

So how do I import this into my database and make it work for me so that it manages if I want to be connected to live data or not?

Hello All, I created a database for about ten users here at the office. My database development file of the database is tied to the same back end that the users actual front end file is tied to. When I develop in my file I just copy it to the users so they get working updates and the whole...

Smells like you don't know the answer. :) Well, its called conditional formatting if anyone wants to know.

I thought about that. Ill give it a try because it seems to be a good tip. Atleast I can look at the code and see what excel came up with and try to use it. Now in my case, I need to do more testing with locking stuff.

I was wanting it to do it automatically after a normal user enters the data the first time. I know about the protected cells feature. I dont think it is quite what I am looking for. Thanks for any help July.

How would I lock a cell after data is entered? It does not have to be secure locking, just good enough to keep the average user from changing the cells data on accident.

I am attempting to grey out cells that wont be used to enter data with some code. It should still allow one to enter data to those cells though just in case they need to for some odd reason. I am thinking the code would flow such that, lets say... B2:B5000 = Project 1 or Project 2 or Project 3...

The example showed me what I was doing wrong. I didnt realize workbook had its on code box there. Thanks a lot.

I need to figure out if there is a way that I can code a second excel to pull new site info data (like the first five columns in the new row) from the first excel automatically. We have a main tracker for sites and then other trackers with the same site info but it has other columns of data...

I did what was suggested to a "T". Adding it all under Workbook_Open() does not do anything when I open the worksheet. All the suggested similar scripts in this thread only work if I manually run the script as a macro using the green play button. Are you getting it to work in your excel when...

I use that those two last pieces of code seperately and none of them work for me. What could I be doing wrong? I am entering it into the VBA Code box, not the excel box...this is right...

Thanks for the code. It puts me in the right direction but the only way it works is when I run the macro manually. Any suggestions? Am I doing it right?