Recent content by Weebairnes

I can import tables with DoCmd.TransferDatabase. How do I get the table relationships? Thanks

Has anyone ever seen this? Has anyone ever fixed this? I think it occured after a downgrade from XP to 2000. I tried the common solution when baffling, undocumented problems occur; create new db and import all objects from tainted db. This worked and now I can view database objects with the...

Large icons shows objects small icons shows objects List view shows objects Detail view shows nothing. Nada. No scroll bars, no icons, no descriptions, no dates, no columns or column headers. In summary, nothing. No tables, reports, modules. Bizarre.

If you set the accounts and groups, the next thing to do is to give (or remove) permissions to your database. There is one user that you need to specifically address. The default user, named 'admin', needs to have a password assigned (write it down somewhere). Also, for the database you...

Attempting to close gives an error. Is there an easy way to tell if a DAO recordset is open? thanks

thanks for your help, Richard. When I connected before, I believe it was the client server set up you mentioned, where sybase was running. Now, the Sybase file is not loaded and is not running with Sybase engine on a server. All I have is the file sitting in a folder. Is this now...

I use Access all the time and don't know anything about Sybase. Would someone be so kind as to tell me how to link to Sybase tables? If I don't have Sybase installed, am I missing the necessary files to create an ODBC link? History: I was working at a site where Sybase was installed, and I...

Many thanks. I never realized that the a label is a child of the Control it represents.

Thanks! You're free impartation of pertinent knowledge to resolve the syntactical discombobulation I was facing has saved the day. Question. How does the "Controls(0)" portion work? What does it mean in association with the other control?

I have a form with a text box control named "txtName." Associated with this text box control is the label, "lbl1". The caption property of lbl1 is, "Enter your name:" I can refer the label in VBA as me.lbl1. From here I can change format properties, the caption, etc. I can refer to the text...

Oh. Thanks for the tip. Would you mind pointing out the difference between this forum and the one you suggested? Thank you.

How do you move to a specific record using ADO commands? The code from where I want to execute this is in a module (not behind the form). I don't think that the recordset clone does me any good. Seek is only supported with server-side cursors. Find works great, but how do I make the current...

Say... could it possible that all my woes are related to a secure database? I am using an mdw file of my own and have set permissions on the tables. This explains why I can see the tables, but can't see the content. After more fiddling (trials and errors), I figured out the proper...

Thanks again for your help. I tried adding the suggested line of code. No go. Although it was a refreshing try. chuckle chuckle. Here is an interesting twist. I tried pointing to an old Access 97 table and - SUCCESS! As you knew, and I suspected, all your code is fine, but something is...

Sorry, no go. Are there problems with Access? Is ADOX meant for non-access databases? Perhaps a problem with Access XP? I place a break point in the code and watch it execute line by line. Like I said, the following does not give an error, but 'oTable.Columns' never has any value, so the...