|
More site info...
microsoft.public.access.adp.sqlserver | Forum profile
|
|
Forum profile page for microsoft.public.access.adp.sqlserver on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.access.adp.sqlserver, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.access.adp.sqlserver" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.access.adp.sqlserver:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
15
|
35
|
85
|
|
Post:
|
36
|
61
|
151
|
|
|
microsoft.public.access.adp.sqlserver Posting activity graph:
|
Top authors during last week:
user's latest post:
NT Integrated security VS...
Published (2009-11-13 18:55:00)
This post came in after my last one Sylvain. I did not see your post until afterward. Please know I appreciate your suggestions and do not think you are "sitting in front of my desk". I was simply trying to elaborate on the problem being with the actual connection as opposed to a security issue between user / role / schema. I develop in 2007 as I prefer the UI but most of the apps I role out are to clients with...
user's latest post:
NT Integrated security VS...
Published (2009-11-13 19:40:00)
Bob, after a second and close reading of your previous messages, I can now see that you say that you have a connection problem even without calling any stored procedure or select queries and obviously, this has nothing to do with query plans. But sadly, I don't have a solution that come to my mind at this moment. Without seeing the overall setting of the permissions, this could be anything. Make sure that your users have their...
user's latest post:
Sum in Query in...
Published (2009-11-13 15:37:00)
Hello again, I'm still finding may way here with Access ADP and SQL queries. I was going along at a clip writing simple queries. My First one was to total Vacation Balance in 2009: SELECT LADOLFO.Combination.EMPLID, LADOLFO.Combination.NAME, LADOLFO.[2009 Vacation Balance].[Vacation Balance] FROM LADOLFO.[2009 Vacation Balance] CROSS JOIN LADOLFO.Combination Worked just fine. My Second was Total all Vacation Earned: SELECT...
user's latest post:
Refresh PivotChart subform in...
Published (2009-11-13 06:55:00)
On Thu, 12 Nov 2009 17:08:16 -0500, "Bob McClellan" <bobmcc777@gmail.com> wrote: I've never done that either, but I think this would work: Me.mySubformControl.Form.Requery Or perhaps: Me.mySubformControl.Form.myPivotChart.Requery -Tom. Microsoft Access MVP >I have a main form with two subforms. > >One subform has a list that allows the user to select a class type....
ashraf_al_ani via AccessMonster.com
2
user's latest post:
update code vba (sql server 2000...
Published (2009-11-04 09:41:00)
Sylvain Lafontaine wrote: >Sorry but I don't really understand your question. You'll have to come back >with an example of what you wan to do. > >> Many Thanks For your Respons >> the code is running ok but i have one problem >[quoted text clipped - 43 lines] >>>> >>>> waiting your responses Dear Sylvain I tried...
user's latest post:
13 Hosting Web www.ivys.es in...
Published (2009-11-04 09:41:00)
Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es Hosting Linux Web www.ivys.es...
user's latest post:
Problem creating ADE file in...
Published (2009-11-10 17:57:00)
What could cause the Error "Access cannot create an ADE Database"? I created a new .ade db and created an .ade file. I then imported forms from another .ade file and then tried to creata another .ade file but received the above message. I am assuming it must have to do with one or more of the imported forms. All forms have modules and the .adp file compiles without error. -- Thanks, Jim Evans KAS Broadband...
user's latest post:
SQL Update with an aggregate...
Published (2009-11-13 15:20:00)
As fellow Access MVP John Vinson likes to say "Storing calculated data generally accomplishes only three things: it wastes disk space, it wastes time (a disk fetch is much slower than almost any reasonable calculation), and it risks data validity, since once it's stored in a table either the Total or one of the fields that goes into the total may be changed, making the value WRONG." Use a query that...
user's latest post:
Combining records in...
Published (2009-11-12 09:23:00)
I have data exported to an xls then import it to a MS access v7 table that looks like this: Host_N IP Address Interface - Name OS Name Server_03 192.168.1.110 Server_03.sx.company.com MS W2K3 R2 Server_03 192.168.1.123 Server_03-rib.sx.company.com MS W2K3 R2 Server_04 192.168.1.103 Server_04.sx.company.com MS W2K3 R2 Server_04 192.168.1.126 Server_04-rib.sx.company.com MS W2K3 R2 Server_04 192.168.1.105 portal.web.company.com MS...
|
|
|
|
Latest active threads on microsoft.public.access.adp.sqlserver::
Started 2 days, 18 hours ago (2009-11-13 04:50:00)
by Paul Shapiro
If you mean that it works better when all users login as SA, you probably
don't want users to have that much db privilege. Do all of your sql object
references include the dbo. schema qualifier, assuming all your objects are
in the dbo schema?
So it would be Select ... From dbo.MyTable rather than From MyTable.
"Bob ...
Started 2 days, 5 hours ago (2009-11-13 17:20:00)
by Sylvain Lafontaine
If you are using some sort of graphical designer for building your
queries -- don't! These graphical designers can only build very simple
statements and will likely fail for something like your current query.
Second, when you see things like [2009 Vacation Balance] and ([Vacation
Hours Used 1] ... ([Vacation Hours Used 10], it ...
Started 2 days, 16 hours ago (2009-11-13 06:50:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 09:22:02 -0800, Rafa
<Rafa@discussions.microsoft.com> wrote:
Since you did not share your code, stripped to the bare essentials,
that leaves me free to speculate. For example this may work:
--Find all orders with OrderAmount not equal to sum of lineitems
select O1.* from Orders O1 where O1.OrderAmount <>
...
Started 2 days, 7 hours ago (2009-11-13 15:20:00)
by Douglas J. Steele
As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the...
Started 2 days, 10 hours ago (2009-11-13 12:20:00)
by Bob McClellan
You did not post your DML.
the sql should be the same though...
However, from what you've wrote...
try Sum([Vacation Hours]) as 'Total Vacation Hours'
hth,
bob
" Lucinda" <Lucinda@discussions.microsoft.com> wrote in message
news:D2D2CE97-5E50-40A6-AAF6-0D882BDB1D53@microso ft.com...
> Hi,
>
> I am very new ...
Started 2 days, 12 hours ago (2009-11-13 10:23:00)
by Bob McClellan
..just a guess but...
Are you logged in with administrative privileges?
"stullhe" <stullhe111@newsgroup.nospam> wrote in message
news:C76E38A4-9239-4152-BCFE-09C09337EF33@microso ft.com...
>I developed an MSAccess 2003 to be used internally within our company. I
>used
> " Digital Certificate for VBA Projects" in Microsoft Office Tools to ...
Started 2 days, 16 hours ago (2009-11-13 06:55:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 17:08:16 -0500, "Bob McClellan"
<bobmcc777@gmail.com> wrote:
I've never done that either, but I think this would work:
Me.mySubformControl.Form.Requery
Or perhaps:
Me.mySubformControl.Form.myPivotChart.Requery
-Tom.
Microsoft Access MVP
>I have a main form with two subforms....
Started 2 days, 16 hours ago (2009-11-13 06:50:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 09:24:01 -0800, MJ Ross
<MJRoss@discussions.microsoft.com> wrote:
Here is one approach:
http://www.mvps.org/access/modules/mdl0004.htm
-Tom.
Microsoft Access MVP
>I have data exported to an xls then import it to a MS access v7 table that
>looks like this:
>
>Host_N IP ...
Started 1 week, 4 days ago (2009-11-04 09:40:00)
by ashraf_al_ani via AccessMonster.com
Many Thanks For your Respons
the code is running ok but i have one problem
that if the final result i want to plus 1 with it or any other number how can
i deal with this problem
i mean the hole code +1 how can i write it
please waiting for your response
many thanks again
Sylvain ...
|
|
Hot threads for last week on microsoft.public.access.adp.sqlserver::
Started 2 days, 18 hours ago (2009-11-13 04:50:00)
by Paul Shapiro
If you mean that it works better when all users login as SA, you probably
don't want users to have that much db privilege. Do all of your sql object
references include the dbo. schema qualifier, assuming all your objects are
in the dbo schema?
So it would be Select ... From dbo.MyTable rather than From MyTable.
"Bob ...
Started 2 days, 7 hours ago (2009-11-13 15:20:00)
by Douglas J. Steele
As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the...
Started 2 days, 10 hours ago (2009-11-13 12:20:00)
by Bob McClellan
You did not post your DML.
the sql should be the same though...
However, from what you've wrote...
try Sum([Vacation Hours]) as 'Total Vacation Hours'
hth,
bob
" Lucinda" <Lucinda@discussions.microsoft.com> wrote in message
news:D2D2CE97-5E50-40A6-AAF6-0D882BDB1D53@microso ft.com...
> Hi,
>
> I am very new ...
Started 2 days, 16 hours ago (2009-11-13 06:50:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 09:22:02 -0800, Rafa
<Rafa@discussions.microsoft.com> wrote:
Since you did not share your code, stripped to the bare essentials,
that leaves me free to speculate. For example this may work:
--Find all orders with OrderAmount not equal to sum of lineitems
select O1.* from Orders O1 where O1.OrderAmount <>
...
Started 2 days, 16 hours ago (2009-11-13 06:55:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 17:08:16 -0500, "Bob McClellan"
<bobmcc777@gmail.com> wrote:
I've never done that either, but I think this would work:
Me.mySubformControl.Form.Requery
Or perhaps:
Me.mySubformControl.Form.myPivotChart.Requery
-Tom.
Microsoft Access MVP
>I have a main form with two subforms....
Started 2 days, 16 hours ago (2009-11-13 06:50:00)
by Tom van Stiphout
On Thu, 12 Nov 2009 09:24:01 -0800, MJ Ross
<MJRoss@discussions.microsoft.com> wrote:
Here is one approach:
http://www.mvps.org/access/modules/mdl0004.htm
-Tom.
Microsoft Access MVP
>I have data exported to an xls then import it to a MS access v7 table that
>looks like this:
>
>Host_N IP ...
Started 2 days, 12 hours ago (2009-11-13 10:23:00)
by Bob McClellan
..just a guess but...
Are you logged in with administrative privileges?
"stullhe" <stullhe111@newsgroup.nospam> wrote in message
news:C76E38A4-9239-4152-BCFE-09C09337EF33@microso ft.com...
>I developed an MSAccess 2003 to be used internally within our company. I
>used
> " Digital Certificate for VBA Projects" in Microsoft Office Tools to ...
Started 2 days, 5 hours ago (2009-11-13 17:20:00)
by Sylvain Lafontaine
If you are using some sort of graphical designer for building your
queries -- don't! These graphical designers can only build very simple
statements and will likely fail for something like your current query.
Second, when you see things like [2009 Vacation Balance] and ([Vacation
Hours Used 1] ... ([Vacation Hours Used 10], it ...
|
|
Size: 1,657 bytes
