Recent content by kevinforbes

ah, I see...I was missing the all important "AND" thank you very much! Kev

Hi all, I have 2 tables that I want to join based on the following conditions. I always want to display everything from the "courses" table but I only want to join data from the "sessions" table if the session_user_id matches an ASP variable and the "course_code&quot...

Thank you, I must have done the first, I will try the 2nd option. K

I just imported them using Enterprise Manager, I really don't want to have to script the copy since it is around 25 tables and relationships. tx, K

Hi there, I copied my tables from one database to another and found that the primary keys and relationships are all deleted in the destination database. Any idea why? thanks, K

Thanks, I will try that

Thanks, unfortunately it is something that has to be done programmatically and free ! tx

Thanks, those will probably do the trick. However, I only want to backup the tables, how about this... -------------------------------------------------- Private Sub backupDb() Dim retval As Boolean retVal = MsgBox("Backup data?") 'get current db filename 'check for file at...

Sorry, forget to mention I am using Access 2002 and VB 6 tx

Hi there, Forgive me if this question has already been answered but I cannot search since it is down for maintenance at the moment. Please point me to the thread if applicable. From MS Access, I need to run VB Code to create a backup database at C:\backup_db\current_filename_bak.mdb containing...

Thank you very much! K

Happy Holidays to all, I have several tables with several duplicate records - some up to 600 rows when it used to be 200...this is due to someone appending imported data instead of replacing it. In any case, how do I get one distinct row for each duplicate record and make a new table with it...

Thanks Terry, I will give that a try. Kev

How about this... SELECT top 1 ships.*, images.id, images.isPrimary, images.description FROM ships ONLY DO A JOIN IF images.isPrimary = 1 LEFT JOIN images ON ships.ref_id = images.ref_id WHERE ships.ref_id = '003' AND (images.isPrimary = 1 OR images.isPrimary Is Null) Does that logic...

Sorry for the confusion..paragraph 1 should read like this: (tbl2.other_id can only be 1 or 0) k