Recent content by EleanorG

Thank you - Thank you - I certainly do appreciate your help!!!!

Right - the click runs the query - and populates the list with the results but that blinking message box pops up even when there ARE results. I stuck the message box in as an afterthought and now it comes up with or without results from the query... Hope this makes sense

I have a search form...with a list box.. If there are no results - the message box comes up If there are results - the message box comes up I am totally bumfuzzled - Private Sub cmdSearch_Click() Me.Found.RowSource = "qrySearch" Me.Found.Visible = True If...

I exported my query in datasheet view.....opened it in dreamweaver and edited it.

I'm afraid I didn't explain well enough. There is one ItemRecordNumber for each video/set of slides. There can be various titles on the same video - Title1, Title2, Title3, Title4, Title5, Title6. I want to be able to put in "cruciate" as a keyword search and have it show me all the videos...

Another notch Is it possible to use this same code to search more than one field in a table. I got it to work but have a data base of instructional videos with more than one title on each video. Also could the query open something besides the table???

Thank you, thank you, thank you. You REALLY made my day!!!

I am trying to sort Library of Congress call numbers. I have broken them down into individual fields such as HD - alpha 32 - numeric B - alpha 32 - numeric [herein lies the problem] this is a number that needs a decimal at the beginning in order for this line to sort...

THANK YOU - I am not very good at this but with your help it is working now - you are wonderful

I must still be doing something wrong...I am getting a compile error [This message has been edited by EleanorG (edited 11-15-2001).]

I would like to put an updated date field on either my main form [Title] or the subform [Status] that reflects any changes in EITHER..if I put it on the form it only reflects the form changes and on the subform only the subform changes...I know it goes on the beforeupdate...I don't know what I'm...

This is an audio/visual database. There are titles relating to Veterinary Medicine..so I have cat, cats, feline, etc. Also things like horse, horses, equine. I created a search form that prompts the user for word in the title...I don't want titles with part of the word imbedded...like...

I have a search form...it searches for titles in a title field on my main form. I want to get all entries that include "cat" but I'm getting cattle, certificate, etc. I use the - Like "*" & [Enter Title] & "*" because I also want to search dog and get dogs. Is there a way around this. [This...