Senin, 02 Februari 2015

Re: [MS_AccessPros] Is there an issue with the ACCESS 2010 Object Model Reference

 

Rod-


Looks like the initial titles are hosed!  If you click on one of those hex garbage links, you'll get to something readable.  For example, if you click on the "e369" link, then click on the first link on that page, you get to:

AccessObject Object (Access)

Office 2010
An AccessObject object refers to a particular Microsoft Access object.

Remarks

An AccessObject object includes information about one instance of an object. The following table list the types of objects each AccessObject describes, the name of its collection, and what type of information AccessObject contains.

You'll just have to explore!

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




On Feb 2, 2015, at 4:14 AM, desertscroller@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good evening all,
I was trying to use the Access 2010 Object Model Reference from Microsoft but all I see are what appears as paragraphs but they are displayed as numbers.  Here is a sample of the display:

Access Object Model Reference
e3696e20-154a-457b-9e3a-44163f2a7653
6674a9d3-fa7e-4115-b775-66795b77fb66
df6f91d5-c83e-4b22-a285-32bf69165ffa


Can determine what is what.  Trying to resolve an issue and trying to verify the property values for a couple of controls.  Looking at Access 2013 everything looks good.
Any suggestions?
Rod

 

__._,_.___
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)

.

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

Minggu, 01 Februari 2015

Re: [MS_AccessPros] Help with issue on using subforms

 

Rod-


It sounds like you're wanting to display the same table in both subforms and selectively apply filters to the two subforms to see if you can find matches.  If that is the case, the outer form should have no Record Source.  You need unbound controls on the outer form where you can enter filter criteria, one for each subform.  You could then enter something like:

LastName = 'Smith'

To do multiple filters, you would need to add the AND keyword and the second filter:

LastName = 'Smith' AND FirstName LIKE 'J%'

.. in the filter box for one or either of the subforms.  In the AfterUpdate event of the filter text box, add code something like:

Private Sub txtFilter1_AfterUpdate()
    ' Attempt to apply what was entered as a filter to the first subform
    Me.Subform1.Form.Filter = Me.txtFilter1
    Me.Subform1.Form.FilterOn = True
End Sub

It would probably also be advisable to add two command buttons - one each to clear the filter you've attempted for each subform.

Private Sub cmdClearFilter1_Click()
    ' Remove the subform filter
    Me.Subform1.Form.FilterOn = False
    Me.Subform1.Form.Filter = ""
End Sub


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




On Feb 2, 2015, at 4:23 AM, desertscroller@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a form that has a data source to a table.  On the form are two subforms, each subform is to be a filtered revision of the main form.  I am trying to compare and correct data that may be duplicated in the main form.
Two users may enter data about the same taxpayer ( one using the tax id and the other using a dummy id).  What to display both records to allow the manage the opportunity to combine the records under the tax id.  In some cases the table may reference multiple data entries.  Examples would be taxpayer having multiple land parcels so all the parcels need to be compared and united as one record per parcel.
Probably to such info.  Having issue setting the filters for each subform.
Rod



__._,_.___
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)

.

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

[MS_AccessPros] Help with issue on using subforms

 

I have a form that has a data source to a table.  On the form are two subforms, each subform is to be a filtered revision of the main form.  I am trying to compare and correct data that may be duplicated in the main form.
Two users may enter data about the same taxpayer ( one using the tax id and the other using a dummy id).  What to display both records to allow the manage the opportunity to combine the records under the tax id.  In some cases the table may reference multiple data entries.  Examples would be taxpayer having multiple land parcels so all the parcels need to be compared and united as one record per parcel.
Probably to such info.  Having issue setting the filters for each subform.
Rod


__._,_.___
Posted by: desertscroller@cox.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

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

[MS_AccessPros] Is there an issue with the ACCESS 2010 Object Model Reference

 

Good evening all,
I was trying to use the Access 2010 Object Model Reference from Microsoft but all I see are what appears as paragraphs but they are displayed as numbers.  Here is a sample of the display:

Access Object Model Reference
e3696e20-154a-457b-9e3a-44163f2a7653
6674a9d3-fa7e-4115-b775-66795b77fb66
df6f91d5-c83e-4b22-a285-32bf69165ffa


Can determine what is what.  Trying to resolve an issue and trying to verify the property values for a couple of controls.  Looking at Access 2013 everything looks good.
Any suggestions?
Rod

 

__._,_.___
Posted by: desertscroller@cox.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

__,_._,___
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 (95)
SPAM IS PROHIBITED

.

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

[belajar-access] Fwd: Dao atau ado_nambah tanya

 

Dear all,
Langsung ke point aja, kami ada pertanyaan sbb:
1. Bisakah data dari tabel lain database ms access dibaca ke continous form ? Dari googling hal ini bisa tetapi dengan metode link atau data diimport dahulu ke access yg aktif.
Sedangkan yg kami maksud adalah:
Connect ke database lain-baca isi tabel dalam continous form-disconnect dari sumber database.
Jika bisa bagaimanakah caranya ?
2.Untuk membaca data dari lain database dalam jaringan LAN metode apakah yg paling baik?ADO ataukah DAO?
3.Pada saat menggunakan metode ADO untuk menampilkan data pada subform dan recordset sudah diclose dan diset nothing,demikian pula untuk koneksinya,tetapi pada data sumber koq masih tampil ldb-nya yah?apakah berati masi terkoneksi dgn data sumber?

Demikian pertanyaan ini kami sampaikan.
Atas bantuan pencerahannya kami ucapkan terima kasih.

Salam,
Heru w

---------- Forwarded message ----------
From: "Heru Wibowo" <heru.wibowo4456@gmail.com>
Date: 30 Jan 2015 19:51
Subject: Dao atau ado
To: "Belajar Access" <belajar-access@yahoogroups.com>
Cc:

Dear all,
Langsung ke point aja, kami ada pertanyaan sbb:
1. Bisakah data dari tabel lain database ms access dibaca ke continous form ? Dari googling hal ini bisa tetapi dengan metode link atau data diimport dahulu ke access yg aktif.
Sedangkan yg kami maksud adalah:
Connect ke database lain-baca isi tabel dalam continous form-disconnect dari sumber database.
Jika bisa bagaimanakah caranya ?
2.Untuk membaca data dari lain database dalam jaringan LAN metode apakah yg paling baik?ADO ataukah DAO?
Demikian pertanyaan ini kami sampaikan.
Atas bantuan pencerahannya kami ucapkan terima kasih.

Salam,
Heru W

__._,_.___
Posted by: Heru Wibowo <heru.wibowo4456@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
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 (127)

Please zip all files prior to uploading to Files section.

.

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