Selasa, 30 September 2014

Re: [MS_AccessPros] Re: Copying query runs it first

 

Bill, the Ctrl-drag appears to work perfectly. I had tried it before posting but was dragging too far, and It didn't do anything. But you indicated "drag a little," and when I did that, the "+" sign appeared to create a copy. Strangely enough, the Ctrl-C still runs the query, which I don't want. I'll stick with Ctrl-drag until I get Access reinstalled. It's very handy and gets me out of a jam.

Thanks!!

On Tue, Sep 30, 2014 at 3:41 PM, James McAlister <kc5qeg@gmail.com> wrote:
I haven't ever seen it before either, Bill. The problem began with the installation of an updated virtual machine about two weeks ago, so the problem has to be related to that in some way even though Parallels (VM supplier) tech support blames Microsoft. Something is obviously amiss, so I'm first going to do the easy thing and reinstall Access to see if that will fix the problem. If not, I'll move on to something else. I haven't tried Ctrl-drag but will do so.


On Mon, Sep 29, 2014 at 2:49 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
 

James

I've never seen that happen. Are you copying the query in the Navigation Pane?  When I copy a query I just hold down the Ctrl key and drag the query a bit away from itself. But the old Ctrl+C/Ctrl+P should work, too.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog




__._,_.___

Posted by: James McAlister <kc5qeg@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (16)

.

__,_._,___

RE: [MS_AccessPros] multi colums report

 

Have you considered building your data in a temp table first.  Would require a lot less fussing around with the report.

From: saigonf7q5@yahoo.com [MS_Access_Professionals]
Sent: ‎9/‎30/‎2014 12:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] multi colums report

 

 I have a multicolumns report, which is the labels (column headings) are displayed on the left side of the report,
and the data is printed next (on the right side) to the labels. As an example shown below.

-----------------------------------------------------------------------
                         Company1    Company2    Company3 
Current Month  09/08/2014    09/08/2014   09/08/2014 
Line1 Data        ABC              DEF              GHI

Prior Month      08/08/2014    08/08/2014   08/08/2014  
Line1 Data       STU               VXYZ            CBA
-----------------------------------------------------------------------

The procedure below is the code that I use to generate the report above.

 

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo ErrorHandler

Dim i As Integer
If Me.Left < 1.75 * 1440 Then
    Me.NextRecord = False
    For i = 1 To 5
        Me("txt" & i).Visible = False
        Me("lbl" & i).Visible = True
    Next i
Else
    For i = 1 To 5
        Me("txt" & i).Visible = True
        Me("lbl" & i).Visible = False
    Next i
End If

ExitProcedure:
Exit Sub

ErrorHandler:
    MsgBox "Error Number: " & Err.Number & vbNewLine & "Error Description: " & Err.Description, vbExclamation
    Resume ExitProcedure
End Sub


Now, is it possible to format the report, insert the Prior Month before the Current month,
so the data will be printed as a column, side by side, next to each other like this.

 

-------------------------------------------------------------------------------------------------------------------------

Prior Month    Current Month    Prior Month     Current Month   Prior Month    Current Month  
Company1     Company1         Company2       Company2        Company3      Company 3 
08/08/2014     09/08/2014        08/08/2014      09/08/2014        08/08/2014     09/08/2014 
STU                ABC                   VXYZ              DEF                   CBA               GHI

--------------------------------------------------------------------------------------------------------------------------

Phucon.

__._,_.___

Posted by: Jack Stockton <jack_stockton666@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Re: [MS_AccessPros] Re: Copying query runs it first

 

I haven't ever seen it before either, Bill. The problem began with the installation of an updated virtual machine about two weeks ago, so the problem has to be related to that in some way even though Parallels (VM supplier) tech support blames Microsoft. Something is obviously amiss, so I'm first going to do the easy thing and reinstall Access to see if that will fix the problem. If not, I'll move on to something else. I haven't tried Ctrl-drag but will do so.


On Mon, Sep 29, 2014 at 2:49 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
 

James

I've never seen that happen. Are you copying the query in the Navigation Pane?  When I copy a query I just hold down the Ctrl key and drag the query a bit away from itself. But the old Ctrl+C/Ctrl+P should work, too.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog



__._,_.___

Posted by: James McAlister <kc5qeg@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (15)

.

__,_._,___

[MS_AccessPros] RE: Visio MVP Yammer group

 

Yammer is broken down into communities. The one that the Visio MVP group is in the

Microsoft MVP Community network

I will try and find out how you get there

 

John…

From: John Goldsmith [mailto:johng@visualsignals.co.uk]
Sent: Tuesday, September 30, 2014 2:40 PM
To: lancucki
Subject: RE: Visio MVP Yammer group

 

Hi John,

 

Yes I am.  I have to say I prefer the old Newsgroups in Outlook Express J but it’s a modern world I suppose.

 

Who set up this group by the way?  Is it going to be different from the alias email list?

 

All the best

 

John

 

From: lancucki [mailto:lancucki@magma.ca]
Sent: 30 September 2014 18:40
To: John Goldsmith
Subject: RE: Visio MVP Yammer group

 

