Selasa, 25 Oktober 2016

Re: [MS_AccessPros] Find Replace in Access

 

James,


Please include the previous message in your replies. This typically is the default behavior when using an email client or Outlook Web. I think there is a check box when posting via the Yahoo group site.


Regards,

Duane



From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of James Asante asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, October 25, 2016 5:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Find Replace in Access
 


Hi Duane
My aim is to automate manual processes.

Cheers
James


__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Find Replace in Access

 

Hi Duane
My aim is to automate manual processes.

Cheers
James

__._,_.___
Posted by: James Asante <asanteza@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Find Replace in Access

 

I expect you do do this in datasheet with a simple Find and Replace.


Regards,

Duane



From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, October 24, 2016 2:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Find Replace in Access
 


Hi Everyone

All data in my FirstName field begin with open bracket e.g "(Vino". How can I take out the open bracket with a query? Also for my LastName field which contains closing bracket at the end of the name, e.g "Padayachee)".


Regards

James



__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [belajar-access] Mengapa Menggunakan Access

 

betul Pak Haer,,, ms access memang cepet jadi duit...


On Saturday, October 22, 2016 7:36 PM, "Nino Ruwano ninoguevara@gmail.com [belajar-access]" <belajar-access@yahoogroups.com> wrote:


 
Jawaban klasik dari pertanyaan klasik: Access cepet jadi duit!
😁😁

2016-10-14 16:51 GMT+07:00 Haer Talib haertalib@gmail.com [belajar-access] <belajar-access@yahoogroups.com>:
 
​

Mengapa Menggunakan Access

Oleh: Haer Talib

Pertanyaan klasik (karena sudah lama juga ditanyakan): "mengapa menggunakan Microsoft Access?"

Berbagai versi memang pertanyaan tersebut. Ketika saya sedang menghandle sebuah event untuk komunitas Microsoft Access di kantor Microsoft Indonesia, seorang staf di situ menyatakan dengan agak heran ke saya: "saya nggak tahu kalau Microsoft Access masih dipakai..."

Lah... :)

Ketika saya bertemu dengan seorang senior yang pakar database macem-macem (gelar MSC/Microsoft Certified-nya banyak), secara pelan dia berpesan kepada saya: "jangan pakai Access lah..."

Lho, kenapa?

Baca selengkapnya »
​




__._,_.___
Posted by: Suwandak Jedut <suwandak@ymail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Senin, 24 Oktober 2016

Re: [MS_AccessPros] Find Replace in Access

 

Thank you very much, John. It was helpful.

Regards
James

__._,_.___
Posted by: James Asante <asanteza@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Find Replace in Access

 

James-

UPDATE MyTable
SET FirstName = Replace([FirstName], "(", "");

UPDATE MyTable
SET LastName = Replace([LastName], ")", "");

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Oct 24, 2016, at 21:21, asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi Everyone

All data in my FirstName field begin with open bracket e.g "(Vino". How can I take out the open bracket with a query? Also for my LastName field which contains closing bracket at the end of the name, e.g "Padayachee)".


Regards

James

__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Find Replace in Access

 

Hi Everyone

All data in my FirstName field begin with open bracket e.g "(Vino". How can I take out the open bracket with a query? Also for my LastName field which contains closing bracket at the end of the name, e.g "Padayachee)".


Regards

James

__._,_.___
Posted by: asanteza@gmail.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)