Recent content by MikeRBS

As a matter of interest I saved the macro as a module then when I tried to run it it threw a Macros dialogue asking me for a macro... This was the code: '------------------------------------------------------------ ' M_Link_D ' Links to InvPublic when USB is defined as D...

I have linked databases that may be on different drives, as with another post. I write a macro to link in tables but if the table exists already, then Access creates a table appended with a number. So I preface every link with a delete but then the macro stops if thew table doesn't exist, and...

I'd not noticed that!

I've sorted this out. I got a clue from looking at the Viescas book where he tells you to open out the controls a bit. Once you do this you have fighting chance of getting the right one out of several million mode combinations. As Remou implies, the control bundles itself, the surrounding...

I am trying sub-reports for the first time and can't see where you connect them. Roughly I have a main report say Country, City. I then have two sub reports say City, Customer and City, Supplier. All three work ok separately. I drop the two sub reports onto the detail section of the main...

No. I really think Access should have a more friendly coding environment. Some aspects of the non-coding enviropnment are still class-leading. For old timers like me it's as if we died and went to heaven. Why can't they extend that breathtaking quality to the easy things...

PH Obvious really, isn't it. Cheers

Maybe there's something I don't know but what I can see of Access is the editor is truly awful. You can't re-size the display. There's no search-and-replace etc. So I tend to use Word if I have some intricate SQL. I just hit a wierd problem where WHERE SOMETHING = "R" kept throwing a dialogue...

Many thanks PH. I initially solved this by creating a table of duplicates (using a grouped query) then joining from that table back to the main table to pick up the detail lines. However I'm now doing a similar thing again and your first method works fine. I was stumped for a little while...

How do you select those rows which have a value that appears also in another row ie something like Select EMPNO, Firstname, Secondname where Count(Secondname >1)? I want to list the details of items that are probably duplicates.

Hi Roy. I just checked and it looks as though the ADO library was not activated whereas DAO was. Bizarre set-up as this is Access 2002, so I would have thought it would default to ADO. Thanks for your help. Mike

I've got this code Sub AssignAtlas() 'Add incrementing Atlas numbers to those items without a number currently Const CONNECT_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=g:\Inventory\InvHPD.mdb" Dim Connection As New...

Wicked. It errored. Didn't like acDialog, so I took that out. Now works a treat. Thanks

I have a table of people. I view this through a query People Maintain. I created a simple form People Maintain Subform. In design this works fine in either datasheet view or a form view. I drop this subform onto another form Maintain People. This now works fine but I can see no way of...

I'm up to Access 2002. And I still can't see how to preserve print formatting for queries.