Rabu, 29 Februari 2012

Bls: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

 

Thanx John..
Would you mind give me an example about the Form Error Event that you had told me..?
I think editing record is more complex than inserting data...
Regards
Hendra

________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Kamis, 1 Maret 2012 6:25
Judul: RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)


 
Hendra-

Partly correct. Leave record-level locking turned on.

Here's what will happen when two users try to change the same record:

1) User A will find the record and start to edit it. This sets a timestamp locally.

2) User B will find the same record, edit it, and save. The save sets a timestamp of the time of the save.

3) User A (who went to get a cup of coffee after starting to edit) tries to save.

Result: Access will see that someone else has updated the record since A started to edit. User A will get a warning message with an option to either discard the changes A just tried to make or copy the changes to the clipboard. User A *cannot* overwrite what B just did. You can use the Form_Error event to trap this case and issue a custom message that forces the user to start over.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Wednesday, February 29, 2012 2:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Thanx John...

No Lock setting (is setted on the form ...right?)... is that the same way to unchek "Open Database using record locking"..?
Then if we set all of the form properties to "No Lock", what will happen if more than one users edit the same record in the same time..?..(i can't imagine it)

________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Rabu, 29 Februari 2012 23:49
Judul: RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Hendra-

Unless you have dozens of simultaneous users, the chance of a "collision" editing records is very very low. As long as you have No Locks set, you should have no problems with bound forms.

Important notes:

1) Users should NOT try to share a database over a wireless connection.

2) Users should share only the "data" database on a server - a database with the tables only. Each user should have his or her own copy of the "code" database (linked tables to the shared data, queries, forms, reports, and code).

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Tuesday, February 28, 2012 5:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Thanx John...
Yes..that is what i am thinking...why do we choose the harder way if Access give the simpler way.?..
But the other side i am thinking to about the table's burden (..is the word "burden" right?..sorry if not)..
I mean with the bound form, users are access directly to table at the same time (especially with UPDATE processing)..
so with that opinion i think unbound form is better because it's not access the table directly and no connection to the table happened
until we run the INSERT or UPDATE command.
But in several articles i've read that sometimes Inserting or Updating with codes give slowly processing especially in wireless connection..
Please give me more explanation because i am developing my first multi user application,,so i have to decide the best methods from beginning
Regards
Hendra

________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Rabu, 29 Februari 2012 8:26
Judul: RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Hendra-

If you use unbound forms, you are putting into code what Access will do for you.
Your application will be much more complex and more time-consuming to build.
There is a small advantage to using unbound forms, but a bound form will provide
very satisfactory results, especially if you set Record Locking to No Locks.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Tuesday, February 28, 2012 3:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert
Into)

Hi All,...

Which is more better in network environment and multi user :
Bound Form (Data Entry : Yes) Or Unbound Form (Insert Into method) ?

Regards
Hendra

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

[MS_AccessPros] Re: leading or trailing spaces/characters??

 

How does this type of thing happen? Is this something to worry about?
Thanks again.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Earlier, I think you said you got 10 as the length. MC63 MC63 is 9. Most
> puzzling. What is the length of the field in table design, and what is the
> longest ID value you have? If they are all 4 characters, you could change the
> length to 4, and Access will truncate the field.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Wednesday, February 29, 2012 6:54 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
>
> Asc(Left(ID, 1)) returns 77 which I see is M.
> When I copy to the clipboard it shows "MC63 MC63". When I copy a different
> value, it pastes correctly- just one time. Why is MC63 twice?
> Thanks again for your help.
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Chr(51) is the number 3, which is what you would expect in a field containing
> > "MC63".
> >
> > What does Asc(Left(ID, 1)) return?
> >
> > Also, open the table in Datasheet view, select the row containing MC63, copy
> it
> > to the clipboard, then paste it into a reply.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Kirkland, WA)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> > Sent: Wednesday, February 29, 2012 5:16 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> >
> > That returns 51.
> > Thanks
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@>
> > wrote:
> > >
> > > ...and also:
> > >
> > > Asc(Right(ID,1))
> > >
> > > Best wishes
> > > Graham [Access MVP 1996-2012]
> > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > > > Sent: Thursday, 1 March 2012 11:38
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> > > >
> > > >  
> > > > What are the results from:
> > > >
> > > > Len(Trim(ID))
> > > >
> > > > Len(ID)
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> > > wrote:
> > > > >
> > > > > I can't figure this out.
> > > > >
> > > > > select id from table where id = "mc63" does not work
> > > > > select id from table where id like "*mc63*" does
> > > > >
> > > > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > > > >
> > > > > Any assistance would be greatly appreciated!
> > > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] Re: leading or trailing spaces/characters??

 

