I have a database which opens Word with a mailmerge document
and excecutes a mailmerge.
This works fine but when I change the SQLStatement to anything other than SELECT * from etc as shown below, ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10022936.html
Zones:
MS AccessDate Answered: 09/08/1997 Grade: C Views: 0
Greeting of peace ...
I'm developing a student info. system. I am using VB 6 as a front end and MS-ACCess 97 for backend. i need the SQL statement. Hopefully, you can help me guys.
STUDENT table ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10174169.html
In a query with two fields using Access. The first field is a date column. The second field is a number from 1-100.
For each date of the first field there are from 6 to 12 entries with the same d...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10189586.html
I have an associative table (InterestDetails) that contains the customerID from the customerInfo table and the interestID from the interestList table.
I have multiple customers with the same int...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10249914.html
Hello Experts,
I have a slow (dialup) link to the network where my SQL 7.0 server resides. In certain situations I have the ability to have the table data sent to me via a fast link in individua...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10333260.html
Zones:
Visual BasicDate Answered: 04/26/2000 Grade: A Views: 21
Ok, I have this large query in SQL:
SELECT DISTINCTROW groupAddresses.groupAddressType, groupAddresses.groupAddressName, groupAddresses.groupAddressLine1, groupAddresses.groupAddressLine2, group...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10830742.html
I want to retrieve data from my database using date comparision.
Database
Table name dating
dates date/time (short)
user text 50
Database
dates user
3/5/01 prasad ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20087436.html
Zones:
MS AccessDate Answered: 10/29/2001 Grade: A Views: 0
I am moving an access database to SQL Server. What
do I need to consider?
Thanks.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20292793.html
Okay, be gentle as I am SQL impaired. I am a network admin that has been assigned the daunting task of converting some Access databases to SQL 7.0. Needless to say I don't entirely know what I'm do...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20321814.html
Please Help!!!
I am able to fullly use my application when I use the login used to create all of the tables and views. When I use different credentials with the same permissions I get a weird err...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20402754.html
Zones:
MS AccessDate Answered: 02/15/2003 Grade: A Views: 0