Search results

Definitely AND is clearly established, which is what I want. I have tried with combination of 10 records and the results are perfect but as soon as I apply the criteria to a much larger database, say 2,000 records plus that is when it doesn't produce any (or incorrect) results. This indicates...

I have tried what you suggest but I get the same results, the query doesn't seem to like mutilpe 'Like' choices. The problem probably lies in what you suggest in using logical AND/OR statements. It's as if the process needs to be slowed down allowing the query to process the first request before...

How? I thought you could only build a query from a Table or another query. What you suggest is a good idea.

This is a problem that I thought I had resolved previously. I am trying to use 'Like' more than once in the same query so that it allows users to define the query using multiple selections. First selection is a Post Code using the criteria: Like [Enter Post Code Like NE20 or blank for all] &...

Thanks, spot on!

Could you show me an example of what you suggest but selecting three seperate criteria so that I can see how this would work with multiple slections? Your example form/table that I downloaded was very good.

I am trying to use a multiple selection query. First selection is a Post Code using the criteria Like [Enter Post Code Like NE20 or blank for all] & "*" Second selection is Business Type using the criteria: Like [Enter Business Type or blank for all] & "*" and finally Salesman using the...

Through a command button using a hyperlink my app opens a Word doc and populates the merge fields. The problem is that if someone opens the Word doc (without going through the database) and makes any amendments it destroys the hyperlink. You can make amendments if you access the Word doc...

Absolutely spot on - both ethe idea for a fe/be and the Transferdatabse method. Thanks your advice and help is greatly appreciated

Thanks for the link but it is too expensive @ 500$ for my meagre funds. I will look at the fe/be structure but I would still like to know how can I send just an update or addition for say a report or form that could be imported by a self executable file.

I have changed an input mask for one field on a form. I need to know how do I send this as an update in the form of an e-mail attachment. I also need to know exactly what the recipient needs to do to apply the update. Normally I just import the update from one database into another but this is...

Hi John Thanks for e-mailing me your db so I could work out how to update fields. That would have taken me forever to work out, I have already used it on a test db and it has worked fine. If I find a solution to sending muiltiple forms/reports etc I will let you know. Unfortunately the details...

Right, all sorted and working perfectly, process as follows: I added an 'Ad Hoc Tag' Field to the table with a Yes/No box. Then I created a new form that referred to said table On the form I placed the Yes/No 'Ad Hoc Tag' box I then created a list box By highlighting a record and clicking...

This looks spot on, I will try later and come back to you, Thanks

Hi John, Not much luck so far as I need a bit of time to do this and it is at a premium at the moment, an example would be most helpful as I find it much easier to follow exisitng code etc. Also I'm not sure what you mean by a text box, I just type the info direct into the macro. Is this part...

Excellent, the transferdatabase method works a treat and because it is so easy it is better to transfer the whole table or from rather than adding a field. The only problem I found is that it's all OK providing the operator at the other end hasn't moved the database to another location (as I...

I have been asked if I can provide an ad hoc mailing list, a one off. The requirement is to be able to browse the database and click a radio button to identify which records should be added to the list. OK straightforward enough but a bit messy as you would have to go back through and remove...

Thanks John It has pointed me in the right direction although it will probably take me sometime to experiment with it. But I like your idea of putting the upgrades into a separate database as it makes it more logical to import it into the existing database so that you can import just the...

If I make a change to a form or report how can I update a remote database without them sending it to me so that I can import the new form or report? I thought that maybe sending something as a self extracting file but I have no idea how I would get it to just update the form or report. The...

Since changing to Windows 2000 the links to my access database have gone. I have re-created them and they worked Ok until the next time I came to use them and they had gone again. I have tried this on similar systems and it is exactly the same. I also use Office 2000 pro which if run on Windows...