Search results for query: *

Looks like I may not need the assist with this one after all. I've decided to revamp my code and design the project in Visual Studio. It is easier to get to a web reference using that. Still like to know if there's a way to add the web reference via VBScript. I'm positive there is. It's...

I'm pretty new with the webservices/web reference idea, so I'm probably going to explain some of this wrong. Nevertheless...here goes: I would like to create a simple VBScript which will run as a scheduled task on a computer. When the script sees that there is no E drive present, it should...

I'm trying to figure this one out. I've just started using the group policy tool to redirect the "My Documents" directory for certain users. It works great (like the sync aspect of it too for laptop users). However, I have noticed that if you are logged in as a user who has the "My Docs"...

Ed, Nice code there. Even ignoring the system tables -- nice. Just curious, where could I pass a password parameter for the backend database? The backend has a password on opening (as does the front end). This was done as one more security measure, primarily in case the users had to email...

Thanks again for the valued insight here. I DO in fact know of a little code snippet to get the current drive of the database (got it here): Dim strPath As String strPath = Application.CurrentProject.Path MsgBox ("It is " & strPath) Works nice, and I also have some code to relink tables...

Thanks for the response Ed, That's pretty much what I thought (about the ability to install the MDE wherever you want with the installation package program). I was also thinking about the other issue of what exactly the drive letter would be for the stick (different on any computer that uses...

Hello all, I've been reading up on developing my Access application via runtime so I can distribute it to users who may not have Access installed on their computer. I realize there are all sorts of neat tricks to getting the application to run in the runtime mode even if the user DOES have...

Thanks for that quick reply CMP. I had to change the following on the code though: tdf.Connect = ";DATABASE=" & strDatabase & ";pwd=" & "go" Needed "PWD" in there instead of "password". I seem to remember seeing that somewhere else too. Thanks for the code though. Couldn't have figured half...

Hey all, We have a frontend and backend database scenario here, with both databases having passwords for entry (using the simple Access 2003 database password security from the "tools" menu....no users or groups or anything). I've got the tables linked just fine, but I'm having trouble with...

Excellent Tip!! I was looking for something similar which would give a running count (or total), of a report's control value. We went through all types of code scenarios, but in the end it looks like your idea works the best. You get a star from me. Thanks for the very useful tip!!

Thanks again for the help there bcastner. I haven't had a chance to post anything on this till now, so sorry about the delay. Your suggestion worked with the help of a little more code work. I still had to change the user to an admin level so the printer could be installed correctly on their...

bcastner, Thanks again for that help! It is a step in the right direction, but since I don't have the user's machines in front of me now, I have to kind of figure out a way to "automatically" register their logon as an admin (without them using the machine's admin account to do this). I...

Billiant! Thanks for the quick response bcastner (as always). I'll have some time to look it over later tonight and tomorrow. I'll try to post my results back. Thanks!

Hey all, I've been searching for an answer on this one, but it appears I can't find anything real specific to LOCAL printers (found some good info on network ones though). I have about 7 machines which run XP Home addition (I know, it's not XP Pro, but it kind of fits the forum). They have...

thanks bcastner. I'll try that when I get a chance. Right now, I'm away from my home network, but that seems to sound right. So, I DON'T have to reconfigure the computer to run on my home network, right? I just choose to logon to the computer (can't logon to the work network, because...

Hey all, I was wondering if anyone had heard of any type of sofware, or configuration details which would make it possible to print to a shared printer on a home network from a computer which is on a domain. To be more precise, I have a wireless Dell Latitude D505 laptop, running Win XP Pro...

That seems to do the trick. I put my code as follows on the ThisDocument Object of the MS Word Objects: Private Sub Document_Open() CommandBars(36).Enabled = False End Sub I DID put a button to get to the VB code editor on one of my toolbars though, in case I want to see the menu bar...

I am having trouble figuring out how to hide the Menu Bar in MS Word 2K. I would like to do this so that I can force the users to use my own developed toolbar. I have not yet found a possible solution for this. In searching the site, I found some great posts about hiding the Excel Menu Bar...

Thanks for the advice guys! Both good suggestions, but it looks like it's 'stoopidity' on my part that broke it. It turns out that the main problem seems to be that the PointLkp_Tbl table didn't have a primary key in it. For some reason that's needed for the recordset loop iteration to work...

Hello all, I have the following code which SHOULD create a recordset (mev3 is the data for it) and update a field in the set while it loops through. Apparently, this does not seem to work though. Here is the code: Dim VarField As String Dim x As Integer Dim y As Integer Dim z As Integer Dim...