Search results for query: *

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

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.

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

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

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

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

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

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

I'd like to use an insert command to insert whatever data that is on the unbound form. The first three fields are required and I check those values prior to executing the code below. But some fields may be null. Dim strSQL as string . . code . . strSQL = "INSERT INTO tblCase " & _...

I'd like to print out a module. Is there a way to Print Code from the Microsoft Visual Basic screen to a color printer, and maintain the color settings? (its okay - I don't have high expectations.)