Search results

Ah. that would require me to learn about them and know how to use them! i've read a little bit, and tried a couple of things on my code, but to no avail. Since i'm short on time, my workaround is to have an "apply settings" button, which triggers the action queries to run separately. Though...

hey everyone, i've improved on the code/process a little bit: made the delimiter a declared string, and used the length of that string (i.e., "Len(strDelimiter)") to trim the end of the concatenation (so that i can change the delimiter and not worry about changing the number of characters to...

Hey guys, i'm having the same issue except the code runs through the acDialog every time. here's the code i'm using, it's pretty basic: 'open the targets form so changes can be made DoCmd.OpenForm "frmTargets_Display", acFormDS, , , , acDialog 'open as dialog, so the next code runs...

no worries. i'm sure one day i'll have a setup that requires two unique IDs :) kudos for helping out :)

ok, i have SORT OF managed to get the code, reference by HTC, to work. the only problem i'm getting is that it returns ALL "sub-record" data for every parent record, rather than just those it's supposed to. i.e., returns something like that (using allen browne's code - i've managed to order the...

thanks HiTechCoach! looks like what i'm after. i'll play with it sometime this weekend. John Big Booty, yes, sort of. i wish to combine them as you say ("concatenate" was the keyword i couldn't remember yesterday!), not just for display but for pattern analysis and graphing, so HTCs reference...

hi everyone, i'm looking for hopefully an easy solution to something i don't even know where to start (query/report/VBA?) i have a set of normalised data - basically samples vs positive results ("targets"). looks something like this: what i need now is to generate a string of the results to...

Khalid, this might be a silly question (because you said this all worked in a prevous version of access, if i recall correctly) but i just want to make sure that your InvoiceID is the ONLY field in that table with Autonumber data type...

Hi HiTechCoach, thanks for those links. i myself have found myself in the market for more sophisticated documentation techniques (than code remarks and word!) in my googling i came across CSD recently but it the website says CSD is not yet compatible with AC2007, which is the version i'm...

yes i thought about that, i may change it when i have the time. alternatively, the button looks like a button to be pressed (to novice users). a label just look pretty. i prefer pretty, but don't always have time! ta to you other guys who agree with having just one form! :)

after some fiddling, i have discovered that the openargs method DOES work on continuous forms, so long as the FOCUS can be brought to the correct record. with my fancy label 'button', this was not bringing focus to the record. when i changed this label to a real button control it triggered...

hi bob, thanks for the reply. i just realised that's what it looks like, but i have an afterupdate even which does trigger a 'find bookmark'... and it works when receiving an openarg from a different form (which is not a continuous form). incidentally, it does WORK when receiving an openarg...

hi jadefury, like explained previously, openargs is a way to send information from one form to another (or a report etc), so, rather than 'just' opening the second form, we open it at a specific point (or do something else specific to that case, as i described in my earlier post with report and...

i have used this in the past very successfully - very handy thing to be able to do. i used it when i was sending different recordsets to the same report, and needed to change the title and other bits depending on what the data was. however, i used the split() command thus: If Not...

if i could piggy-back off this thread... ta. i have an open argument framework already in place between two existing 'normal' forms (i.e., "form view") of my database (frmItems to open specific record in frmSuppliers: which works). i now wish to utilise that framework to open frmSuppliers from...

no VBA required: just add a listbox control to your form. access will show this you select "Find a record on my form based on the value I selected in my listbox" and then click next. access asks which field you want to search, select the ID and the Employee name and then click next...

like i said, the easiest way to navigate records in a form (for me, anyway!) is to create a listbox and then have access find your record based on your selection. as for navigation buttons - and also i usually remove record selectors unless i'm using datasheet view - is show below. select form...

sorry, that's my bad - on this forum it can be assumed when someone says they're new to Access, they usually mean they bought their first computer yesterday... sorry for the misunderstanding! (i was impress with your normalisation, though!) i almost always disable the record navigation at the...

westbandints, i think the best thing for you to do at this stage is hop over to your nearest bookstore and pick up a book on access basics. make sure the book is on access 2007 as previous versions are much different. also look out for books with lots of pictures, as one of the hardest parts...