Replies

Of course, Thanks.

Yep – That did the job.

This then poses the question. How would you undelete a table?

Yesterday Hans provided me with a relinking procedure. It works fine but when I delete a table link in my frontend database the relinking procedure still finds it. Why isn’t the table removed completely from the tabledefs? any ideas on how to delete it completely?

I am deleting them manually.

I didn’t know ‘procedure’ meant sub. but now I do. thanks again.

I searched using google and found one that was quite good but it looked a bit old – (it looked at all objects not just tabledef) your’s is much better. Very slick and efficient.

I just modified it to be a function and return true if all went well.

Your’s still uses DAO specifically so it will work for my one client that is still using office 97.

thank you

When I did the rollback it worked OK which suggests that it is not a problem with the mute and I have other apps that work OK and the mute does not help when pressing the mute button or the mute check box from the system tray.

BUT when I hit F8 with WMP running it worked ! Uuntil I hit F8 a few more times and the volume decreased with each keydown which meant I lost it again. Played around a bit more and found that the F9 key increased the level.

So it seems that the F8 and F9 are peculiar to WMP.

So it seems you win again! Thank you.

Yes, I have tested everyting to confirm that it is nothing else but WMP not outputting.
Wnen I did the system restore it worked, other apps are putting out signal OK, it has to be something with WMP.

Thanks Bob.

Min Value – Beautiful! of course its obvious now but I would have never thought of it.
Thanks Hans

I tried a couple of things and found that dbText worked instead of dbChar

Thanks John – that did the trick
PS
They weren’t my real email addresses.

Found the Problem – I had not created the foreign key field – thanks, it aways helps when you know where not to look.

Thanks Hans

I worked it out
Set tblNewTable = dbDatabase.TableDefs(strTableName)
instead of
Set tblNewTable = dbDatabase.CreateTableDef(strTableName)