Need to refer to a textbox while querying Access97:
SELECT * FROM Bills WHERE ??????????
I Need to refer to Text1 on Form4.
I tried [Forms]![Form4]![Text1] and
Forms.Form4.Text1, also with .tex...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10296393.html
Zones:
Visual BasicDate Answered: 02/17/2000 Rating: 6.0 Views: 0
Hi Experts,
I am making a VB application in which user will type SQL query in Rich Text Box. I want SQL verbs/syntax automatically change color after typing. For example if user types
SELECT ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20258819.html
Zones:
Visual BasicDate Answered: 09/23/2002 Rating: 7.6 Views: 15
Hi,
Anyone's help would be greatly appreciated...
I have a syntax problem in converting an SQL statement from MSSQL format to Access format (I've replaced all the single quotes with hashes).
...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20420383.htm...
Zones:
ASPDate Answered: 12/09/2002 Rating: 7.8 Views: 0
Dear experts,
I don't understand why there is a syntax error in my SQL. PLS ADVISE!
strSQL = "INSERT INTO Transaction(name, amount,date, beg_Bal,end_Bal, type, memo) values (" _
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20597369.html
Zones:
MS AccessDate Answered: 04/28/2003 Rating: 6.6 Views: 0
Hi,
We have a table in our database called 'Filter' and this is used as part of an application. Table e.g:
FilterNo Descript ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20880905.html
Zones:
MS SQL ServerDate Answered: 02/25/2004 Rating: 8.4 Views: 0
I am not very familiar with SQL and I am trying to put together a data query.
I want it display totals for certain field combinations and have been successful with the following:
SELECT ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21058811.html
Zones:
MS SQL ServerDate Answered: 07/14/2004 Rating: 9.2 Views: 73
Hi!
I believe I ahve a very simple question abour Remedy application access through Remedy client to read and write to the the database.
The first question I have, is Remedy Database complete...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21183326.html
Zones:
DatabasesDate Answered: 10/28/2004 Rating: 7.4 Views: 0
Hi, I believe I need some help on this one.
SELECT dbo.ProjectLines.OldHALNum, dbo.ProjectLines.VendorCode, dbo.ProjectLines.Description, dbo.ProjectLines.ExtendedDescription,
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21268651.html
Zones:
DatabasesDate Answered: 01/25/2005 Rating: 7.6 Views: 0
Hi - I have a sql script that is fairly basic in that it selects data from a couple of tables an d gets outputted into a users excel sheet.
This normally works fine until we find that sometimes t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21273733.html
Zones:
MS SQL ServerDate Answered: 01/13/2005 Rating: 6.6 Views: 0
I have a table with the following data
product cost adjustment quantity
parta $1 10
partb $2 5
partc ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21310904.html
Zones:
MS SQL ServerDate Answered: 02/11/2005 Rating: 6.8 Views: 0
