Recent content by M4RK 1

Thanks for coming back Guus. I think the problem must be registration as it's not showing in the toolbar. The control is listed Insert>ActiveX controls but I get the limited version. As you know a simple Set GRID.Datasource = Rst will fill it but there's no Datasource property I've heard a...

When I add any of the usual flexgrids (heirarchical etc) as ActiveX controls to an Access form most of the methods and properties are missing. I don't particularly like subforms in Access. Flexgrids in pure VB6 look how I want.I'm fairly sure I have added the right references in the VBA IDE...

Doc Man That's a superb answer. Thanks

Thank for your quick reply. The line in question is as follows s = "*" & Trim(txtSearch) & "*" It works OK on my machine but raises a compile error on the deployment machine.

I've just placed a prototype database on a company's server and got a compile error for a line of code which uses the Trim() function. To be honest I don't want to look a fool deploying 'tested' programs which don't work. This is such a common built-in function so why didn't Access compile it...

Thanks both but I'm getting errors with this syntax. It can't find the form referred to. There's no typos in the code either

I'm new to this forum and Access but have done lots of DB work in VB6 using Access tables. The two don't seem to mix in Access as there are things like Docmd instead of code I'm used to in VB6. As a result I'm stuck on a few things which are probably simple. I have a button which is hidden...