Senin, 29 Juni 2015

Re: [MS_AccessPros] Access 2007 books with large print

 

you're welcome, Russ

here is a video that will show you what to do with the customization file, and why it is good:

https://www.youtube.com/watch?v=norAB9QvIls&list=PL1B2705CCB40CA4CA&index=8

it is part of a series ... you may want to watch the other videos too ~

Warm Regards,
Crystal

~ have an awesome day ~


On 6/29/2015 9:23 PM, 'Russell Farris' russ@russfarris.com [MS_Access_Professionals] wrote:
Thanks for all of the information, Crystal. It's good to know that most of the stuff in the 2013 books will still apply.
        I downloaded your 100-page tome and I'm going to have it printed at a FedEx office.
        I also downloaded your QATs, but I'm not sure what to do with them, or if I need them. I dislike the ribbon, but it hasn't really been a problem. I take it that the QATs provide additional options? Russ
 
------ Original Message ------
Sent: 6/27/2015 8:06:58 PM
Subject: Re: [MS_AccessPros] Access 2007 books with large print
 
 

Hi Russ,

Access Basics is on PDF format on Bill Mosca's site, That'll Do it, -- so you can zoom text to a comfortable level for reading.  This is a small book, only 100 pages, and is version independent.  It covers essentials of what you need to know to become a master with Access. 

Bill Mosca's MS Access Tools, Code and Samples

image

Bill Mosca's MS Access Tools, Code and Samples

View on www.ThatllDoit.com
Preview by Yahoo



Obviously, this only has a fraction of the information in the Inside Out books, which are great.  I have them for every version of Access since 2007 -- in fact, that book is what gave me comfort to dive into 2007.  Amazing how lost one can feel when nothing seems familiar ... but there it was, the great Access I came to love, just in a different wrapper.

Microsoft has a number of articles on MSDN.   I don't see the link for the index to 2007, but not much has changed since then on the desktop ... each version, the ribbons change colors and the icons move around a bit but, in my opinion, the best way to use the ribbon versions is with a good QAT (Quick Access Toolbar).  I just uploaded a couple of my QAT customizations to the Files > Crystal section of this forum.

Take a look here for a general staring place on learning about Access via resources on the web that you can zoom (ctrl-MouseWheel):

Office client development | Access, Excel, Word, Outlook, PowerPoint


image

Office client development | Access, Excel, Word, Outlo...
Find in-depth developer resources, API references, how-to documentation, training, videos, code samples, and SDKs for Office, Office 365, and apps for Off...
View on msdn.microsoft.com
Preview by Yahoo

 

I suggest learning using 2013 resources -- most everything you read applies to 2007 too, and you won't learn about what has been depreciated.

A good starting point for a serious journey into the capabilities of Access would be to set aside time for studying in your schedule and reading what interests you here:

https://msdn.microsoft.com/EN-US/library/office/ee861519.aspx

 

Access 2013 desktop database reference
https://msdn.microsoft.com/EN-US/library/office/dn142571.aspx

 

To be able to program applications in Access, you must know what it looks like.  Don't skip the Access object model reference.

https://msdn.microsoft.com/EN-US/library/office/ff192120.aspx

 

Good luck in your quest for knowledge ... Access is amazing

Warm Regards,
Crystal

~ have an awesome day ~

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

.

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

Re: [MS_AccessPros] Access 2007 books with large print

 

Thanks for all of the information, Crystal. It's good to know that most of the stuff in the 2013 books will still apply.
        I downloaded your 100-page tome and I'm going to have it printed at a FedEx office.
        I also downloaded your QATs, but I'm not sure what to do with them, or if I need them. I dislike the ribbon, but it hasn't really been a problem. I take it that the QATs provide additional options? Russ
 
------ Original Message ------
From: "strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: 6/27/2015 8:06:58 PM
Subject: Re: [MS_AccessPros] Access 2007 books with large print
 
 

Hi Russ,

Access Basics is on PDF format on Bill Mosca's site, That'll Do it, -- so you can zoom text to a comfortable level for reading.  This is a small book, only 100 pages, and is version independent.  It covers essentials of what you need to know to become a master with Access. 

