Hello there,
I need help creating a SQL string query within VB6.
I have created the following query, but when I run my applicaiton, I get an error message, stating runtime error, 2147217900, [microsoft][odbc sql driver][sql server] incorrect syntax near ')'
See the code below.
[code=sql] Get bkgs by HARP ID
strSQL = "SELECT [ID],[WebBookingID],[DateofRequest],[Arrivaldate1],[Surname1],[Location1],[HarpID11st],[HotelName1],[HotelChain1st]...
melaine
Last Activity: Jul 3 '07, 02:17 PM
Joined: Nov 3 '06
Location:
-
Using SQL in VB
-
Well my MAIN PROBLEM is how can I display a FORM dynamically?
I do not want to creat 25 queries. When a user selects a table to be displayed as a form, how can I pass through an SQL query (of sone sor) so that the correct information is shown in the FORM that has already been created?
~~~~~~~~~~~... -
Hello PEB,
What happens is that a User will select ONE Table to be displayed from a combo box drop down list.
I would then like the table to open up into a form (displaying all 8 column fields and all the rows of data from the tables).
I require form, so that the User can then make updates to this table!
Hope my query makes more sense!
I am sure that there is a simple solution, but I can figure one out!...Leave a comment:
-
Dynamically query a table to OpenForm with an Access Database!!!
I have to work with an existing database with 25 tables.
I want the end User to be able to modify rows within the tables (add/amend/delete) via a Form. I do not want to create a query for the form, I want to dynamically create a query to access the table to then display the table within an editable form. Can this work? Anybody got any ideas of how I could do this?
I have tried the following syntax using VBA (access2000),...
No activity results to display
Leave a comment: