Viewing 15 posts - 31 through 45 (of 274 total)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 15, 2017 at 5:32 pm
So are you trying to execute a stored procedure from Access? That would typically be the case where you pass parameters to SQL Server. We typically define an ADODB connection,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 25, 2017 at 9:38 am
You did start a new post, but not a new thread. In answer to your most recent question, Access 2013 and 2016 do not support ADP projects, but Access 2010...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 23, 2017 at 2:39 pm
On the servers where it doesn't work, do you get any sort of error message?
Also, what security model are you using? Trusted_Connection=Yes suggests it is integrated security. But...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 21, 2017 at 2:58 pm
You first need to define WordApp as an "object" and then set that object to be a Word using the CreateObject command. Since you are tinkering with automation the tutorial...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 5, 2017 at 8:48 am
OK - start the Access database while holding down the SHIFT key so you have full menus and the Navigation Pane. Click on the "ribbon" tab for Database Tools, and...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 23, 2017 at 10:51 am
rf44 has identified the problem I believe - a short-coming of the SSMA. If you have an installation of a recent version of Access, there is an upsizing tool that...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 23, 2017 at 8:21 am
Have you created an ODBC data source to the SQL Server database? That is the only way to connect an Access database in the .accdb format to tables in SQL...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 22, 2017 at 5:46 pm
Are you expecting queries, forms and reports to be upsized to SQL Server? The only thing that the SSMA deals with are tables that are stored natively in the Access...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 22, 2017 at 4:00 pm
sumanth.pathuri (1/11/2017)
How can we capture if someone edits a record without using a trigger. We need a column in the same table. Can you please help me with this.
As this...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 11, 2017 at 11:40 am
What I suggested, perhaps obliquely, is that you don't need to run code to do what you are trying to do if you have the table actually linked into your...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 14, 2016 at 7:46 pm
In addition to the comments of others, I should point out that support for ADP projects was removed in Access 2013. If you have some clever user install 2013...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 14, 2016 at 3:06 pm
Since you are now trying to connect to SQL Server, you will likely need to setup an ODBC Data Source on the system in HR - has that been done?...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 14, 2016 at 3:03 pm
peter478 (11/16/2016)
Hello ,In my table view I have set a filter = getdate()
Is it possible to convert it directly in table view to short date?
thank you
Is there a reason you...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 16, 2016 at 9:06 pm
Unfortunately, Access queries use a different syntax, and in most cases other than action queries, are used as the basis for forms and reports. So you may be able...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 21, 2016 at 12:22 pm
Viewing 15 posts - 31 through 45 (of 274 total)