Rabu, 31 Juli 2019

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

Please zip all files prior to uploading to Files section.

.

__,_._,___

Selasa, 30 Juli 2019

Re: [MS_AccessPros] Zoom picture

 

hi Youssef,

you can use a click event to show another form with a larger picture.

Alternately, if it is an external file, you can use a web browser
control to show it. Then you can use ctrl+ and ctrl- to zoom in and out.

have an awesome day,
crystal

free code you can use in your projects - donations appreciated
https://msaccessgurus.com/code.htm

connect to me, let's build it together
http://www.msaccessgurus.com

On 7/30/2019 5:29 AM, youssef2309@gmail.com [MS_Access_Professionals] wrote:
> I have a form that view picture how can I make zoom picture
>
> ------------------------------------
> Posted by: youssef2309@gmail.com
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>

__._,_.___

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

.

__,_._,___

[MS_AccessPros] Re: Zoom picture

 

You can take the approach that a lot of web sites do. create another form with just the image control on it. Use the double-click event to open that new form with the image control's source being the one in the original image control.


Are you storing the image in the database or are you just storing the path to the image?


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

I have a form that view picture how can I make zoom picture

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

[MS_AccessPros] Zoom picture

 

I have a form that view picture how can I make zoom picture

__._,_.___

Posted by: youssef2309@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Senin, 29 Juli 2019

Re: [MS_AccessPros] Crosstab Queries

 

There is a dynamic crosstab report example in our group's files section under 1_Samples. Look for "CrosstabReport.zip". IMO, this is the best solution for creating reports from crosstabs when the values and number of columns is not known at run time.

Regards,
Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 29, 2019 2:03 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Crosstab Queries
 


Please figure out how to include the previous messages with your reply. 

So there is a report involved in your question. Dynamic headings in reports can be an issue. Your crosstab uses the Column Headings property ( In ("CR65.A7","KU65.A7") ). This is why the column headings don't change when you change the filter.

If you remove the In () clause your report will break. There are solutions but they involve writing VBA code. I much prefer the method that creates an alias for each column heading value like "A", "B","C", "D",... The MdlCd  values are appended to a table and given values of A through whatever. Your report is built from the A through whatever columns.

Regards,
Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 29, 2019 1:45 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Crosstab Queries
 


this is the SQL statement

PARAMETERS [Forms].[Frm_PartsMasterLots].[SelectedModel] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedAssyItem] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedPN] Text ( 255 );
TRANSFORM Sum(Qry_PageCrosstab_Xs_S2.QtyPerCar) AS SumOfQtyPerCar
SELECT Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode
FROM Qry_PageCrosstab_Xs_S2
WHERE (((Qry_PageCrosstab_Xs_S2.TheSelectedLot) Between [AssyItemStartLot] And [AssyItemEndLot]))
GROUP BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode, Qry_PageCrosstab_Xs_S2.AssyItemStartLot, Qry_PageCrosstab_Xs_S2.AssyItemEndLot
ORDER BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo
PIVOT Qry_PageCrosstab_Xs_S2.MdlCd In ("CR65.A7","KU65.A7");

the a/m query is ready by a report so the column heading is fixed 
so, how can these model code ("CR65.A7","KU65.A7") as a column heading automatically changed when i choose a different SERIES

thanks in advance





__._,_.___

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

SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Crosstab Queries

 

Please figure out how to include the previous messages with your reply. 

So there is a report involved in your question. Dynamic headings in reports can be an issue. Your crosstab uses the Column Headings property ( In ("CR65.A7","KU65.A7") ). This is why the column headings don't change when you change the filter.

If you remove the In () clause your report will break. There are solutions but they involve writing VBA code. I much prefer the method that creates an alias for each column heading value like "A", "B","C", "D",... The MdlCd  values are appended to a table and given values of A through whatever. Your report is built from the A through whatever columns.

Regards,
Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 29, 2019 1:45 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Crosstab Queries
 


this is the SQL statement

