Search results

Thanks Wayne, I'll give them a go. Roger

I am using "GetObject" to open a 2nd access application and ".visible = true" to make it visible. When the 2nd application opens it is not fully maximised so the user has to do it. Is there a way to get around this? Thanks RB

Thanks Wayne, It is a string field and it starts with strIRN. I get the feeling Access 2000 doesn't like "*" as a wildcard. I'm using it in a 97 database that is accessing a backend 2000 database through an OBDC connetion. The search works without the "*". I've tried using it in a 2000...

I can't get the "*" wildcard to work in Access 2000. My code is: strSql = "SELECT * FROM DigitalAssets WHERE IRN Like '" & strIRN & "*';" I've also tried : strSql = "SELECT * FROM DigitalAssets WHERE IRN Like '" & strIRN & Chr(42) & "';" Any suggestions? Thanks Roger

I want to connect to an Access 2000 database on another machine from Access 97 and search a particular table. The OpenDatabase method doesn't work, is there any other way? RB

I need to include an API library file that will allow me to connect to a non Access database. In C this would be done with "#include 'file name'". How is it done in a VBA code module? Thanks

Several other people have asked similar questions but didn't get much response. I thought I'd try my luck. The following code isn't working. Dim dbs As Database, wsp As Workspace Set wsp = DBEngine.Workspaces(0) Set dbs = wsp.OpenDatabase("H:\Access Databases\Copyright\Copyright Search.mdb")...

I have created the recordset below which I would like to make the recordsource for a form in the current database called "frmMain". I would be very grateful if someone could give me a hint as to how to go about it. strResult = "SELECT * FROM tblMain WHERE (((tblMain.[AccNo])= " & "1111" &...

Is there a way of overriding the default wrap-around line spacing in a text box in an Access 97 report?

What is the vba action(s) which copy data from a field in a tabel and assign it to a field in a a separate table?