Earlier, I think you said you got 10 as the length. MC63 MC63 is 9. Most
puzzling. What is the length of the field in table design, and what is the
longest ID value you have? If they are all 4 characters, you could change the
length to 4, and Access will truncate the field.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Wednesday, February 29, 2012 6:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

Asc(Left(ID, 1)) returns 77 which I see is M.
When I copy to the clipboard it shows "MC63 MC63". When I copy a different
value, it pastes correctly- just one time. Why is MC63 twice?
Thanks again for your help.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Chr(51) is the number 3, which is what you would expect in a field containing
> "MC63".
>
> What does Asc(Left(ID, 1)) return?
>
> Also, open the table in Datasheet view, select the row containing MC63, copy
it
> to the clipboard, then paste it into a reply.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Wednesday, February 29, 2012 5:16 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
>
> That returns 51.
> Thanks
>
> --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@>
> wrote:
> >
> > ...and also:
> >
> > Asc(Right(ID,1))
> >
> > Best wishes
> > Graham [Access MVP 1996-2012]
> >
> > > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > > Sent: Thursday, 1 March 2012 11:38
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> > >
> > >  
> > > What are the results from:
> > >
> > > Len(Trim(ID))
> > >
> > > Len(ID)
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> > wrote:
> > > >
> > > > I can't figure this out.
> > > >
> > > > select id from table where id = "mc63" does not work
> > > > select id from table where id like "*mc63*" does
> > > >
> > > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > > >
> > > > Any assistance would be greatly appreciated!
> > > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

[MS_AccessPros] Re: leading or trailing spaces/characters??

 

Asc(Left(ID, 1)) returns 77 which I see is M.
When I copy to the clipboard it shows "MC63 MC63". When I copy a different value, it pastes correctly- just one time. Why is MC63 twice?
Thanks again for your help.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Chr(51) is the number 3, which is what you would expect in a field containing
> "MC63".
>
> What does Asc(Left(ID, 1)) return?
>
> Also, open the table in Datasheet view, select the row containing MC63, copy it
> to the clipboard, then paste it into a reply.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Wednesday, February 29, 2012 5:16 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
>
> That returns 51.
> Thanks
>
> --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@>
> wrote:
> >
> > ...and also:
> >
> > Asc(Right(ID,1))
> >
> > Best wishes
> > Graham [Access MVP 1996-2012]
> >
> > > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > > Sent: Thursday, 1 March 2012 11:38
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> > >
> > >  
> > > What are the results from:
> > >
> > > Len(Trim(ID))
> > >
> > > Len(ID)
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> > wrote:
> > > >
> > > > I can't figure this out.
> > > >
> > > > select id from table where id = "mc63" does not work
> > > > select id from table where id like "*mc63*" does
> > > >
> > > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > > >
> > > > Any assistance would be greatly appreciated!
> > > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

__._,_.___
Recent Activity:
.

__,_._,___

[belajar-access] Re: lookup reference

 

Dear pak Aksan,

setelah mencoba2 selama 2 3 hari akhirnya saya bisa menghubungkan kedua combo box ini. maklum newbie ^^. thanks a lot