PARAMETERS [Forms].[Frm_PartsMasterLots].[SelectedModel] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedAssyItem] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedPN] Text ( 255 );
TRANSFORM Sum(Qry_PageCrosstab_Xs_S2.QtyPerCar) AS SumOfQtyPerCar
SELECT Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode
FROM Qry_PageCrosstab_Xs_S2
WHERE (((Qry_PageCrosstab_Xs_S2.TheSelectedLot) Between [AssyItemStartLot] And [AssyItemEndLot]))
GROUP BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode, Qry_PageCrosstab_Xs_S2.AssyItemStartLot, Qry_PageCrosstab_Xs_S2.AssyItemEndLot
ORDER BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo
PIVOT Qry_PageCrosstab_Xs_S2.MdlCd In ("CR65.A7","KU65.A7");

the a/m query is ready by a report so the column heading is fixed 
so, how can these model code ("CR65.A7","KU65.A7") as a column heading automatically changed when i choose a different SERIES

thanks in advance



__._,_.___

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

SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Crosstab Queries

 

this is the SQL statement


PARAMETERS [Forms].[Frm_PartsMasterLots].[SelectedModel] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedAssyItem] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedPN] Text ( 255 );
TRANSFORM Sum(Qry_PageCrosstab_Xs_S2.QtyPerCar) AS SumOfQtyPerCar
SELECT Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode
FROM Qry_PageCrosstab_Xs_S2
WHERE (((Qry_PageCrosstab_Xs_S2.TheSelectedLot) Between [AssyItemStartLot] And [AssyItemEndLot]))
GROUP BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode, Qry_PageCrosstab_Xs_S2.AssyItemStartLot, Qry_PageCrosstab_Xs_S2.AssyItemEndLot
ORDER BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo
PIVOT Qry_PageCrosstab_Xs_S2.MdlCd In ("CR65.A7","KU65.A7");

the a/m query is ready by a report so the column heading is fixed 
so, how can these model code ("CR65.A7","KU65.A7") as a column heading automatically changed when i choose a different SERIES

thanks in advance

__._,_.___

Posted by: youssef2309@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Crosstab Queries

 

Hi youssef2309,

Please include the previous emails in the thread when you reply so we don't lose important information.

You didn't provide the SQL view as asked. 

How are you filtering the crosstab? Typically if you change the filter, the column headings will automatically adjust to the new dataset. We would need to know what you are doing that this is not happening.

Regards,
Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 29, 2019 12:24 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Crosstab Queries
 



Series Model ID P/N Qty/Car
G02 UJ35.A7 9909275 4.00
G05 CR65.A7 7140850 2.00
G05 JU45.A7 7468919 4.00
G07 CX65.A7 7256142 4.00
G01 KJ95.A7 9149652 2.00
G01 KJ55.A7 8491745 1.00
G30 JR35.A7 8491746 1.00
G12 7T25.A0 8170298 2.00
G02 UJ35.A7 9905911 2.00
G05 CR65.A7 7465017 2.00
G05 JU45.A7 7469254 6.00

a/m is a sample of my table
I use field SERIES to filter needed records
then create crosstab query as following shape
EX: If I filtered for G05 I will get the next crosstab results

P/N CR65.A7 JU45.A7
-------------------------------------------------------
7140850 2 0
7468919 0 4
7465017 2 0
7469254 0 6

so, how can these column header (CR65.A7) and (JU45.A7) changed when I select another SERIES

your quick response will be highly appreicated


__._,_.___

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)

SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Crosstab Queries

 


Series Model ID P/N Qty/Car
G02 UJ35.A7 9909275 4.00
G05 CR65.A7 7140850 2.00
G05 JU45.A7 7468919 4.00
G07 CX65.A7 7256142 4.00
G01 KJ95.A7 9149652 2.00
G01 KJ55.A7 8491745 1.00
G30 JR35.A7 8491746 1.00
G12 7T25.A0 8170298 2.00
G02 UJ35.A7 9905911 2.00
G05 CR65.A7 7465017 2.00
G05 JU45.A7 7469254 6.00

a/m is a sample of my table
I use field SERIES to filter needed records
then create crosstab query as following shape
EX: If I filtered for G05 I will get the next crosstab results

P/N CR65.A7 JU45.A7
-------------------------------------------------------
7140850 2 0
7468919 0 4
7465017 2 0
7469254 0 6

so, how can these column header (CR65.A7) and (JU45.A7) changed when I select another SERIES

your quick response will be highly appreicated

__._,_.___

Posted by: youssef2309@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

SPONSORED LINKS
.

__,_._,___