Senin, 30 April 2018

[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 (135)

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

.

__,_._,___

[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 (166)

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.

.

__,_._,___

Selasa, 24 April 2018

Re: [MS_AccessPros] Fitler out split accounts in a query

 

Duane,

Thank You, that was the answer. I do not know why I did not think of that.

Jim Wagner


On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎04‎:‎17‎:‎09‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim,

From what fields you have shown us, I can only suggest a simple totals query:


SELECT [Pos Nbr], Max([Dist Pct]) as DistPct

FROM [It Looks Like This]

GROUP BY [Pos Nbr];


If you want/need more information, you should provide more information.


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 5:05 PM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Fitler out split accounts in a query
 


Duane,

it looks like this
pos nbr        Dist Pct
111111            100?
222222            100%
333333            75%
333333            25%
444444            70%
444444            30%

My boss does not care which record is showing. 50/50 does not matter either. the highest would be good.. It does need to be in the query though. She is trying to make things easier for her. She takes a table and puts it in excel and then does all of the polishing and pruning the way she likes it. But she is tired of doing all of the work and asked if I could make it more automatic. She does a number of steps to get the look she wants

Here are her steps below

  1. delete 2 specific columns
  2. sort by title
  3. Filter out students
  4. filter out certain position numbers
  5. add conditional formatting
  6. delete more columns
  7. change the order of the columns
  8. copy data to excel.

But a query can do this easier. I figured I would put it in a continuous form to add the conditional formatting after getting the data.


Jim Wagner


On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎02‎:‎49‎:‎49‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim,


What does your data look like? How are you storing the split accounts? I assume these are multiple records in an Employee Splits table.


When you say "show one of the records", which one? Do you always want to show the highest split? What if it's 50/50?


Can you provide some sample records and desired display?


Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 4:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fitler out split accounts in a query
 


Hello all,


I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?


Thank You So Much for your help.


Jim Wagner





__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.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.


.

__,_._,___

Re: [MS_AccessPros] Fitler out split accounts in a query

 

Jim,

From what fields you have shown us, I can only suggest a simple totals query:


SELECT [Pos Nbr], Max([Dist Pct]) as DistPct

FROM [It Looks Like This]

GROUP BY [Pos Nbr];


If you want/need more information, you should provide more information.


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 5:05 PM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Fitler out split accounts in a query
 


Duane,

it looks like this
pos nbr        Dist Pct
111111            100?
222222            100%
333333            75%
333333            25%
444444            70%
444444            30%

My boss does not care which record is showing. 50/50 does not matter either. the highest would be good.. It does need to be in the query though. She is trying to make things easier for her. She takes a table and puts it in excel and then does all of the polishing and pruning the way she likes it. But she is tired of doing all of the work and asked if I could make it more automatic. She does a number of steps to get the look she wants

Here are her steps below

  1. delete 2 specific columns
  2. sort by title
  3. Filter out students
  4. filter out certain position numbers
  5. add conditional formatting
  6. delete more columns
  7. change the order of the columns
  8. copy data to excel.

But a query can do this easier. I figured I would put it in a continuous form to add the conditional formatting after getting the data.


Jim Wagner


On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎02‎:‎49‎:‎49‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim,


What does your data look like? How are you storing the split accounts? I assume these are multiple records in an Employee Splits table.


When you say "show one of the records", which one? Do you always want to show the highest split? What if it's 50/50?


Can you provide some sample records and desired display?


Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 4:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fitler out split accounts in a query
 


Hello all,


I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?


Thank You So Much for your help.


Jim Wagner





__._,_.___

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.


.

__,_._,___

Re: [MS_AccessPros] Fitler out split accounts in a query

 

Duane,

it looks like this
pos nbr        Dist Pct
111111            100?
222222            100%
333333            75%
333333            25%
444444            70%
444444            30%

My boss does not care which record is showing. 50/50 does not matter either. the highest would be good. It does need to be in the query though. She is trying to make things easier for her. She takes a table and puts it in excel and then does all of the polishing and pruning the way she likes it. But she is tired of doing all of the work and asked if I could make it more automatic. She does a number of steps to get the look she wants

Here are her steps below

  1. delete 2 specific columns
  2. sort by title
  3. Filter out students
  4. filter out certain position numbers
  5. add conditional formatting
  6. delete more columns
  7. change the order of the columns
  8. copy data to excel.

But a query can do this easier. I figured I would put it in a continuous form to add the conditional formatting after getting the data.


Jim Wagner


On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎02‎:‎49‎:‎49‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim,


What does your data look like? How are you storing the split accounts? I assume these are multiple records in an Employee Splits table.


When you say "show one of the records", which one? Do you always want to show the highest split? What if it's 50/50?


Can you provide some sample records and desired display?


Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 4:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fitler out split accounts in a query
 


Hello all,


I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?


Thank You So Much for your help.


Jim Wagner



__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.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.


.

__,_._,___

Re: [MS_AccessPros] Fitler out split accounts in a query

 

Jim,


What does your data look like? How are you storing the split accounts? I assume these are multiple records in an Employee Splits table.


When you say "show one of the records", which one? Do you always want to show the highest split? What if it's 50/50?


Can you provide some sample records and desired display?


Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 4:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fitler out split accounts in a query
 


Hello all,


I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?


Thank You So Much for your help.


Jim Wagner



__._,_.___

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 (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.


.

__,_._,___

[MS_AccessPros] Fitler out split accounts in a query

 

Hello all,


I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?


Thank You So Much for your help.


Jim Wagner

__._,_.___

Posted by: luvmymelody@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.


.

__,_._,___

Re: [MS_AccessPros] Re: Cannot delete a record in a subform

 

Art,

You haven't provided the SQL view of your subform's record source so as suggested, you should write code to run a delete query and then requery your subform. 


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, April 23, 2018 10:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Cannot delete a record in a subform
 


Where do I find that at? But I think its my query that my subform is using that is presenting the issue. I will have to pull up a detail screen and then delete it from there.



__._,_.___

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 (19)

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.


.

__,_._,___

[MS_AccessPros] Re: Cannot delete a record in a subform

 

If you are using the web interface and click "Reply to this message" there is a link "> Show message history" at the bottom left above the Send button.


Duane


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

Where do I find that at? But I think its my query that my subform is using that is presenting the issue. I will have to pull up a detail screen and then delete it from there.

__._,_.___

Posted by: duanehookom@hotmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (18)

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.


.

__,_._,___

Senin, 23 April 2018

[MS_AccessPros] Re: Cannot delete a record in a subform

 

Where do I find that at? But I think its my query that my subform is using that is presenting the issue. I will have to pull up a detail screen and then delete it from there.

__._,_.___

Posted by: dbalorenzini@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (17)

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.


.

__,_._,___