Viewing 15 posts - 61 through 75 (of 273 total)
You cannot easily make a SQL Server query the data source for an Access form. The simple approach is to bind the form to the SQL Server view, and...
December 15, 2015 at 2:31 pm
Unfortunately, Access queries that join more than 2 or 3 tables will want to bring in each table and run the query in Access. I would suggest creating a...
December 12, 2015 at 4:56 pm
It depends on the complexity of the query as to how you should proceed. In general, I would leave the query as the data source if the query is...
December 11, 2015 at 3:17 pm
I have a somewhat different perspective from most of the people that visit here. The fundamental problem with Excel is that it isn't a relational database, and if you...
October 15, 2015 at 3:30 pm
I suspect the "minus" sign you were using wasn't the standard one but a special character with a different ASCII code. Often it is the simple little things that...
October 5, 2015 at 8:11 am
What version of Access (and of Excel) are you using? And have you tried using the * as the start and stop character per the standard?
October 5, 2015 at 6:09 am
Rather than using =("!" & [string] & "!") for your control source, I would use =("*" & [string] & "*") as that is the normal start and stop delimiter -...
October 5, 2015 at 5:55 am
The assumption that I made in that reply is that you are using Integrated Security rather than SQL Server Security. There are several advantages in that approach, less SQL...
October 5, 2015 at 5:42 am
The thing I would suspect the most is the use of a System DSN - from Win7 forward our experience with System DSNs has been problematic. As long as...
October 4, 2015 at 3:06 pm
We will need to know a good deal more about your situation. As a preface we've run numerous workstations running Access 20XX against versions of SQL Server from 7...
September 23, 2015 at 10:01 am
Is the Access database stored on each user PC, and is it in the .mdb format or the .accdb format?
August 27, 2015 at 10:07 am
Building a test front-end is an excellent approach. One of the changes in Win7 and later is that the ODBC DSN must be done for the current User, while...
July 31, 2015 at 7:59 am
At a minimum, I think you will need to know what the workstation environment is. ODBC in Windows XP is quite different from Win7 or Win8. Also the...
July 30, 2015 at 4:21 pm
Specifically, what version of Windows are you running, and do you have other versions of Access installed? You should be aware that AccessXP is a 13-year old product, so...
July 25, 2015 at 10:21 am
The only way to do things in something which isn't capable of working with Automation is to do so with the Shell command as described in the sample code you...
June 25, 2015 at 1:04 pm
Viewing 15 posts - 61 through 75 (of 273 total)