Search results

Ok, so i have a similar code and problem. i am double-clicking a listbox that i am using as a search tool. once double-clicked, the code ought to take the user to the patient form, select the correct patient (not by filtering the form record source, because i still want the form to be used to...

it would seem that your lstSearch bound column is ContactID. if you want to also use the CallID column from the same list box, you need to tell access to use a different column to the bound one. remember access begins counting with 0. so column 3 in a listbox would actually be .Column(2) for...

ok, i found a different solution, though i'm not sure it's any more elegant, just doesn't have as many "hidden" things ...it's all in the code. i added some requeries on the "On Current" event - this works for my form because it's a single, not continuous form. i suppose my data lends itself to...

Hey, this is exactly what i am experiencing except my combos are on a single bound form (neither datasheet nor continuous). This solution was also detailed more recently here: http://www.access-programmers.co.uk/forums/showthread.php?t=198989 but i was wondering if this is still the...

ok, so. if we did want to put the two storage tables together as one, how would we deal with the repeated IDs for the two different source tables? that is, there will be an isolate with ID of, say, "2", but there will also be a sample with ID of "2"... so if the storage table simply has a...

false alarm. we have spent all this time arguing, though. hopefully keeping it all separate won't cause issues down the track... *sigh*. if it's any consolation, isolates and samples are two very different things. samples are components from people, whilst isolates are bacteria grown from...

i think we have a victory (though i won't count my chickens until they hatch) - my supervisor just said "don't kill me, but - can't we just have them in one table?" (gaaaa! that's what i said to him 2 days ago and he ARGUED about keeping the data separate blah blah blah... sheesh). at least...

thanks Chris, as for normalisation, tell me about it! i'm still working heavily on my supervisor (who is the main guy putting this together) to combine these. he wants to keep them separate for political purposes, so it's hard to make him 'see the light'... i'll keep trying though. gotta...

Hey everyone, we have this strange behaviour of our relationships in relationship view. the scenario is that we are adding a second instance of some tables and trying to add relationships between these and another table. what access is doing is changing the relationships we have made back to...

Sue, this solution may also help you. it was for a different request, but sounds similar to your need. please note the final working solution is described in post #18, but you may need to read the whole thread to fully understand.

have you tried nz()?

yes, i've used it lots before. comes in really handy, especially if you don't want to run a whole routine or refresh a form just to get something. it also helped i figuring out the discrepency between access and excel in executing a mod calculation.

ah, yes. that seems to be an important distinction. as for Dmax in the immediate window - yes, it worked. not only returned something, but the right thing!

that did it, thank you vbaInet. useful to know about that limitation in the immediate window...

hi everyone. i have a form. i would like to return the max date from, a field in a table which is not bound to anything on that form, into a form textbox control on the form. googling around (and searching this forum), i've only found threads where people are wanting to get max values from...

FYI, i've made the form a sub and put it on a normal-view form. also had to remember to change the view of the new form in the VBA(!) to normal and it works a treat. thanks everyone.

ta. i think it's worth giving every (well, most!) ideas a chance. you never know when it will be that perfect solution to something else ;) i had many moments like that when i was first learning - when the 'penny' dropped about something or another.

i thought about doing that too. it would make it easier to have the two processes happen in one procedure. also, wouldn't a loop use up a lot more resources than without it? especially if the user took a long time on the form? i mean, how often does it check for a change in variable? (i.e., how...

bloody microsoft! ta. that's a good idea.

thanks. no, i tried that - doesn't work. edit: that is, my code still runs when it shouldn't. my understanding is that DoEvents doesn't 'pause' or 'wait' for anything, just makes it run outside Access (i.e., on the processor)? here, my issue is that the code below the open form runs...