Recent content by chogben

We've got a form that doesn't allow the user to update the data on minute, but does the next. The changes look okay on the screen, but no change to the underlying data takes place. Any code that runs finds the 'old' data. So the screen updates, but the data doesn't. [sad] Any ideas? Recently...

Got a strange intermittent problem here. Every now and again - say less than once a week. If the user starts to edit a record and then swaps to another application before saving the changes and then swaps back, the current record changes to another. The form has a tab control with 5 pages on...

Every now and again the controls outside of the tab point to a different record to those inside the tab. Moving off the record and back again seems to fix it, but it keeps re-occuring. This happens less than 1% of the time. Does anyone what's causing this or more importantly, how to fix it...

Cheers Steve, How would I go about this? The list is useful, but we've decided to optimise the database for running queries, but the downside of the mod is that it will take a long to build the list...

We have several objects where a list of values would be very useful, but can take a very, very long time to generate... Is it possible to generate the list on one machine, and distribute the list to all the others? [morning]

Try changing these declations:- dim Conn as new adodb.connection dim Rec1 as new adodb.recordset dim Rec2 as new adodb.recordset dim Rec3 as new adodb.recordset dim Rec4 as new adodb.recordset to this format:- dim Conn as adodb.connection ... set conn= new adodb.connection

Have a look at digital certificates. It will prove that the vba code was written by you, AND hasn't been altered by anyone else. Of course, if you don't want people to look at your code, then just protect it. If you don't think sticking a password is enough (I'm sure there are ways around)...

We recently renewed our Microsoft Authenticode certificate. When I try to import it using pvkimrt, I get this error: - Error: 80092004, Cannot find object of property. I can't find any further information on Microsoft's site. I'm running windows 2000 and office 2000. Please help, I'm going...

I think in Access 97 you can use command line arguments, you'll have to raid the help as I've got 2000 here. You also want to look at the shell command to start up access with those parameters. There are other ways of doing it, but this is one of the simpliest. HTH

You could use the current date in the filename - just remember to format it first strfilename="whatever" & format$(date,"yyyymmdd") & ".txt"

I've created several VBA data providers. 95%+ of the time they work great, but every now and again I get error 115. Does anyone have any information on this error? Has anyone else encountered this? Here's a sample provider - it picks 10 rows at random from any DP, copying it's structure as...

I used MCSD in a Nutshell by James Foxall. It covers pretty much everything you need to know to pass both the visual basic microsoft exams. My advice is to study specifically for the exams. An experienced user who assumes s/he knows enough will have a very tough time.

Export the file,read it in, replace each , with a ;,save the file again. Let me know if you need any help with the code.

Is it possible to set up a resource that emails the person who booked it with further details? [ponder] We want to set up a system that allows staff to book a pool car. Current thinking is an outlook calendar. After the user has booked the car, we would like to send them an email detailing...

Or just copy a blank version over the top of it. It's a fairly quick and easy method.