Selasa, 19 Juni 2018

[MS_AccessPros] Problem with SQL backend access frontend using table source as value list for form that calculates cost

 

Good afternoon, I really hope you all can help me resolve an issue I am having.  I recently migrated an access database to a SQL backend and an access front end.  In the original access database I had a form with a subform that calculates the costing for a service.  Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table.  Now I can’t add records through the subform or the main form with the subform activated.  I think it must have something to do with the relationship between the tables, but I can’t get them to be a one-to-many and I have tried all the usual suspects for error trapping.  What is a not so obvious reason for not linking correctly? 

 

Marybeth

 

Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL       
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone

www.utexas.edu/cola/tarl/
www.texasbeyondhistory.net

State Certified Repository

 

__._,_.___
Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>
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:

Jumat, 15 Juni 2018

[MS_AccessPros] Re:

 

Testing or did you hit the submit button too soon.  :O)


Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



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

 

__._,_.___
Posted by: wrmosca@comcast.net
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:

RE: [MS_AccessPros] Re: Format in iif statement in query

 

Yes. That'll do. ;-)

It's working. Have a fantastic weekend Bill.

Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, June 15, 2018 7:40 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Format in iif statement in query



Hi Liz - Is this what you are looking for?

Format([myDecimal],"0.00%")

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Pros, I want to put the numeric values in percentage or at least rounded by 2 and multiplied by 100 and get this only where the long decimals are have percentages.

Summary

SumOfSSCostPlusFreight

SumOfProjectCostPlusFreight

SumOfTotalProjectSavingsThisSupplier

FirstOfLeadTimeWeeks

Reduction

53926.93

2804200.36

0

Benchmark

43461.54

2260008.14

544192.22

2

0.1940632444680236757404881012

31674.94

1647105.74

1157094.62

10

0.4126290818962736314604852272


Here' s my SQL with the Supplier not showing for privacy reasons.

SELECT SummaryWOReduction.Supplier, SummaryWOReduction.SumOfSSCostPlusFreight, SummaryWOReduction.SumOfProjectCostPlusFreight, SummaryWOReduction.SumOfTotalProjectSavingsThisSupplier, SummaryWOReduction.FirstOfLeadTimeWeeks, IIf([Supplier]="Current","Benchmark",(DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")-[SumOfProjectCostPlusFreight])/DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")) AS Reduction
FROM SummaryWOReduction;

Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>>
rockwellcollins.com<http://www.rockwellcollins.com/>



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


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








This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

__._,_.___
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.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.

.

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

[MS_AccessPros]

 

__._,_.___
Posted by: John Clark <nauticalgent@gmail.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:

[MS_AccessPros] Re: Format in iif statement in query

 

Hi Liz - Is this what you are looking for?


Format([myDecimal],"0.00%")

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



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

Pros, I want to put the numeric values in percentage or at least rounded by 2 and multiplied by 100 and get this only where the long decimals are have percentages.

Summary

SumOfSSCostPlusFreight

SumOfProjectCostPlusFreight

SumOfTotalProjectSavingsThisSupplier

FirstOfLeadTimeWeeks

Reduction

53926.93

2804200.36

0

Benchmark

43461.54

2260008.14

544192.22

2

0.1940632444680236757404881012

31674.94

1647105.74

1157094.62

10

0.4126290818962736314604852272


Here' s my SQL with the Supplier not showing for privacy reasons.

SELECT SummaryWOReduction.Supplier, SummaryWOReduction.SumOfSSCostPlusFreight, SummaryWOReduction.SumOfProjectCostPlusFreight, SummaryWOReduction.SumOfTotalProjectSavingsThisSupplier, SummaryWOReduction.FirstOfLeadTimeWeeks, IIf([Supplier]="Current","Benchmark",(DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")-[SumOfProjectCostPlusFreight])/DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")) AS Reduction
FROM SummaryWOReduction;

Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


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

 

__._,_.___
Posted by: wrmosca@comcast.net
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:

Selasa, 12 Juni 2018

[MS_AccessPros] Format in iif statement in query

 

Pros, I want to put the numeric values in percentage or at least rounded by 2 and multiplied by 100 and get this only where the long decimals are have percentages.

Summary

SumOfSSCostPlusFreight

SumOfProjectCostPlusFreight

SumOfTotalProjectSavingsThisSupplier

FirstOfLeadTimeWeeks

Reduction

53926.93

2804200.36

0

Benchmark

43461.54

2260008.14

544192.22

2

0.1940632444680236757404881012

31674.94

1647105.74

1157094.62

10

0.4126290818962736314604852272

Here' s my SQL with the Supplier not showing for privacy reasons.

SELECT SummaryWOReduction.Supplier, SummaryWOReduction.SumOfSSCostPlusFreight, SummaryWOReduction.SumOfProjectCostPlusFreight, SummaryWOReduction.SumOfTotalProjectSavingsThisSupplier, SummaryWOReduction.FirstOfLeadTimeWeeks, IIf([Supplier]="Current","Benchmark",(DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")-[SumOfProjectCostPlusFreight])/DSum("SumOfProjectCostPlusFreight","SummaryWOReduction","Supplier='Current'")) AS Reduction
FROM SummaryWOReduction;

Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

__._,_.___
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.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:

Jumat, 01 Juni 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 (136)
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:
Langganan: Postingan (Atom)