Search results for query: *

oh ok. still doesn't work... haha. I unbound both the form and the combobox. =(

hmm... still is not working. I wonder what I'm doing wrong... I posted my project file, if you wouldn't mind taking a quick look CMP. thanks! www.thepixelsink.com/other/testing.zip

meaning... when you hit the spacebar on your keyboard, the blinking cursor moves forward a space. instead, it gets moved back and a user cannot insert spaces into their query. Instead of typing "a word here", they can only type "awordhere" and the results don't come up accurately. thanks

thanks CMP... for some reason, only the first value in the listbox is being updated... nothing else. and it's not even selected. I'm using: Private Sub AppendButt_Click() Dim itmSelected Dim strInClause As String Dim sqlUpdate As String 'Loop through the list box and build a string we will...

also, CMP... you make the note "you may need to wrap the values i.e. text values, will need to be wraped in double quotes"... my values are indeed text values. what do I wrap in quotes? thanks!

Wow, thanks. for 'NewValue' and 'FilterField' I'm a little confused. I've got a combobox with Row Source Type = Value List and Row Source = ""Option1";"Option2";"etc How can I incorporate this? thanks so much for taking the time to code that out. =D Barny... the listbox contains the field...

no, it would be used many times.

Hey guys, I've got a listbox that is filtered down depending on the values a user puts into an input box, on-the-fly. However, the requery onchange doesn't allow users to add spaces to the search field. I'm using the code: Private Sub textText_Change() Me.lstList.Requery Me.Recalc...

so, I'm not great at code... maybe someone could help me out here... =D so on event...(button click) [Form].lstname.ItemsSelected (something) value selected in combobox, append to record go to next selected object in listbox... append combobox selection to record...etc, loop hmmm...

yeah... an update query... probably. just not sure how to structure the code or where to begin. PHV, let me take a look at what I can find about ItemsSelected collection... thanks!

Hey guys, I was just wondering... I've got about 300 records that I need to update one field to the same value. I was wondering if there was a way to edit all of them at once? Ideally, I've got all the records displaying in a multi-select listbox on a form... you can select 35 records or so you...

Hey guys, I'm having a problem maximizing a form... the form opens automatically when the DB does and maxmizes using this code: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i End Sub but when I open...

oh, I got it rural... thanks! ;)

so I've created a button on my main form that onclick does "Me.TabCtl1 = 1" ... but nothing happens. I'd like it to go to the second tab. am I using this wrong?

can anyone tell me how you can navigate subform tabs when they are set to "none"? I'm trying to figure out how to setup a button that would jump between two tabbed forms. thanks!

Hey guys, I have a subform appearing to display some info and I'd like to be able to hit an "edit" button which loads a form to edit this info. Basically, what I'm trying to do is have the form open and go to the record that is open in the original subform. So for example, if I'm viewing Record...

k. will do. thanks Mark

haha, sorry... I've been out of the office all afternoon! but yes, I am playing with the code and trying to troubleshoot the error. I don't have the most experience with code at this point, but I can run it by my buddy later today... he is a wiz with this stuff. But he doesn't let me play around...

PHV, that makes sense... I don't know how to write code yet though. I'm learning, very slowly. haha. Could you (or anybody) help me out with the code in either of those events? thank you =D

oh you guys are right on the money. =D Tom, I will tweak the code a little later tonight and see if I can't get it working with my queries. But I know what you're doing. thanks a bunch!