Viewing 15 posts - 2,086 through 2,100 (of 2,452 total)
Great !
hopefully now you can determine what control sources to use...and dispense with the wizard (it has its uses but I used to abhor it :-P)
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 11:52 am
I am assuming that you can see the tables from Access (accdb or adp?)
just an idea....what happens if you use the form wizard to create a form based on...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 11:10 am
Welsh Corgi (1/7/2012)
J Livingston SQL (1/7/2012)
""In the left hand tree control of the Enterprise Manager SQL Server application, expand all nodes until you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 11:03 am
As I have said earlier...and for the record
I haven't had any issues before now...and this occurrence ONLY materialized on a memory compromised PC....it has never occurred on our servers.
The reason...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 10:58 am
from readme.html....default install path...C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data
""In the left hand tree control of the Enterprise Manager SQL Server application, expand all nodes until you come to the Databases folder...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 10:48 am
Welsh Corgi (1/7/2012)
J Livingston SQL (1/7/2012)
does this shed any light...http://jessicammoss.blogspot.com/2008/07/where-is-my-data-tab.html
Yes, thank you very much. I sort of thought that but I wanted to make sure.:cool:
What if you create a report...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 10:30 am
does this shed any light...
http://jessicammoss.blogspot.com/2008/07/where-is-my-data-tab.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 10:10 am
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4385
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 10:03 am
Have you got a "Tally" table....its then very easy
http://www.sqlservercentral.com/articles/T-SQL/62867/
SELECT TOP 100
Row_ID = IDENTITY(INT, 1, 1),
Row_value...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 4:04 am
can you please provide more info
Access version...03/07.10
mdb/adp/mde etc
assuming you are "pushing" data to SQL?
how are you connecting to SQL?
the VBA code you are using
any start up parameters in Access?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2012 at 12:30 pm
Delario (1/6/2012)
I understand the concept but I am having problem with the implimentation. that said all that you have said have done with clear understanding.
take a look here...this may help
http://technet.microsoft.com/en-us/library/ms166552.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2012 at 10:03 am
SQL Kiwi (1/6/2012)
J Livingston SQL (1/4/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2012 at 2:40 am
CELKO (1/4/2012)
For running stats, we now have the OVER( [RANGE | ROWS] ..) sub-clause in the 2012 product.
I am aware of the OVER( [RANGE | ROWS] ..) sub-clause...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 4, 2012 at 12:25 pm
Jeff Moden (1/2/2012)
J Livingston SQL (1/2/2012)
I am not surprised that you cannot replicate....I have used quirky update on several db's , all without errors...and the purpose behind this was...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 3, 2012 at 11:52 am
Hi Jeff
I am not surprised that you cannot replicate....I have used quirky update on several db's , all without errors...and the purpose behind this was to build a testrig for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 2, 2012 at 2:20 pm
Viewing 15 posts - 2,086 through 2,100 (of 2,452 total)