Bill Mosca's MS Access Tools, Code and Samples



Obviously, this only has a fraction of the information in the Inside Out books, which are great.  I have them for every version of Access since 2007 -- in fact, that book is what gave me comfort to dive into 2007.  Amazing how lost one can feel when nothing seems familiar ... but there it was, the great Access I came to love, just in a different wrapper.

Microsoft has a number of articles on MSDN.   I don't see the link for the index to 2007, but not much has changed since then on the desktop ... each version, the ribbons change colors and the icons move around a bit but, in my opinion, the best way to use the ribbon versions is with a good QAT (Quick Access Toolbar).  I just uploaded a couple of my QAT customizations to the Files > Crystal section of this forum.

Take a look here for a general staring place on learning about Access via resources on the web that you can zoom (ctrl-MouseWheel):

Office client development | Access, Excel, Word, Outlook, PowerPoint

 

I suggest learning using 2013 resources -- most everything you read applies to 2007 too, and you won't learn about what has been depreciated.

A good starting point for a serious journey into the capabilities of Access would be to set aside time for studying in your schedule and reading what interests you here:

https://msdn.microsoft.com/EN-US/library/office/ee861519.aspx

 

Access 2013 desktop database reference
https://msdn.microsoft.com/EN-US/library/office/dn142571.aspx

 

To be able to program applications in Access, you must know what it looks like.  Don't skip the Access object model reference.

https://msdn.microsoft.com/EN-US/library/office/ff192120.aspx

 

Good luck in your quest for knowledge ... Access is amazing

Warm Regards,
Crystal

~ have an awesome day ~

__._,_.___
Posted by: "Russell Farris" <russ@russfarris.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (9)

.

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

[MS_AccessPros] Re: Question on form data source

 

John, That worked like a charm.  Thanks a real learning process.
Rod

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Rod-

I'm assuming you want to apply a filter on userid when you open the form.  You can do it one of two ways:

1) Apply a filter like this:

   lngTaxPayerID IN (SELECT lngTaxPayerID FROM tblprojects WHERE userid = <substitute userid no here>)

2) Use a query on both tbltaxpayer and tblprojects and apply the filter on the userid in tblprojects.  You should still be able to update the tbltaxpayer fields.

I personally prefer the first method because it makes it clear what you are doing.

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 
http://www.viescas.com/ 
(Paris, France)




On Jun 28, 2015, at 11:52 PM, desertscroller@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a form (frmTaxPayerDialog) which has a parent plus 7 subforms.  The issue is the client wants one of the parent controls moved to one of the subforms but still filter the data on the parent using the moved control.  The parent  and the subforms have a field (lngTaxpayerID) in common.  The field moved was the userid.  The userid needs to be part of the project subform (tblprojects) verses the main taxpayer form (tbltaxpayer).  Originally the userid (database user) was assigned based on the taxpayer but now several user working on different projects need access to the taxpayer.  My question is if changing the parent form data source from the tbltaxpayer to a query which links the data from the tblproject (userid field) to the tbltaxpayer still update the fields in the tbltaxpayer when moving to a different record on the form.  The userid will not be listed on the parent form only on the projects form.

The main reason is to limit the user to those taxpayers associated with the user's projects.  Multiple users may be process taxpayers for a given project.

Hope I presented the issue clearly.  Using Win 7 & 8.1 with Access 2010.

Rod



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

.

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

Re: [MS_AccessPros] Access 2007 books with large print

 

Thanks, John. I'll look for a book with a  PDF.
 
------ Original Message ------
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: 6/28/2015 1:18:32 AM
Subject: Re: [MS_AccessPros] Access 2007 books with large print
 
 

Russ-


All the "major" books about Access come with an electronic edition on the companion CD or available for download.  The electronic edition is usually a PDF file.

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 
http://www.viescas.com/ 
(Paris, France)




On Jun 28, 2015, at 5:06 AM, strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi Russ,

Access Basics is on PDF format on Bill Mosca's site, That'll Do it, -- so you can zoom text to a comfortable level for reading.  This is a small book, only 100 pages, and is version independent.  It covers essentials of what you need to know to become a master with Access. 

