I have the following SQL statement for an update query:
UPDATE tbl_TEPRecords SET tbl_TEPRecords.[VP Other:Custom] = True,
tbl_TEPRecords.[VP Other:Glue of valve/hinge] = True
WHERE (((tbl_TEPRecords.[VP Other:Extra Increased Resistance])=True)) OR

What would cause VB outputting to Excel, not work the first time, but work
everytime after that (while the database is still open)
i.e. I output a query to excel, the format it from access (bold, insert
columns, etc.) - see last post for code

I have a bound text box and I want to display a date, but formated like this
"dd/mm/yyyy".
I tryed to input a mask like 99/99/0000;0;_, but when I insert in the text
box let's say 31/12/2008, on lost focus changes to 12/31/2008.

do i need ot have sync center on my start up and what is sync center.. I do
not use a pda or have this system communicate to any other device.

Hi john, thanks for help. You are great, Your option working wonderfully.
Now I small problem to compare result of top 20 with different last sr's and
display odd numbers. My data is something like this :_
sr numvalue cdate

Microsoft recently did its best to promote its Software Plus Services
strategy at its S+S:
The software giant’s chief executive officer, Steve Ballmer, addressed
executives, Gold partners and IT managers and