--- In belajar-access@yahoogroups.com, Aksan Kurdin <aksan.kurdin@...> wrote:
>
> ada di arsip milis kita:
> http://tech.groups.yahoo.com/group/belajar-access/messages/33508?threaded=1&m=e&var=1&tidx=1
> <http://tech.groups.yahoo.com/group/belajar-access/messages/33508?threaded=1&m=e&var=1&tidx=1>
>
> saya paste-kan saja percakapannya:
>
> #33508 From: "Krishna" <krishna.rusli@...>
> Date: Tue Jan 24, 2012 1:55 pm
> Subject: bingung mengenai combo box di Ms.Access krishna_h_aries
> Offline
> Send Email
>
> salam kenal mas-mbak..
>
> aku ada persoalan neh, mengenai combobox...
>
> gini, aku punya 3 table..
> table lokasi ==> motor ==> catatan pemeliharaan..
> LOKASI (tabel nenek) ==> MOTOR (tabel IBU)==>Catatan pemeliharaan (tabel
> anak)..
> lokasi, parrents dari motor.. (1 lokasi bisa punya banyak motor..)
> motor, parrents dari catatan pemeliharaan (1 motor, kan bisa dipelihara
> lebih dari 1x :D)..
>
> nah.. di tabel catatan pemeliharaan, ada field LOKASI sama MOTOR..
> di tabel MOTOR, ada field LOKASI..
>
> kira2 tabelnya spt pd gambar berikut
>
> gambar relationship ^_^
>
> nah.. aku bingung buat relationsip LOKASI di tabel CATATAN
> PEMELIHARAAN.. setiap relationship type field-nya : combo box..
>
> aku pengennya sih ketika aku pilih lokasi A, hanya motor2 di lokasi A
> saja yang keluar di combo box tabel catatan pemeliharaan..
> misal lokasi pabrik, punya motor supra sama jupiter x..
> lokasi rumah punya motor vega sama revo..
>
> aku pengennya-di table catatan pemeliharaan- ketika aku pilih pabrik, yg
> keluar HANYA motor supra sama jupiter x.. ^_^
>
>
> kl di tabel catatan pemeliharaan, field LOKASI (type combo box), raw
> sourcenya aku ambil dari tabel lokasi field LOKASI (type text)... (tabel
> neneknya lah..) aku bingung nyambungin ke tabel motor (tabel ibunya),
> supaya sesuai dgn spec yg aku ingin... jika pilih lokasi pabrik, yg
> keluar hanya motor jupiter x dan revo..
>
> kl di tabel catatan pemeliharaan(tabel anak), field LOKASI (type combo
> box), raw sourcenya aku ambil dari tabel motor field LOKASI (type combo
> box juga)... aku sudah berhasil buat Meng-update Combo Box berdasarkan
> Nilai Combo Box lain pada MS Access 2010 nya.. dari tutorial di link itu..
>
> tapi dalam case ku yg keluar malah ID lokasinya, bukan text tempat
> lokasinya dimana...
>
> ada yg bisa bantu ga???
>
> makasih banget buat yg bantu ^_^
>
>
> #33509 From: "Krishna" <krishna.rusli@...>
> Date: Tue Jan 24, 2012 10:08 pm
> Subject: Re: bingung mengenai combo box di Ms.Access krishna_h_aries
> Offline
> Send Email
>
> ada yg bisa bantu ga??
>
> aku bener2 dah nyoba berbagai macam cara, tp gak bisa jg.. :(
>
> akan sangat berterima kasih terhadap semua bantuan dari kakak-kakak
> sekalian..
>
>
>
> #33513 From: "Krishna" <krishna.rusli@...>
> Date: Wed Jan 25, 2012 12:54 pm
> Subject: Re: bingung mengenai combo box di Ms.Access krishna_h_aries
> Offline
> Send Email
>
> sdh ada solusi beloom, ato cluenya de.. :D..
>
> maklum, nwbie lg buntu.. ;)..
>
> trims gan.. hehe
>
>
>
> #33515 From: "Kuncara Arief" <kuncara.arief@...>
> Date: Wed Jan 25, 2012 6:56 pm
> Subject: RE: bingung mengenai combo box di Ms.Access kuncara.arief
> Offline
> Send Email
>
> Dear Saudara Krishna,
>
>
>
> Saya coba bantu ya.. mudah2an interpretasi saya terhadap permasalahan
> nya bener nih..
>
> Intinya kan ketika Saudara akan bikin form inputan data pemeliharaan
> ketika akan mengisi Field lokasi A maka yang keluar hanya motor2 yg
> sudah didefinikan di tablenya..
>
>
>
> Pertama2 seh bikin combobox untuk Field LOKASI dengan
>
> Row Source type diisi Table
>
> Row Source diisi SELECT ID, Lokasi From Lokasi
>
> Column Count = 2
>
> Column Width = 0cm;1cm
>
> List Width = Auto
>
> Kemudian dievent after update ketikan (dengan asumsi combobox untuk
> Field LOKASI sudah dibikin ya..)
>
> Me.Lokasi.requery
>
>
> Selanjutnya di combobox Lokasi
>
> Row Source type diisi Table
>
> Row Source diisi SELECT ID, Lokasi From Data Motor Where Lokasi = &
> Forms!NamaForm!Lokasi
>
> Column Count = 2
>
> Column Width = 0cm;1cm
>
> List Width = Auto
>
>
>
> Jika sudah demikian ketika Anda pilih lokasi event afterupdate akan
> berjalan dan akan me REFRESH isi combobox sesuai dengan lokasi nya..
>
> Mudah ga ada yg terlewat ya.. oh iya pastikan field Lokasi di table Data
> Motor mempunyai tipe data yang sama, krn saya liat anda me-link dengan
> ID ditable Lokasi
>
> Tentunya field nya harusnya Number ya.. J
>
>
>
> Ok smoga sukses ya..
>
>
>
> #33526 From: "Krishna" <krishna.rusli@...>
> Date: Sat Jan 28, 2012 10:41 am
> Subject: Re: bingung mengenai combo box di Ms.Access krishna_h_aries
> Offline
> Send Email
>
> wow..
> thx gan ^_^
>
> jd bisa ya
>
> "Row Source diisi SELECT ID, Lokasi From Data Motor Where Lokasi = &
> Forms!NamaForm!Lokasi", yang keluar di form HAR(/form "cucu"nya), yg
> keluar NAMA MOTOR??
> (gak ada select NAMA_MOTOR) lho.. :D..
>
> apa karena pengaruh "Column Count = 2"??
> sory nubi kali.. masih bingung soal query2an.. sifat2nya.. hehe.. *ada
> referensi ga, yg bs kubaca mengenai sifat2 query.. ^_^ *
> (sambil kucoba dulu. hehe..)
>
>
> well..
> 1 pertanyaan lagi.. ya ya ya?? :P
> aku ada buat form "datasheet"(berbentuk table) dari sebuah table..
> tujuan datasheet hanya untuk melihat list2 barang2 yg ada *editnya ku
> matikan* / read only..
>
> ada 1 buah combobox, dr table tersebut, yg kuganti jadi textbox.. (toh
> HANYA untuk melihat saja..)
> tp kok yg keluar di form datasheet tersebut ID nya ya, bukan NAMA nya??
>
> trims sudah meladeni pertanyaan nubi kek gini..
> hahaha..
>
>
>
>
>
> On 2/23/2012 5:08 PM, Chubby Mike wrote:
> >
> > Dear all,
> >
> > bukannya saya ga mau cari, tapi saya bingung kategori apa yg mau saya
> > search. sudah coba cari2 tapi ga ngerti2
> >
> > begini
> > tabel A
> >
> > Channel Product Nama
> > PL Prem Mick
> > CC Corp James
> > CC Prem Rob
> > PL Comm Jamie
> >
> > jika dalam form saya taruh 3 combo box, bagaimana cara membuat memilih
> > dari Channel dulu, kemudian combobox2 selanjutnya akan memilah2 data
> >
> > contoh :
> > jika channel kita pilih PL, maka di product akan muncul Prem & Comm,
> > jika kita pilih Prem, maka combobox Nama hanya muncul Mick.
> >
> > maaf kalau berbelit2, baru belajar seminggu. thanks in advance
> >
> >
>

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

