Search results for query: *

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...

Hi Mark, Thanks for the explanation and example. I especially appreciate you including the correct DLL/olb for me to connect to. I tried the first function(s) and no success :( At the line Set oColumn = oTable.Columns(ColumnName) the code stops and the following error occurs. Run-time...

I am unable to figure out how to get the description reference to return more than a Null value. In frustration/ confusion/ investigation I wrote the following 'for loop' to see what properties exist and what values they would spit out. This is what I tried...

In an attempt to get the field description... This is what I tried. ____________________________________________________ Function mytry() Dim conn As ADODB.Connection Dim rs As New ADODB.Recordset Dim intI As Integer On Error Resume Next Set conn = CurrentProject.Connection Set...

I Can't get the Description to display. Following Zemp's example, I was able to see the debug.print display values for the COLUMN_NAME and the data_type, but just as Bigfoot mentioned, I cannot see the Description. It returns Null for every field in the table. My connection string is...

I am working to convert a db from DAO to ADO... How do I make a database with some ADO method? If I understand correctly, I have two options for making a database. Dim cat As New ADOX.Catalog cat.Create "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=.\New.mdb;" OR Dim appAccess As...