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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access error: 'Query is corrupt'
On Nov 11, Microsoft pushed out a security update for all versions of MS Access and inadvertently introduced a SERIOUS bug which could affect all current users of Access. This bug will occur for an Update query that: - Updates a single table (i.e. it updates a table, rather than the output of a...- vbprgmr
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Sort Order with parentheses in text field
Hey, Gang - Have a simple table with a text field which has the following data - sorted ASC: CH2-(Cb,S) CH2(CN)-(C) CH2-(CO,=C) It appears to ignore the dashes. I cannot find any reference to this issue anywhere. Weird. Any Help?- vbprgmr
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
-
adp Stored Procedure export to Excel
I am using Access 2000 and SQL 2000. I want to use a stored procedure (with 2 paramters) as the source for exporting to a spreadsheet. This is similar to a post by GShen thread: 707-496426. GShen found the answer to this, but I cannot get the code to work. It works fine if I use: lSQLExStr =...- vbprgmr
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
ADO vs DAO code for Database Properties
Need help! I'm looking for the ADO equivalent of the following DAO code (which interrogates the 'Database Properties' collection). Ex: lStr = gfGetDBSProp("Summary","Author") ' Public Function gfGetDBSProp(lpDoc As String, lpPrp As String) As String Dim dbs As Database, cnt...- vbprgmr
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
