Recent content by -ian-

I am trying to create a vb client and server to behave as an interface to access over TCP/IP using winsock. My motivation is to have the server produce full logs of access to the database mdb file, and to log all the SQL edit requests to allow for roll-back, and restore the db after corruption...

I'm afraid you'll HAVE to do some kind of query here, to check if that security number already exists. The way I would tackle it is to put in some BeforeUpdate event code on the textbox. This code would search through the database and see if that Social Security number exists. If the number...

Thanks Pat. Sorry to have posted here, but thanks -you gave me enough info to do an intelligent web search. For anyone other novices that need a leg up in using VB to connect to their access database here's the link I found. http://www.visualbasicforum.com/showthread.php?s=&threadid=11273

How much do you like messing with the registry? I think that might be the only way to get at this information. I haven't found it though (but I am not familiar with the registry anyhow) In Windows 2000, you can bring up the regional settings applet by running intl.cpl, but you can't get it to...

I would like to port my access application to having a visual basic frontend with Access at the back. My motivation is that I want to learn how to connect from Visual Basic to Access, and possibly one day SQL server. Its a lot out of my league, and I don't know where to start. I have Visual...

When my database loads, I put in a region checker to see what region the machine is set to. It compares a date like "1 Dec 2003" to what the machine thinks is the shorthand. If its "1\12\2003" I let them use the database. Otherwise, I get them to change their regional settings. Not elegant...

To convert my British dates to U.S. for SQL, I use this: Format(mydate, "mm/dd/yyyy")

I've always found that the best way to learn a programming language is through neccesity. Nothing motivates like a problem needing to be solved. I started out with no visual basic or access experience, and searching through this site sample code got me started, AND fixed every problem I ever...

You'll have to get the file from your Office 2000 CD. This file is too big to post here. Then, look at the rest of the posts as advised to continue. Ian./

Using the -On Enter- event -Thats it! I tried moving the cursor to the end of the text, using Selstart and SelLength and that didn't help, but I noticed that the code was activated when the mouse was pressed rather than when it was depressed. So, I shifted the focus of the control off the...

Hi all, I have a form with textboxes whose data is automatically filled in when the form loads. I need to have the click-event on the textbox open to me so the user can select this text as an option, but I don't what any text in the box to highlight with the cursor when they -do- click on it...

How about adding "After Update" events to each of your text boxes. The after update code would set the next lines code to the contents of the current box?

I've heard of this error before. But only in Access 2.0. This usually comes from loading the wrong version of the tools and libraries. You possibly might be trying to load in older access libraries here?

The field that corrupted so bad I couldn't even edit it WAS a memo field Rich.... Is this a problem with memo fields? Remember, I couldn't even delete the record either! And Pat, sadly a compact and repair didn't help. And I was lucky the database is pretty basic. I try to do as much of the...

What I did was: 1) Copy old table [books] to new table [NewBooks] as structure only 2) Wrote a VB script to copy the entries from the old table into the new one up to the point of corruption. 3)Hand entered the correct data for the corrupted entry 4)Used the VB script to copy the rest of the...