Minggu, 04 Desember 2016

Re: [MS_AccessPros] filename changes when imported into msaccess

 

hi Onno,

at the top of the module to process foreign characters, instead of
Option Compare Database

choose:
Option Compare Binary

if using InStr or StrComp, use vbBinaryCompare for the optional 'compare' argument

InStr([start, ]string1, string2[, compare])
StrComp(string1, string2[, compare])

there are other functions can specify these comparison constants too

for storing, however, my experience it that you can't do it with regular string variables ... but fields can store it, and so can probably controls

respectfully,
crystal



On 12/1/2016 3:20 PM, onno.knol@pbl.nl [MS_Access_Professionals] wrote:

Friends  I have  encountered a strange phenomenon.

I select a filename using the filedialog. it is an Mp3 file with a Spanish title:

12 - La Estaciyn Del Mar - La Chica De Goa.mp3" is what it shows like in the  windows filesystem.

Then I put it into a string variable, and when I try to work with that ( I want to move the file)

it appears that the string variable  contains this: 

 12 - La Estaci?n Del Mar - La Chica De Goa.mp3" 

 

Apparently the 'y'  character is some special Spanish character that is not well recorded in the VBA variable.


How can I work with this? 

 if I do a check if the fileexists with the new name, the result is false.

how can move/ rename the file if I can't get the real name?


Does it have to do with codepages or charactersets?

Can I transform it in some way?


BTW  I received the file from a person wit a Spanish  windows version.


I h pe someone can help me out, I do not know the clue.


Oh by the way I use win10 and msaccess 2010


Thanks,


 Onno Knol

  


__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.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:

Sabtu, 03 Desember 2016

[belajar-access] formula lookup data bor [1 Attachment]

 
[Attachment(s) from dody ginandjar dody_gin@yahoo.com [belajar-access] included below]

Selamat pagi,


Saya punya 2 tabel data bor, yg pertama tabel jenis batuan, dan yg kedua table sampling.
saya ingin menampilkan jenis batuan di tabel kedua, sesuai kedalamannya.
Lebih jelasnya bisa di lihat di gambar terlampir.


Sebelumnya saya ucapkan terima kasih.


Dody g

__._,_.___

Attachment(s) from dody ginandjar dody_gin@yahoo.com [belajar-access] | View attachments on the web

1 of 1 Photo(s)

Posted by: dody ginandjar <dody_gin@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Check out the automatic photo album with 1 photo(s) from this topic.
att0
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:

Jumat, 02 Desember 2016

Re: [MS_AccessPros] Please help with code Access 2010

 

Dear kenaf42 (name?)


You need code in the After Update event of each of the combo boxes to copy the selected value to D.  If D starts out with a Null value, then that's what it will have if no value is selected from any of the combo boxes.

Private Sub A_AfterUpdate()
    Me.D = Me.A
End Sub


John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Dec 2, 2016, at 7:16 PM, kenaf42@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



I have 3 combo boxes, A, B and C on a form.  Also text box named D.  I want to be able while adding data after selecting a value in any of the 3 combo boxes to that value to be copied in to field D, and if no value been selected then field D to be null.


 Thanks in advance





__._,_.___
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] Please help with code Access 2010

 

I have 3 combo boxes, A, B and C on a form.  Also text box named D.  I want to be able while adding data after selecting a value in any of the 3 combo boxes to that value to be copied in to field D, and if no value been selected then field D to be null.

 Thanks in advance


__._,_.___
Posted by: kenaf42@yahoo.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:

Kamis, 01 Desember 2016

[MS_AccessPros] filename changes when imported into msaccess

 

Friends  I have  encountered a strange phenomenon.

I select a filename using the filedialog. it is an Mp3 file with a Spanish title:

12 - La Estaciyn Del Mar - La Chica De Goa.mp3" is what it shows like in the  windows filesystem.

Then I put it into a string variable, and when I try to work with that ( I want to move the file)

it appears that the string variable  contains this: 

 12 - La Estaci?n Del Mar - La Chica De Goa.mp3" 

 

Apparently the 'y'  character is some special Spanish character that is not well recorded in the VBA variable.


How can I work with this? 

 if I do a check if the fileexists with the new name, the result is false.

how can move/ rename the file if I can't get the real name?


Does it have to do with codepages or charactersets?

Can I transform it in some way?


BTW  I received the file from a person wit a Spanish  windows version.


I h pe someone can help me out, I do not know the clue.


Oh by the way I use win10 and msaccess 2010


Thanks,


 Onno Knol

  

__._,_.___
Posted by: onno.knol@pbl.nl
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:

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (117)
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:

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (149)
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.

Please zip all files prior to uploading to Files section.

.

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