RE: [MS_AccessPros] Re: leading or trailing spaces/characters??

 

Chr(51) is the number 3, which is what you would expect in a field containing
"MC63".

What does Asc(Left(ID, 1)) return?

Also, open the table in Datasheet view, select the row containing MC63, copy it
to the clipboard, then paste it into a reply.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Wednesday, February 29, 2012 5:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

That returns 51.
Thanks

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...>
wrote:
>
> ...and also:
>
> Asc(Right(ID,1))
>
> Best wishes
> Graham [Access MVP 1996-2012]
>
> > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > Sent: Thursday, 1 March 2012 11:38
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> >
> >  
> > What are the results from:
> >
> > Len(Trim(ID))
> >
> > Len(ID)
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> wrote:
> > >
> > > I can't figure this out.
> > >
> > > select id from table where id = "mc63" does not work
> > > select id from table where id like "*mc63*" does
> > >
> > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > >
> > > Any assistance would be greatly appreciated!
> > >
>

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

[MS_AccessPros] Re: leading or trailing spaces/characters??

 

That returns 51.
Thanks

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> ...and also:
>
> Asc(Right(ID,1))
>
> Best wishes
> Graham [Access MVP 1996-2012]
>
> > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > Sent: Thursday, 1 March 2012 11:38
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> >
> >  
> > What are the results from:
> >
> > Len(Trim(ID))
> >
> > Len(ID)
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> wrote:
> > >
> > > I can't figure this out.
> > >
> > > select id from table where id = "mc63" does not work
> > > select id from table where id like "*mc63*" does
> > >
> > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > >
> > > Any assistance would be greatly appreciated!
> > >
>

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] Re: leading or trailing spaces/characters??

 

...and also:

Asc(Right(ID,1))

Best wishes
Graham [Access MVP 1996-2012]

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> Sent: Thursday, 1 March 2012 11:38
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
>
>  
> What are the results from:
>
> Len(Trim(ID))
>
> Len(ID)
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@...>
wrote:
> >
> > I can't figure this out.
> >
> > select id from table where id = "mc63" does not work
> > select id from table where id like "*mc63*" does
> >
> > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> >
> > Any assistance would be greatly appreciated!
> >