Are you on Yammer? Should this be open to All MVPs?

 

John…

 

From: John Goldsmith [mailto:johng@visualsignals.co.uk]
Sent: Tuesday, September 30, 2014 6:06 AM
To: Senaj Lelic; lancucki; MSVisio-MVP-NDA@mstechdiscussions.com
Subject: RE: Visio MVP Yammer group

 

Yes, me too please.

 

All the best

 

John

 

From: Senaj Lelic [mailto:sl@oneassist.de]
Sent: 30 September 2014 10:34
To: lancucki; MSVisio-MVP-NDA@mstechdiscussions.com
Subject: AW: Visio MVP Yammer group

 

Great john congrats !!!

 

Can you invite me ?

 

Ĺ enaj

 

 

Von: lancucki [mailto:lancucki@magma.ca]
Gesendet: Montag, 29.
September 2014 18:58
An:
MSVisio-MVP-NDA@mstechdiscussions.com
Betreff: Visio MVP Yammer group

 

I am not sure how it happened, but I am managing the Visio MVP Yammer group with David. Recently I have been getting requests to join the group from others, both MVP and non MVPs. Before I approve or disapprove, do you want to join and how can we use the Yammer group? So far, I have not been a big fan of Yammer, but several of my MVP connection channels have moved to Yammer. I have a hard time telling what is new and what I have read and tend to reread things.

 

So far, this contact list is doing fine (though we could use more traffic). If we do use the Yammer group, can I suggest we open it up to all MVPs so they can discuss issues they have had or want to talk about that is Visio related and keep this contact list for the discussions that are NDA related.

 

John…

 

__._,_.___

Posted by: "lancucki" <lancucki@magma.ca>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

[MS_AccessPros] multi colums report

 

 I have a multicolumns report, which is the labels (column headings) are displayed on the left side of the report,
and the data is printed next (on the right side) to the labels. As an example shown below.

-----------------------------------------------------------------------
                         Company1    Company2    Company3 
Current Month  09/08/2014    09/08/2014   09/08/2014 
Line1 Data        ABC              DEF              GHI

Prior Month      08/08/2014    08/08/2014   08/08/2014  
Line1 Data       STU               VXYZ            CBA
-----------------------------------------------------------------------

The procedure below is the code that I use to generate the report above.

 

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo ErrorHandler

Dim i As Integer
If Me.Left < 1.75 * 1440 Then
    Me.NextRecord = False
    For i = 1 To 5
        Me("txt" & i).Visible = False
        Me("lbl" & i).Visible = True
    Next i
Else
    For i = 1 To 5
        Me("txt" & i).Visible = True
        Me("lbl" & i).Visible = False
    Next i
End If

ExitProcedure:
Exit Sub

ErrorHandler:
    MsgBox "Error Number: " & Err.Number & vbNewLine & "Error Description: " & Err.Description, vbExclamation
    Resume ExitProcedure
End Sub


Now, is it possible to format the report, insert the Prior Month before the Current month,
so the data will be printed as a column, side by side, next to each other like this.

 

-------------------------------------------------------------------------------------------------------------------------

Prior Month    Current Month    Prior Month     Current Month   Prior Month    Current Month  
Company1     Company1         Company2       Company2        Company3      Company 3 
08/08/2014     09/08/2014        08/08/2014      09/08/2014        08/08/2014     09/08/2014 
STU                ABC                   VXYZ              DEF                   CBA               GHI

--------------------------------------------------------------------------------------------------------------------------

Phucon.

__._,_.___

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

.

__,_._,___

Re: [MS_AccessPros] Copying query runs it first

 

Thanks, Bill! I'll wait until I'm done with this critical project before potentially messing something up! Will be back here with more questions if they arise!

On Tue, Sep 30, 2014 at 9:37 AM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
 

James

To uninstall Access, go to the Control Panel>Programs and features>Select your Office Suite and click on Change. That gives you the choice of what program to uninstall or install.

Bill Mosca


__._,_.___

Posted by: James McAlister <kc5qeg@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (14)

.

__,_._,___

Re: [MS_AccessPros] Copying query runs it first

 

James

To uninstall Access, go to the Control Panel>Programs and features>Select your Office Suite and click on Change. That gives you the choice of what program to uninstall or install.

Bill Mosca

__._,_.___

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

.

__,_._,___

Re: [MS_AccessPros] Copying query runs it first

 

Thanks, Bob. That's what I see also. But I was thinking that since running the Office install disk gave options on which programs to install there might be similar options on what to uninstall as well. But that could be totally wrong. 

On Tue, Sep 30, 2014 at 9:13 AM, 'Robert Peterson' bob@alternatefinishing.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
 

If you bought the suite and installed the suite then odds are you won't find a selection to uninstall only one part of it.

I know that is the way my Office 2010 Pro is. Only one choice in control panel.

 

Bob Peterson

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, September 30, 2014 10:02 AM


To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 




If I want to reinstall Access to see if that will fix the problem completely, what's the best way to do it? Do I need to uninstall and then reinstall my complete Office suite, of can I do just Access? Or maybe doing all of Office would be better, though I haven't noticed any problems with Excel, which I also use regularly. 

 

