Search results

Sounds complicated. Can you post the database? I'd like to look at it.

Thanks! That's what I was looking for.

Does anyone know how to create a procedure that will take a string and test to see if it fits a certain format?

Ok. Got that to work. Thanks for the help on that. One more thing. Do you know if there's a way in vbscript to change the mouse pointer to an hourglass?

that's right

I also added at the very top Call OpenFile() What this does now is open the database and then close it again. How do I keep it open?

Ok. I've modified it quite a bit. Learned a lot so far. This successfully tests whether a file has been updated. If so, it copies it over. The last thing I'm trying to get it to do is open the database. But my code doesn't seem to want to work. Can you take a look, please? Sub OpenFile()...

Figured out what I was doing wrong. Trying to put this into a vbs file. Is that possible?

ghudson I tried your code out but it only keeps the database open for a split second. Is there anyway to keep it open?

Well I am trying to setup some code in a module, that would when complete be transferred to a vbs file, that would open up a database file. I've been trying to use OpenCurrentDatabase with the Access.Application object. In the code I set the object to visible. But as soon as the code stops...

Is there an easy way to open a file from vba code?

I'm trying to using this function with the Access application. When I set this object to visible all it does is flash for a split second. Shouldn't it just stay visible?

I put this out on Sunday evening. Maybe I'll have better luck today.

I'm new to creating vbs files. I've used VBA quite a lot so I thought it might be easy to start using them. I created this code in a module in a database to test the date modified on a two files, and if they differ then update the destination file. The idea is to test if there's a new copy of...

What's the library reference for commandbars. My code doesn't seem to recognize: Dim cbr As Commandbar

I did end up finding the problem. Turns out that the network guys are slowing upgrading everyone to office xp. Mine was one of the first. So when I put a new copy of the frontend out it was looking for the libraries in the wrong folder for everyone else. We got it working. Thanks.

Thanks for your response. In fact it does say some references are missing. I think the problem is the network guys setup my computer to have the libraries in a folder called Office10 while most other people's is Office. Know of any way around that?

All of a sudden my database is having problems with the function that is suppose to determine the computer user name in W2000. It's been working fine for a long time and still works on my computer. However, all of a sudden this morning it's not working on other people's computers. It's saying...

ARE YOU OUT OF YOUR MIND?? Just kidding. Just had to blast you a little. In all my experience I've never come across a situation where I needed the primary key to have alpha characters. And if you know how to join tables in queries then you probably never would. But if you want to give it a...

Out of curiousity, what leads you to believe VB is better? And can you recommend some good books to get started? I'm pretty good with VBA. I assume that this will help me a lot in getting started with VB. I like the idea of using MySQL.