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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert Access 2000 data to 97 file format
Easiest way would be to use Office XP. It will convert back and forth from 97-2000-2002- sgf323
- Post #8
- Forum: Visual Basic (Classic)
-
finding an autonumber after inserting data into its table??
Normally I pass an SQL string to a command object to update databases but in the case when I need to get an autonumbered ID I open the recordset with ADO. With RS .AddNew .Fields(sField) = sData .Update 'now the record is created 'get the ID .Fields("ID") = lID End With...- sgf323
- Post #6
- Forum: Visual Basic (Classic)
-
Crystal Reports + VB + SQL Server
I built my reports in Crystal Reports then imported them to VB into the RDC. I used to use an Access database and to set the database location for the RDC I used this code: For I = 1 To Report.Database.Tables.Count Report.Database.Tables.Item(I).Location = SourceFile 'SourceFile holds the...- sgf323
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