Any thoughts would be appreciated. Using Access 2010 on Windows 7 Pro.

 

On Tue, Sep 30, 2014 at 2:30 AM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Glad I could help James. Workarounds are never ideal but sometimes they do let you get on with the job when a better solution is out of your hands.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 10:23 PM


To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 

 

That does work, Glenn, so I do have a workaround other than copying the SQL. I did run the office repair, but that didn't seem to fix it completely. Parallels support was no help and blamed it on Microsoft even though I've used Access on Parallels for three years now with no problem at all — until I installed the updated Parallels software a couple of weeks ago. So there's some hitch there. But they will "look into it." 

 

Thanks to you and Bill for helping!

 

On Mon, Sep 29, 2014 at 4:31 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

What happens if you select  the query, then go to the file tab and select Save Object As. If that works you could at the Save Object As to the QAT.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 

 

Thanks, Glenn. The query is not open, and I'm trying to copy in the Navigation area which shows all Access objects. I either select the desired query and Ctrl-C or else right-click the query and select Copy. Since neither of these approaches no longer works, I'm copying the SQL and pasting into a new query. 

 

On Mon, Sep 29, 2014 at 3:57 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

James,

 

Are you copying on the navigation bar? Or do you have the query open when you try to copy it?

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 3:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Copying query runs it first

 

 

I'm having a new problem with Access 2010 on Windows 7 Professional, and I don't know what I might have done to cause it.

 

Whenever I try to copy and paste a query in order to duplicate it, Access pauses for a while and is non-responsive. What it  is doing is actually running the query and copying the results to the clipboard. When Access becomes responsive again, the query results, if they are small enough, are on the clipboard instead of the query object that I'm trying to duplicate. 

 

I can copy/paste tables just fine; it's just queries that are troublesome. It makes no difference whether I use Ctrl-C or Copy from the context menu. The results are the same.

 

I am running Access in a virtual machine (the newParallels Desktop 10) on my Mac. I'm pretty sure that the issue lies there, but I have use previous implementations of Parallels for years with no problem. But before I contact Parallels support, I'd like to confirm that I'm not just doing something stupid in Access!

 

Thanks for any ideas.

 

James

 

 

 

 





__._,_.___

Posted by: James McAlister <kc5qeg@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

.

__,_._,___

RE: [MS_AccessPros] Copying query runs it first

 

If you bought the suite and installed the suite then odds are you won't find a selection to uninstall only one part of it.

I know that is the way my Office 2010 Pro is. Only one choice in control panel.

 

Bob Peterson

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, September 30, 2014 10:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 




If I want to reinstall Access to see if that will fix the problem completely, what's the best way to do it? Do I need to uninstall and then reinstall my complete Office suite, of can I do just Access? Or maybe doing all of Office would be better, though I haven't noticed any problems with Excel, which I also use regularly. 

 

Any thoughts would be appreciated. Using Access 2010 on Windows 7 Pro.

 

On Tue, Sep 30, 2014 at 2:30 AM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Glad I could help James. Workarounds are never ideal but sometimes they do let you get on with the job when a better solution is out of your hands.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 10:23 PM


To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 

 

That does work, Glenn, so I do have a workaround other than copying the SQL. I did run the office repair, but that didn't seem to fix it completely. Parallels support was no help and blamed it on Microsoft even though I've used Access on Parallels for three years now with no problem at all — until I installed the updated Parallels software a couple of weeks ago. So there's some hitch there. But they will "look into it." 

 

Thanks to you and Bill for helping!

 

On Mon, Sep 29, 2014 at 4:31 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

What happens if you select  the query, then go to the file tab and select Save Object As. If that works you could at the Save Object As to the QAT.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 

 

Thanks, Glenn. The query is not open, and I'm trying to copy in the Navigation area which shows all Access objects. I either select the desired query and Ctrl-C or else right-click the query and select Copy. Since neither of these approaches no longer works, I'm copying the SQL and pasting into a new query. 

 

On Mon, Sep 29, 2014 at 3:57 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

James,

 

Are you copying on the navigation bar? Or do you have the query open when you try to copy it?

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 3:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Copying query runs it first

 

 

I'm having a new problem with Access 2010 on Windows 7 Professional, and I don't know what I might have done to cause it.

 

Whenever I try to copy and paste a query in order to duplicate it, Access pauses for a while and is non-responsive. What it  is doing is actually running the query and copying the results to the clipboard. When Access becomes responsive again, the query results, if they are small enough, are on the clipboard instead of the query object that I'm trying to duplicate. 

 

I can copy/paste tables just fine; it's just queries that are troublesome. It makes no difference whether I use Ctrl-C or Copy from the context menu. The results are the same.

 

I am running Access in a virtual machine (the newParallels Desktop 10) on my Mac. I'm pretty sure that the issue lies there, but I have use previous implementations of Parallels for years with no problem. But before I contact Parallels support, I'd like to confirm that I'm not just doing something stupid in Access!

 

Thanks for any ideas.

 

James

 

 

 

 




__._,_.___

Posted by: "Robert Peterson" <Bob@AlternateFinishing.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (11)

.

__,_._,___