Viewing 15 posts - 241 through 255 (of 274 total)
Dev (1/14/2012)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 14, 2012 at 12:16 pm
If you are running that in an Access .adp database, it will work just fine. If you are running it in a .mdb, unless it is a PassThrough query,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 6, 2011 at 10:53 am
Part of the issue is Access 2003 - it is an 8 year old product, and support for newer features in SQL Server is a bit suspect as you deduced....
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 30, 2011 at 5:11 pm
SQL Server connectivity can be a major pain with Access applications. I presume there is a compelling reason for not using linked tables (the approach we normally use), instead...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 28, 2011 at 8:57 am
A couple of questions that might have bearing on your issue:
1 - What version of Access are you using?
2 - If you actually link to a view of the underlying...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 28, 2011 at 8:42 am
Apologies, I didn't realize you were suggesting that as the conditional formatting expression. And I think the original poster has worked out a solution using conditional formatting.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 12, 2011 at 11:20 am
Unfortunately, the font color property of the text box on a continuous form applies to all of the records being displayed, so as the records are displayed, all of the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 12, 2011 at 9:34 am
peter478 (10/11/2011)
2. yes it is continues form similar to a table
3. yes it is unbound ...and I need to filter some data in the form via...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 11, 2011 at 2:11 pm
Depending on the version of Access you are using, you may be able to do this without using VBA. Several questions about your situation:
What version (or versions) of Access...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 11, 2011 at 7:37 am
Let me suggest that you create an expression in Access using the query grid that is a select statement. You can use the IIF() function to set the value...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 31, 2011 at 3:02 pm
Since you posted this in the Access forum, you can use the Left() function to select the first three characters of the string, and the Mid() function to select the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
August 23, 2011 at 9:40 am
In general, if Access sees the proper indexing and constraints on the SQL Server tables, it will pass the query syntax to the ODBC driver with then converts it so...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 27, 2011 at 2:35 pm
If the Access developer used a multi-value field for a row-source for a combo box, that's extremely unusual, and would suggest the developer was using a database in the .accdb...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 15, 2011 at 5:56 pm
Glad you were able to solve it - those kind of problems can drive you up the wall! Unfortunately the Access error messages when dealing with ODBC linked tables...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 7, 2011 at 7:53 am
Lowell - I am able to duplicate your results in a test database constructed specifically for that purpose. I noted that you had wrapped the trigger in and BEGIN...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 6, 2011 at 11:59 am
Viewing 15 posts - 241 through 255 (of 274 total)