Rabu, 31 Desember 2014

RE: [MS_AccessPros] Re: Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

John,
I tried the spacing in Access 2010 and it didn't work if the controls were on a tab control. I cut them and pasted onto the form and then the spacing did work. I expect there is an issue with 2010 and tab controls. Dirk just answered a question on some forum about the custom shortcut keys not working if a control was on a tab. Apparently that functionality was munged in Access 2010.
 
Duane Hookom MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 31 Dec 2014 16:20:39 +0100
Subject: Re: [MS_AccessPros] Re: Equal vertical spacing doesn't work in tabbed forms in MS Access 2013



John-

I had no problem applying any of the commands on the Arrange tab.  Are the controls in a Layout?

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 Dec 31, 2014, at 4:13 PM, jfakes@rocketmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Bill,
I thought about that, I was hoping there was a fix.
 
John V,
No subform on the tabs just have the fields broken down logically on different tabs.
 
John F.




__._,_.___

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)

.

__,_._,___

RE: [MS_AccessPros] Query design question

 

When you have just a single flat data source, and no stated need for complex calculations on that table, Power pivot seems an unnecessary complication. You have to have the data in a table, not just a few columns, which Boris may not have (a good idea to do anyway, but may not be the case), and then you have to load Power Pivot so as to output it to a pivot table when you could pivot directly from the original data – no need for the intermediate loading step.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: 31 December 2014 19:40
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Query design question

 

 

If you want to do this in Excel, you can use a Pivot Table

 

Debra Dalgleish, Excel MVP, has some great videos on pivot tables.  Here is a link to a playlist with pivot table videos:

 

 

 

so does Mike "Excelisfun" Girvin

 


... and now there is Power Pivot too ~

 

Warm Regards,

Crystal

 

~ HaPpY NeW yEaR ~

 

On Wednesday, December 31, 2014 8:14 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 



Boris-

 

If you have the table in Access, use the Report Wizard to build your report.  Tell it to group on Category then Sub-category.  You can then tell it to produce a Sum or an Average or a Count (or all three) for both Sub-categories and Categories.

 

You don't say what version of Access you're using, but if it's 2007 or later, click the Create tab, then the Report Wizard button under Reports.  Select your table and include all the available fields.  Click Next to see the Grouping options.  Select Category first (if it's not already on the right) then Sub-category.  Click the Next button and tell the Wizard how you want the data sorted.  Click the Summary Options button to tell it which fields you want summarized.  On the next panel, choose the layout for the report.  On the panel after that, select a theme you want to use in the design.  On the final panel, give the report a name, decide if you want to see it opened immediately, and click Finish.

 

 

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 Dec 31, 2014, at 3:43 PM, theberdov <no_reply@yahoogroups.com> wrote:

 

Hello group,

We use one Excel table to track family expenses. Five columns: date, expense, category, sub-category, expense.

I would like to summarize them now and to be able to see the totals by categgory and sub-category where they exist (e.g. there is only 'food' category, but several sub-categories like home/gas, home/electricity, etc.).

Is it possible to create a report in Excel? If not, how is this done in Access? I imported the table into Access and attempted to design a report, but failed.

What's the best/simplest way to proceed?

Thanks, and a very Happy New Year!

Boris

 

 

 

 

__._,_.___

Posted by: "Bob Phillips" <bob.phillips@dsl.pipex.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Re: [MS_AccessPros] Query design question

 

If you want to do this in Excel, you can use a Pivot Table

Debra Dalgleish, Excel MVP, has some great videos on pivot tables.  Here is a link to a playlist with pivot table videos:



so does Mike "Excelisfun" Girvin


... and now there is Power Pivot too ~

Warm Regards,
Crystal

~ HaPpY NeW yEaR ~


On Wednesday, December 31, 2014 8:14 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:




Boris-

If you have the table in Access, use the Report Wizard to build your report.  Tell it to group on Category then Sub-category.  You can then tell it to produce a Sum or an Average or a Count (or all three) for both Sub-categories and Categories.

You don't say what version of Access you're using, but if it's 2007 or later, click the Create tab, then the Report Wizard button under Reports.  Select your table and include all the available fields.  Click Next to see the Grouping options.  Select Category first (if it's not already on the right) then Sub-category.  Click the Next button and tell the Wizard how you want the data sorted.  Click the Summary Options button to tell it which fields you want summarized.  On the next panel, choose the layout for the report.  On the panel after that, select a theme you want to use in the design.  On the final panel, give the report a name, decide if you want to see it opened immediately, and click Finish.


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 Dec 31, 2014, at 3:43 PM, theberdov <no_reply@yahoogroups.com> wrote:

Hello group,

We use one Excel table to track family expenses. Five columns: date, expense, category, sub-category, expense.

I would like to summarize them now and to be able to see the totals by categgory and sub-category where they exist (e.g. there is only 'food' category, but several sub-categories like home/gas, home/electricity, etc.).

Is it possible to create a report in Excel? If not, how is this done in Access? I imported the table into Access and attempted to design a report, but failed.

What's the best/simplest way to proceed?

Thanks, and a very Happy New Year!

Boris






__._,_.___

Posted by: Crystal <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Re: [MS_AccessPros] Re: Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

John-


