Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Opening Access database from VB5
Is there a way I can open an Access database and close my VB application on the click of a button? Just in case this creates any confusion I do not mean reading data from the database in VB, I mean physically open Access and the specific database and close my VB application Thanks- sirchris
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Editing data in a database
(with VB5) I am trying to make an application that can add, edit and delete data to, in and from a database, but I am having problems with the my adding and editing subroutines here is my adding code: Sub subAdd() strWhere = "" strSubject = "SELECT Subject.SubjectID...- sirchris
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
-
Need help running dynamically created Query from controls on form
I have 3 comboboxes and intend to have code that when a button (cmdSearch) is clicked will read the data from the comboboxes and dynamically create a query, here is my function: Private Function fncGenerateQuery() As Boolean Dim strSQL As String Dim qdfTemp As QueryDef Dim strWhere As String...- sirchris
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
HELP!!! Combobox search w/ query linked to form.
I am trying to set up a form with 2 comboboxes and a textbox, plus a query to use the data from these boxes to search the database. I have tried the following SQL statement for my query: SELECT Teacher.TeacherID, Teacher.TeacherName FROM Teacher WHERE (((Teacher.[TeacherName...- sirchris
- Thread
- Replies: 10
- Forum: Microsoft: Access Queries and JET SQL
