Search results

That did it Uncle Gizmo. Thanks. That intcounter was what I was missing.

That did it Uncle Gizmo. Thanks.

I have a form with 10 yes/no controls. The value of the 10th will be yes IF the value of all the other 9 is yes else 10 will be no. My question is can I use tags, or some other method, to look at all the controls rather than create an if statement calling out all nine controls with and? Is...

Yeah that's what I was afraid of. I get a bunch of messages now and then either an op calls me so I can tell them restart it or they just ignore it and don't put any data in until someone asks why they aren't entering any data then they just say it wasn't working. I even setup a message box...

I've recently encountered a problem with a stuttering network. The network loses connection just long enough to crash the front end of my database when a form requeries or does any update. So my question is this. Is there a way to suppress the inevitable bevy of messages about it and just...

Thanks arnelgp. That did it.

Morning ladies and gentlemen. I have a query with 27 fields. they can be "p", "q" or null. I'm trying to create a field that will give me a yes or no based on whether ANY of them are "p". I've tried this firstdone: IIf([a101] And [a102]="p","no","yes") which works fine until I hit a null...

Huh, I guess it just never occurred to me to try the me. anywhere other than in the vba. I'll give that a shot. Thanks.

Yes it is.

Yep, that's how I do it now. I was just wondering if I could make one subform that could be on many different mainforms without having to change the rowsource of the listbox to reflect the different mainform. I could make a copy of the subform specifically for each mainform, or I could change...

[Forms]![mainform]![subform]![control] is what I'm using.

I'm curious, if I have a subform with a listbox that looks up a value. So in the listbox the criteria for that field is [mainform]![subform]![control]. But what is the best way to make that subform usable on another form? It's easy enough to just make a copy of the subform and set the...

This is working great so far but... (there's always a but). I also need it to keep the items in the scheduled listbox in the order I move them over to it. I've added a rownum field that is created when adding something to the listbox using... rownum2...

That is awesome. I'm like a monkey pounding on a keyboard with a stick compared to that. Lol. Okay, now to look through your code and see what I can learn from it. I don't know access well yet so I do what I can get to work or what I can find on google. This will give me something to work...

Ok. lets try again. I seem to have most of it working (somewhat). I can select a group in the left and move it to the right.. although I've noticed that with large groups it doesn't always keep them in order. Bu the up and down, I've tried several different methods and can't seem to get a...

Aww damn. Didn't realize the attachment didn't send. lol. I'll try again when I get back to my pc at work. Didn't think to refer back to the other thread. Here it is... https://www.access-programmers.co.uk/forums/showthread.php?p=1534801#post1534801

Here's the challenge I have. I import data from an excel spreadsheet to one table called tbl_pendingschedule and add a yes/no field called scheduled. Then I have a form with two list boxes. The left one is all the units in tbl_pendingschedule with a no value in the scheduled field. On the right...

Here's the challenge I have. I import data from an excel spreadsheet to one table called tbl_pendingschedule and add a yes/no field called scheduled. Then I have a form with two list boxes. The left one is all the units in tbl_pendingschedule with a no value in the scheduled field. On the...

Well dang. I was hoping you'd be able to save me. lol. Ok. I'll think around it some more. For the warnings. I do turn them back on before the end sub... but that execute is a handy new piece of info for me. Thanks.

Thanks Static. That works well. But, if I may ask for your expertise a little more. Can that be adapted to work with this DoCmd.SetWarnings False Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim i As Integer Dim strSQL As String Dim strWhere As String Dim strIN As String Dim...