Recent content by ag

That's right...GetObject just seems to grab what it fancies from the Task list.<br><br>It's that 'For each Task in Tasklist' construct I just can't seem to find in the help file anywhere :)<br><br>Andrew<br><br><br>

Thanks for the reply....<br><br>I use the FindWindow function in the code to locate and position the Word app but I cannot see an obvious way to set a reference to the object.<br><br>Once I have located the correct version I need to be able use the Word object hierarchy via...

Can anyone assist me with the GetObject call please.<br><br>Scenario: MS Word97 instantiated via VB application using CreateObject or GetObject. <br><br>MS Word may open many times on the client machine. These sessions may be user created, MAPI sessions (Outlook etc) or VB created.<br><br>The...

Apologies for the layout of the code in the previous post....the server seems to strip out tab stops.<br> <br> Can email if required.<br> <br> Andrew<br>

What about if your table has 255 fields or something horrible like that? Writing the query or VB code to do that is not pleasant. I have knocked up a noddy that iterates through an Access table (not an attached one though the code change is one constant to do this) and sets all the field values...

John,<br> <br> Always interested to see other peoples' solutions to problems like this.....please post when you get things running.<br> <br> Cheers<br> <br> Andrew<br>

hi,<br> <br> Thanks for that....I managed it in the end!<br> <br> ag

Hi,<br> <br> Apologies if I'm missing the point completely here...<br> <br> a) If you are using an app built in MS Access, you have to log into the MDB to use it and therefore are an active user within that MDB, and thus will show up on the LDBView.<br> <br> b) If you are using a VB/VC etc...

Don't you just love the bugs....:&gt;<br> <br> Andrew

Elizabeth...no problem....I've used for a couple of years now and it has been a major timesaver.<br> <br> Re. the other questions:<br> <br> 1) this only seems to work on the back end (data) db, not the front end. how come?<br> <br> Can you explain a little more about what you mean by the...

Hi,<br> <br> Do you have to be able to call the stored procedure in this way or can you use the parameters collection?<br> <br> If so, try something like this?<br> <br> Set prm = cmd.CreateParameter(&quot;YourParameterName&quot;, adVarChar,_ adParamInput, 25)<br> cmd.Parameters.Append prm<br>...

To add to that, another route to viewing users logged into an MDB file is to use the LDBView utility (<A HREF="http://support.microsoft.com/support/kb/articles/Q176/6/70.ASP" TARGET="_new">http://support.microsoft.com/support/kb/articles/Q176/6/70.ASP</A>). This allows you to monitor current...

spacey, <br> <br> To the best of my knowledge, Access does not allow you to do this. The size property is read-only for fields that have already been appended, whilst you are working in VBA/SQL.<br> <br> i.e. you get one stab at it!<br> <br> I believe, that even if you change the field-size...

back again....if anyone wants a code snippet to pick this out from the API drop me a line.<br> <br> Andrew<br>

Hi,<br> <br> Strange but true, I want to be able to corrupt an Access 97 MDB. It's not so strange really, I'm testing a VB application that needs to be able repair a database file automatically at login. In all the years I've been using Acecss, I've hit a number of corruptions but can I...