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!
-
hierarchy table(s)?
Hi, Please can you help me with db design? I have to build a table or tables that will accurately reflect a hierarchy. The hierarchy design is essentially the tree or file view we see on our computers file explorer. I plan on using a Tree List component from VB6 in a Client App to display...- Godfrey
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Replace quotations in SQL Access Query/Insert Statement
Hi, I need a function that will properly quote for insertion an SQL (for Access DB) statement. I currently have one that works for a single Apostrophe: Public Function ApostropheCheck(ByVal strIn As String) ApostropheCheck = Replace(strIn, "'", "''") Exit Function End Function...- Godfrey
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Easy for Access person...Select By Month
Hi, Thank you so much for your help. I am trying to select record for an entire month: SELECT * FROM tblTable WHERE report_date = Format("12/2004","mm/yyyy"); It returns 0 records. There are definitely records for the month of Dec. 2004 in the table. Table data type for report_date is...- Godfrey
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
