Search results

I felt the need to chime in here, though i have no doubt everyone already understands my motivation in posting, and could communicate this for me more clearly and more efficiently:eek: . That being said I have found this forum to be, hands down, the most engaging and educational access forum...

ok, im over the speaking dutch thing, as i dont really trust babelfish to accurately express myself. I think im figuring out what your friend did. I've got a meeting, but if you don't need this NOW i should be able to shine it up. Or someone with more experience could probably do this in...

verloren in Amsterdam ik zal kijken, maar u moet mijn Nederlands bevestigen.

a grateful and startlingly good looking young man once said

every success presents a new failure. or should i say opportunity to learn. either way, im trying to get this to search for records Updated Before, and Updated After certain dates. the after search gives at least one record before its cutoff, and the before returns none at all. ' Check for...

boblarson you are the freaking man.

im trying to tweak gromits Search Form and, after having adjusted the code, when i run it i get a "compile error: Method or Data member not found" Private Sub comSearch_Click() ' Update the record source Me.frmsubsearch.Form.RecordSource = "SELECT * FROM qselsearch " & BuildFilter...

thanks! i'll prolly keep the invisible reference box, and use a little of this and a little of that, depending.

this sounds a bit like a problem i was struggling with recently. As I understand it, you're unable to link off of information added in a new record, as there is no open record in the addform. I got around it, by always keeping a "blank" record, which I would then add the information to when...

Nevermind that, it works now. just a relationship snafoo. Is there any advantage to Pbaldy's technique of keeping the environ() in a txtbox on an open form? ie does it save all that much processing in its avoiding repeat function calls?

nope. this still leaves the field blank :( .

ahhh i was wondering if the pre-existing record was my problem. to get around an earlier issue, i have this form opening a semi-blank record. I was putting in the full function =GetWinUserName(), and understand that it was unnecessary (im gonna stick with the PF, as i'll likely be slathering...

i've declared a public function as so Public Function GetWinUserName() GetWinUserName = Environ("UserName") End Function thinking that i was clever, i set the control source on my form to =getwinusername, and boy oh boy - i open the form and bam theres my login name. still riding on cloud nine...

heh. this works now. while i had bound the form, the controls were still unbound. Thanks for all your help guys!

ok so almost everything goes as planned but the values entered into the fields on boundform [Input Form] fail to save to the record. from the pulldown menu: Sub openForm() DoCmd.openForm "Input Form", acNormal, , "[EntryStatus] = 0", acFormEdit, acWindowNormal End Sub on click event: With...

well in order to have an open record in form1(initial imput) which can link for form2(followupdata) im trying to create a perpetual record machine. form1 opens 'blank' record edits it *saves it (shouldn't this happen on close? well it doesnt work when told, to let alone on its own) form1 sets...

so, ATM oncomsave_click we successfully open form2 to the appropriate record, and close the form1. as i see it this should save the changes to the record, unless (i am thinking while i type) this is blocked by the record being open in the second form! (maybe i can figure this one out after...

I forgot i bound the form. that means something like this: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 would work? (stolen from gandalf) if a simple command will do it, can i still specify a field i want changed to a specific value? ie change entry status from 0...

Ive actually just solved the linking problem. You were spot on about the problem being that a form which makes new records does not have one open in it. If i need serious help again i'd be glad to throw it up. i'm pretty enthusiastic about this past and future form idea and as i like to...

Im sure I do not, but i would be interested to know more about this stupid limitation...as a llama i do not know what cannot (as of yet) be done.