Search:

Hans is the man.

nuff said.

I still owe Hans, at least 16 beers for his invaluable help over the years in my ms access tuition... for good measure im happy to round it up to a case.

Am i right in thinking this board now...

I am on a site, where i have an access application, spread over 200 ish pc's.

the newer versions of my database front end, have self checks running on on-timer events, that will kick people out of...

Many thanks john and wend.. will have a look at the post and see whats best.

I don't anticipate going beyond 255 characters per tag field.

Steve

I have a list of documents, which have a number, and a revision date.. eg:-

BK-001 How to cook food outdoors 1

I would like to add a tagging system to this row, to allow easy filtering. so, i...

Oops.. sorry for the wrong area. my lean towards the access forum...

At least the question is answered in depth for anyone else in the same predicament!

I have this complex set of queries, with one query, querying another.

QV1 and QV2 are queries, that pass results to QV3.

QV3 is a union query, this is the SQL :-


SELECT [MEMOID], [work...

Application.EnableEvents = False
workbooks.Open "C:\Myforlder\MYfile.xls"
Application.EnableEvents = True

Ok.. answered my own question with the help of google. apologies.

I have placed some code on the on OPEN event of an Excel worksheet.

the code basically exits the worksheet if the folder is not a specific one.. however, i have made a typo, and now it exits every...

When you get a parameter prompt for a field when you don't expect it, it usually means that you have miss-spelt the field name.
This is consistent what you observe. When you add it back at the...

This isn't so much a problem.. but i'm just interested if anyone knows why its doing what, its doing.

I have a query. this is the SQL


SELECT TWORKAREAS2.MEMOID, DATA.[work area],...

Will try that again, thanks pieterse

This is where i am so far: I appear to be able to connect from word, to an access database using this code:

Now, i need a way to find a record and an associated value. (I did try the code...

The ADO Recordset object does not have a member called strSQL, hence the error.
What exactly do you want to show in the messagebox?

I don't actually want a messagebox, i need to place, in a...

MsgBox rs.strSQL

almost the final line, it highlights, the .strSQL bit.

I did try to change the SQL to something more basic like :-

strSQL = "Select * from Documents"

but it still does it.

I'm trying to query an access database from within word.

I want to compare a documents issue number (placed on the document), with what a database says it is.
eg
on the word forum

Issue 1...

Creating a database at work, and it all works fine. Colleague took it home and he gets these errors:-

Your Microsoft Office Access database or project contains a missing or broken reference to the...

Don't know if anyone has come across this, or knows where i might look...

I have a long standing database running on our server. the Back end is on the server, along with the mdw file.
The front...

Muchos Gracias.

Ok.. this is really an Access problem i have with some labels.... but i guess it doesn't belong there, and i'm useless at math...

so here's the problem..

I have a grid, running 1 to 64 like...

Have done so. many thanks

Previous code worked ok... trying to split it into a function... when i do so , i get that error message.

<font color=red>Private Sub Command200_Click()
Dim objWord As Word.Application
Set...

Perfect.. cheers hans.. will make that another beer. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>


you know your almost up to a case !

Thanks hans,, will work on that...

Do you know a way of referencing the picture ive added directly?

If i use this code, then the picture i have just added is not always picked up, but a...

Yes, its a linked picture..

the BMP is stored on the hard drive.

I found this article on microsoft..

http://support.microsoft.com/kb/124862

So far, i've managed to get a picture into...