Search results for query: *

Hi Guys, Just wanted to say a BIG thank you for all your help, it works great now thanks to your suggestions. It was actually Terrys suggestion that did it for me. Thank you again. David

Hi Guys, Just wanted to say a BIG thank you for all your help, it works great now thanks to your suggestions. Thank you again. David

Hi guys, Thank you all for your suggestions but this just went from bad to worse. I tried Dougs suggestion and nothing happened so I tried erogla's suggestion and still got the multiple records so I changed everything back VERY carefully and now when i try to open the form access gives the...

ANY suggestions Guys n Gals PLEASE!!!!!!

Hello I have a problem with a listbox showing duplicate records when I want it to ignore them and just show ONE instance of the record. Allow me to explain. I have a listbox based on a query that displays a list of items dependent on what a user selects in a combo box on the same form. For...

Hello I have a problem with a listbox showing duplicate records when I want it to ignore them and just show ONE instance of the record. Allow me to explain. I have a listbox based on a query that displays a list of items dependent on what a user selects in a combo box on the same form. For...

Is there a kind of "move to next record event" in Access 2000 and also how do I make something happen when the TAB key is hit. Move to next record event. What I want is Access to perform a action (in this case resting a controls property) when the user changes from the current record...

Hi CosmoKramer, Thank you very much for your posting and your comments - I will be sure to consider them in the future. As you and Lonnie asked, The text box in which I wish to enter the data is a plain "Unbound" text box and the combo box that runs the list box is a bog standard...

Hi Lonnie, Thank you for your kind offer, I have tried to send you a sample DB twice now but each time it gets returned. The file I am trying to send is just under 3MB - is that too big ??? Let me know, Regards, David

Hi fellow forum members, I still need help with this problem if anyone can suggest anything - its really driving me mad. Such a hard thing to do for such a simple task. Kind regards, david

Hi fellow forum members, I still need help with this problem if anyone can suggest anything - its really driving me mad. Such a hard thing to do for such a simple task. Kind regards, david

Hi fellow forum members, I still need help with this problem if anyone can suggest anything - its really driving me mad. Such a hard thing to do for such a simple task. Kind regards, david

Hi Lonnie, I am not doing anything special that I know of. The combo gets its data using: Row source = SELECT [tblTrackTitles].[TrackTitleID], [tblTrackTitles].[TrackTitle] FROM tblTrackTitles; It also has an onchange event: Private Sub TrackTitle_Change() Dim txtSearchString As Variant Dim...

Hi again Alcar, Ok did that and this time as soon as i had typed ONE letter in i got: Runtime '2237': The text you entered isnt an item on the list and when i tried to backspace the letter in the text box i got: Runtime error '94': Invalid use of null. Wow for such a simple function as i...

Hi Alcar, Thank you for your kind reply and suggestion. I tried it exactly as you suggested but got the following error: Compile error Variable not defined, and the following line is high lighted in yellow "Private Sub txtbox1_Change()" and the left hand word "Text" from...

Hi sbohman, Thanks for your reply. Nope in the error message it only gave the numbers but just in case it matters, I am using Access 2000 and limit to list is set to yes for the combo box. Regards, david

Hi Lonnie, Yes, I have limit to list set to yes? regards, David

Hi Lonnie, Thank you for going to so much trouble for me - I REALLY do apprciate it. I used the code exactly as you said and I now get a debug box error message: Run-Time error '-2147352567 (80020009)': The value you entered isn't valid for this field. Could this be caused by the way that my...

Hi Lonnie, My e-mail is david2001@starmail.com. Regards, David

Hi everyone. Thank you for your replys, i appreciate them, To janeC: txtbox1 is unbound and Yes, there will be spaces and maybe numbers as well. To sbohman: Thanks for the code, I used it exactly as you suggested but it did not work. As soon as you perform a keypress in txtbox1 (and even...