Firefox Sync

I get alert message from FireFox asking for updating software to version 20.xxx
After searching through FF Tools menu to find the software update menu, I found the menu name "Firefox Sync" this is not the software update but what for. Firefox Wiki has the answer.

Firefox Sync, originally branded Mozilla Weave,^[2] is a browser synchronization feature that allows users to partially synchronize bookmarks, browsing history, preferences, passwords, filled forms, add-ons and the last 25 opened tabs across multiple computers.^[3]
It keeps user data on Mozilla servers, but the data is encrypted in such a way that no third party, not even Mozilla, can access user information.^[4]
Firefox Sync was originally an add-on^[5] for Mozilla Firefox 3.x and SeaMonkey 2.0, but it has been a built-in feature since Firefox 4.0^[6] and SeaMonkey 2.1.<sup>[7]

Ok, back to the Firefox update issue. you can update your firefox from Help>About Firefox menu , it will check and update your firefox browser automatically.


Thanes</sup>

Using date string in SQL statement MS Access Tip

MS Access normally translate our input date from text box to US-format. So to avoid this we have to convert our date string from text box to US-Format before using it in our SQL statement.

Ok here is the code,

....

USdate = Format(InputDate,"mm/dd/yyyy")

Sqlstring = " Select * from [Table1] where [datadate] = #"& USdate &"# "

....

Hope this help.

Thanes

--------- `

MS Access ปกติแล้วจะแปลวันที่ที่เราป้อนเข้าไปทาง Text box ต่างๆเป็น รูปแบบของ US ก่อนเอาไปประมวลผล ดังนั้นถ้าจะเลี่ยงปัญหานี้ ก็แค่แปลง รูปแบบของวันที่ที่ป้อนไปเป็น US format ก่อน เอาไปรวมใน SQL Statement  แค่นั้น

ตัวอย่าง

....
USdate = Format(InputDate,"mm/dd/yyyy")
Sqlstring = " Select * from [Table1] where [datadate] = #"& USdate &"# "
....

หวังว่าจะช่วยได้ครับ

Thanes

Microsoft Access

Currently I'm working on MS-Access modification project for some clients, never use it before. Yes it is the good database program. The greatest thing about MS-Access is it simple data import process, user with little tech-skill can use it, copy some data from EXCEL and paste it it ACCESS data sheet. Wow!

Cool