__._,_.___
Recent Activity:
.

__,_._,___

[MS_AccessPros] Re: leading or trailing spaces/characters??

 

Well, this is interesting! For the MC63 value, both returned 10. Why would that be?
Thanks,
Elizabeth

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> What are the results from:
>
> Len(Trim(ID))
>
> Len(ID)
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@> wrote:
> >
> > I can't figure this out.
> >
> > select id from table where id = "mc63" does not work
> > select id from table where id like "*mc63*" does
> >
> > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> >
> > Any assistance would be greatly appreciated!
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Re: [MS_AccessPros] leading or trailing spaces/characters??

 

Yes, this is an Access table and I tried the trim. In datasheet view I see just MC63 in the field- no other characters. Other values in this field are acting normal (i.e. select id from table where id = "mc55")
In datasheet view, if I use the Find and put
Find What: MC63
Look In: ID
Match: Whole Field
it cannot find the value. If I use Match: Any Part of Field it can find MC 63.

Thanks,
Elizabeth

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Dear glcass- (name?)
>
> If this is an Access table, there should not be any trailing blanks. You could
> try eliminating extraneous blanks by first running:
>
> UPDATE table SET ID = Trim([ID])
>
> After you do that, then id = "mc63" should work as long as it is an exact match.
>
> What do you see in the ID field when you do like "*mc63*" ??
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Wednesday, February 29, 2012 1:17 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] leading or trailing spaces/characters??
>
> I can't figure this out.
>
> select id from table where id = "mc63" does not work
> select id from table where id like "*mc63*" does
>
> I tried Trim([id]) and Replace([id]," ","") but they did not help.
>
> Any assistance would be greatly appreciated!
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

 

Hendra-

Partly correct. Leave record-level locking turned on.

Here's what will happen when two users try to change the same record:

1) User A will find the record and start to edit it. This sets a timestamp locally.

2) User B will find the same record, edit it, and save. The save sets a timestamp of the time of the save.

3) User A (who went to get a cup of coffee after starting to edit) tries to save.

Result: Access will see that someone else has updated the record since A started to edit. User A will get a warning message with an option to either discard the changes A just tried to make or copy the changes to the clipboard. User A *cannot* overwrite what B just did. You can use the Form_Error event to trap this case and issue a custom message that forces the user to start over.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Wednesday, February 29, 2012 2:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Thanx John...

No Lock setting (is setted on the form ...right?)... is that the same way to unchek "Open Database using record locking"..?
Then if we set all of the form properties to "No Lock", what will happen if more than one users edit the same record in the same time..?..(i can't imagine it)

________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Rabu, 29 Februari 2012 23:49
Judul: RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)


Hendra-

Unless you have dozens of simultaneous users, the chance of a "collision" editing records is very very low. As long as you have No Locks set, you should have no problems with bound forms.

Important notes:

1) Users should NOT try to share a database over a wireless connection.

2) Users should share only the "data" database on a server - a database with the tables only. Each user should have his or her own copy of the "code" database (linked tables to the shared data, queries, forms, reports, and code).

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Tuesday, February 28, 2012 5:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Thanx John...
Yes..that is what i am thinking...why do we choose the harder way if Access give the simpler way.?..
But the other side i am thinking to about the table's burden (..is the word "burden" right?..sorry if not)..
I mean with the bound form, users are access directly to table at the same time (especially with UPDATE processing)..
so with that opinion i think unbound form is better because it's not access the table directly and no connection to the table happened
until we run the INSERT or UPDATE command.
But in several articles i've read that sometimes Inserting or Updating with codes give slowly processing especially in wireless connection..
Please give me more explanation because i am developing my first multi user application,,so i have to decide the best methods from beginning
Regards
Hendra

________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Rabu, 29 Februari 2012 8:26
Judul: RE: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert Into)

Hendra-

If you use unbound forms, you are putting into code what Access will do for you.
Your application will be much more complex and more time-consuming to build.
There is a small advantage to using unbound forms, but a bound form will provide
very satisfactory results, especially if you set Record Locking to No Locks.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Kirkland, WA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Tuesday, February 28, 2012 3:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Bound Form (Data Entry : Yes) Vs Unbound Form (Insert
Into)

Hi All,...

Which is more better in network environment and multi user :
Bound Form (Data Entry : Yes) Or Unbound Form (Insert Into method) ?

Regards
Hendra

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___