Bill Mosca's MS Access Tools, Code and Samples

Obviously, this only has a fraction of the information in the Inside Out books, which are great.  I have them for every version of Access since 2007 -- in fact, that book is what gave me comfort to dive into 2007.  Amazing how lost one can feel when nothing seems familiar ... but there it was, the great Access I came to love, just in a different wrapper.

Microsoft has a number of articles on MSDN.   I don't see the link for the index to 2007, but not much has changed since then on the desktop ... each version, the ribbons change colors and the icons move around a bit but, in my opinion, the best way to use the ribbon versions is with a good QAT (Quick Access Toolbar).  I just uploaded a couple of my QAT customizations to the Files > Crystal section of this forum.

Take a look here for a general staring place on learning about Access via resources on the web that you can zoom (ctrl-MouseWheel):

Office client development | Access, Excel, Word, Outlook, PowerPoint

 

I suggest learning using 2013 resources -- most everything you read applies to 2007 too, and you won't learn about what has been depreciated.

A good starting point for a serious journey into the capabilities of Access would be to set aside time for studying in your schedule and reading what interests you here:

https://msdn.microsoft.com/EN-US/library/office/ee861519.aspx

 

Access 2013 desktop database reference
https://msdn.microsoft.com/EN-US/library/office/dn142571.aspx

 

To be able to program applications in Access, you must know what it looks like.  Don't skip the Access object model reference.

https://msdn.microsoft.com/EN-US/library/office/ff192120.aspx
 
Good luck in your quest for knowledge ... Access is amazing

Warm Regards,
Crystal

~ have an awesome day ~

__._,_.___
Posted by: "Russell Farris" <russ@russfarris.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (8)

.

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

[belajar-access] hallo...

 

dear all,
Hallo belajar-access...
gimana kabarnya para senior ; bang Haer, bang Edi, bang akses, engkong Lusky dll....
millist ini masih aktif nggak ya ??
 
Regards

Harry Siswanto

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

[belajar-access] [ASK] Combo Box: Bagaimana Cara Menampilkan List data tanpa double? [2 Attachments]

 
[Attachment(s) from Kane Kostya kanekostya@yahoo.com [belajar-access] included below]

Selamat pagi teman2 sekalian…
Perkenalkan saya Casnov, saya masih awam dalam hal penggunaan database Ms. Access. Dalam hal ini saya mau minta berbagi informasi tentang penggunaan "Combo Box". Saya sedang membuat database kepegawaian, di bagian penginputan data instansi saya menggunakan "Combo Box" supaya nama instansi yang sudah ada tinggal dipilih tidak perlu diketik lagi, tapi jika belum ada nama instansinya kita tinggal ketik nama instansi baru. Permasalahannya muncul, ketika "Instansi A" sudah ada beberapa orang, maka list di Combo Box nya menampilkan lebih dari satu "Instansi A" (sebanyak jumlah "Instansi A" yang ada di kolom Instansi).

Yang saya inginkan, list instansi cukup muncul 1 (satu) item yang mewakili tiap instansi, sehingga list tidak terlalu panjang, disamping itu kita juga bisa menginput instansi baru yang otomatis nantinya akan muncul di combo Box. Contoh penggunaannya bisa kita lihat saat penginputan nama kota tujuan di website tiket maskapai penerbangan, atau di fitur Pencarian seperti rumah123dotcom.

Mungkin saja penyelesaian permasalahan ini sudah ada di fitur propertiesnya, tapi karna saya masih awam saya masih belum mengerti.
Untuk itu mohon bantuan teman-teman untuk mengatasi problem ini. Atas bantuannya saya ucapkan terimakasih.

Catatan:
Berikut saya lampirkan screenshoot permasalahan, dan screenshot yang diinginkan.

__._,_.___

Attachment(s) from Kane Kostya kanekostya@yahoo.com [belajar-access] | View attachments on the web

2 of 2 Photo(s)

Posted by: Kane Kostya <kanekostya@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 2 photo(s) from this topic.
Problem.PNG Like This.PNG
SPAM IS PROHIBITED

.

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