Search results for query: *

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"

...To lngArrayUBound) Randomize lngCount = 1 Do 'generate random number lngRandomNumber = CLng((lngMaxNumber * Rnd) + 1) 'check if we've already picked this random number blnFound = False For lngSearchLoopCount = 1 To lngCount...

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.

Give your staff the business problem, don't just give them your design and assume it's right. Give them the problem and let them figure out how to solve it. Most IT people (the better ones, anyway) like to solve problems. Going back to training. Give them brouchures, let them choose their...

Can't you just re-create the spreadsheet?

You can find a good example on www.islink.com Look for filter and export...

Could you make the excel spreadsheet part of the access database and dispense with the link altogether? You could consider adding vba to the spreadsheet that exports the data within to the database and if necessary, imports new data from the database. If you attached the code to the open and...

Is it a specific document, or is it the case with all documents? What buttons are greyed out? Do you have full access to the directory?