Search results

Dear All, Going through my records on a form using the forward button I get an error message when go to the new record. The message indicates there's an operator missing in the expression: "PublicationID=" This expression is there to show or not show a label depending on a value and works...

Hi everybody. I've posted this a few days ago but haven't had a reply yet. Maybe my problem is just too simple for the experts to be interested but I really haven't got a clue how to solve this puzzle. Can someone please guide me a litttle here? Thanks, Wally

Yes! That seems to be the one I'd like to be able to search multiple fields (text, number and date) from multiple tables so I guess your last pointer is the one I was looking for. Thanks again Jack and I'll start working on it and hope to get it going soon. Walter

Thanks Jack. I'll have a good look at that article. I use Access97 but assume that won't make a huge difference. Have a good weekend, Walter

Could someone please show me how I include a search option based on multiple keywords. Now that my DB is expanding I get too many hits on a single term. I'd like to be able to type a few terms with a space in between them and perform a search on those keywords. I haven't got a clue where to...

I have a from with 2 option groups, one is called Companies, the other Areas. The form also has 2 comboboxes, each controlled by one of the two option boxes. So far so good, the values change nicely to the selected company and area. One box holds 9 buttons, the other 5 so that's 45 choices all...

Thanks. Of course! I don't know why I couldn't think of that myself. Your guiding hand is greatly appreciated. Walter

What looked like to a pretty simple thing to design turns out to be not so simple, not to me anyway. I've been trying to make a database in which I can easily view what patents a company holds in a certain area. The start was easy enough, two tables, tblCompanies and tblArea with a coupling...

Thanks for your quick reply Mile-O-Phile, Unfortunately I don't know where to put that code! I've tried to paste it into the properties of the Deadline field (by clicking on the ... of the fore color) but that doesn't work. Excuse my ignorance but I need another pointer before I can proceed...

Dear members, I don't know if I'm asking a very hard question or not. I certainly am unable to find the answer myself so if you know how to solve the quetion below please let me know. I have a form and report with dates for deadlines in it. I'd like to use 'warning colors' with those date...

Thanks Pat and Fofa for the advice. Tables have been created accordingly. It will not surprise you two that it works just fine. I haven't figured out the append query part yet , no time yet, but will try to over this weekend. Thanks again. No doubt I'll be back for more on this great forum.

Thanks FoFa, It's an option that I've also considered but it means filing out an extra table by hand and with more than hundred publications and even more authors there's a lot of room for error. I was hoping that there's another solution for that, maybe some more complicated key actions or...

G'day all, I have a table that tblPublications with fields publicationIDNumber, Title, Author1, Author2, Author3, Author4 etc Many authors have contributed to multiple publications. I Also have a tblAuthors. This table has AuthorIDNumber (The same number I use in the author fields of the table...

OK! I feel like a real Wally again! Thanks for pointing out what must have been obvious to most, but not to me. One day I'll get it too, maybe...

Thank you Sambo. I haven't been able to get it to work yet but must admit that haven't had a chance to play around with it extensively yet. Hopefully later today. I'll report back how I go with this. Thanks again, Walter

Hi All, I'd like to be able to open a pdf format document by clicking on a small pdf icon. How do I do that? What I've done so far is insert the pdf icon as a bitmap image in one column and store the URL of the pdf document in the column next to it (hyperlink type). The URL works fine when I...

I still cannot get it to work properly. I've made a query (named qSearch), all tables are joined by one-to-many relations, selected the fields I'd like to search, filled in the criteria as you've indicated and made a form from that (frmSearch). When I start that form a little box pops up in...

Thanks Mile-O-Phile, I get a syntax error, it says an operator is missing. I'll play around with your suggestion a bit more though. If I don't get it to work I'll get back to you for maybe some more suggestions? Walter

Thanks David. I'll keep this one in mind. This method allows you to search multiple fields from as many search fields and is an alternative for what I'm looking for. What I was hoping to get is a method to search multiple fields from just one input field. The one input field for a search...

Dear all, I'd like to be able to open a PDF file directly by clicking a OLE-field. The way I've set it up is that in a table I have a OLE-object (Bitmap of PDF icon) and in the next column next (hyperlink field) the URL to the PDF file. I'd like to be able to open the PDF by clicking on the...