I had no problem applying any of the commands on the Arrange tab.  Are the controls in a Layout?

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 Dec 31, 2014, at 4:13 PM, jfakes@rocketmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Bill,

I thought about that, I was hoping there was a fix.

 

John V,

No subform on the tabs just have the fields broken down logically on different tabs.

 

John F.


__._,_.___

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

.

__,_._,___

Re: [MS_AccessPros] Query design question

 

Boris-


If you have the table in Access, use the Report Wizard to build your report.  Tell it to group on Category then Sub-category.  You can then tell it to produce a Sum or an Average or a Count (or all three) for both Sub-categories and Categories.

You don't say what version of Access you're using, but if it's 2007 or later, click the Create tab, then the Report Wizard button under Reports.  Select your table and include all the available fields.  Click Next to see the Grouping options.  Select Category first (if it's not already on the right) then Sub-category.  Click the Next button and tell the Wizard how you want the data sorted.  Click the Summary Options button to tell it which fields you want summarized.  On the next panel, choose the layout for the report.  On the panel after that, select a theme you want to use in the design.  On the final panel, give the report a name, decide if you want to see it opened immediately, and click Finish.


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 Dec 31, 2014, at 3:43 PM, theberdov <no_reply@yahoogroups.com> wrote:

Hello group,

We use one Excel table to track family expenses. Five columns: date, expense, category, sub-category, expense.

I would like to summarize them now and to be able to see the totals by categgory and sub-category where they exist (e.g. there is only 'food' category, but several sub-categories like home/gas, home/electricity, etc.).

Is it possible to create a report in Excel? If not, how is this done in Access? I imported the table into Access and attempted to design a report, but failed.

What's the best/simplest way to proceed?

Thanks, and a very Happy New Year!

Boris



__._,_.___

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)

.

__,_._,___

[MS_AccessPros] Re: Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

Bill,

I thought about that, I was hoping there was a fix.

 

John V,

No subform on the tabs just have the fields broken down logically on different tabs.

 

John F.

__._,_.___

Posted by: jfakes@rocketmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

[MS_AccessPros] Query design question

 

Hello group,

We use one Excel table to track family expenses. Five columns: date, expense, category, sub-category, expense.

I would like to summarize them now and to be able to see the totals by categgory and sub-category where they exist (e.g. there is only 'food' category, but several sub-categories like home/gas, home/electricity, etc.).

Is it possible to create a report in Excel? If not, how is this done in Access? I imported the table into Access and attempted to design a report, but failed.

What's the best/simplest way to proceed?

Thanks, and a very Happy New Year!

Boris


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Re: [MS_AccessPros] Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

Works for me just fine in Access 2007.  Is there a subform on the tab?


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 Dec 30, 2014, at 8:05 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,
I wasn't aware of this behavior before. You could cut the controls and paste onto the main form. Then set the equal spacing and cut/paste back onto the tab control.
 
Duane Hookom MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 30 Dec 2014 10:35:15 -0800
Subject: [MS_AccessPros] Equal vertical spacing doesn't work in tabbed forms in MS Access 2013



Is anyone aware of a fix to make the equal vertical spacing work in a tabbed form?  I've selected several controls and under "Size/Space" clicked on equal vertical, however, nothing happens.  It works on non-tabbed forms but not on tab forms.
 
Thanks in advance,
 
John F



__._,_.___

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

.

__,_._,___

Selasa, 30 Desember 2014

RE: [MS_AccessPros] Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

John,
I wasn't aware of this behavior before. You could cut the controls and paste onto the main form. Then set the equal spacing and cut/paste back onto the tab control.
 
Duane Hookom MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 30 Dec 2014 10:35:15 -0800
Subject: [MS_AccessPros] Equal vertical spacing doesn't work in tabbed forms in MS Access 2013



Is anyone aware of a fix to make the equal vertical spacing work in a tabbed form?  I've selected several controls and under "Size/Space" clicked on equal vertical, however, nothing happens.  It works on non-tabbed forms but not on tab forms.
 
Thanks in advance,
 
John F


__._,_.___

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)

.

__,_._,___

[MS_AccessPros] Equal vertical spacing doesn't work in tabbed forms in MS Access 2013

 

Is anyone aware of a fix to make the equal vertical spacing work in a tabbed form?  I've selected several controls and under "Size/Space" clicked on equal vertical, however, nothing happens.  It works on non-tabbed forms but not on tab forms.

 

Thanks in advance,

 

John F

__._,_.___

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

.

__,_._,___

[MS_AccessPros] Outlook alert with auto email

 

I have an application that sends automated emails through outlook.  I don't use the DoCmd option but rather a version of:

Dim outl As outlook.Application
Set outl = New outlook.Application
Dim mi As outlook.MailItem
Set mi = outl.CreateItem(olMailItem)
mi.Body = "test message"
mi.Subject = "message from access"
mi.To = ""
mi.Send
Set mi = Nothing
Set outl = Nothing

This has worked flawlessly for me over time, but today outlook is suddenly throwing alerts, one per email, of course.

I cannot confirm any changes to virus software, and the alert is clearly from outlook.

Has anyone else seen this or not what is causing it?

Thank you,

Patty


--
Patricia Mapes

__._,_.___

Posted by: Patricia Mapes <patty.mapes@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___