Search results

  1. thisisntwally

    How to Automatically Select a value in a Listbox

    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...
  2. thisisntwally

    Totaly lost

    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...
  3. thisisntwally

    Totaly lost

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

    help with gromits search form

    a grateful and startlingly good looking young man once said
  5. thisisntwally

    help with gromits search form

    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...
  6. thisisntwally

    help with gromits search form

    boblarson you are the freaking man.
  7. thisisntwally

    help with gromits search form

    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...
  8. thisisntwally

    set txtbox Value to Environ()

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

    getting value from one form into a combobox on another

    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...
  10. thisisntwally

    set txtbox Value to Environ()

    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?
  11. thisisntwally

    set txtbox Value to Environ()

    nope. this still leaves the field blank :( .
  12. thisisntwally

    set txtbox Value to Environ()

    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...
  13. thisisntwally

    set txtbox Value to Environ()

    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...
  14. thisisntwally

    Still trying to link two forms together

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

    Still trying to link two forms together

    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...
  16. thisisntwally

    Still trying to link two forms together

    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...
  17. thisisntwally

    Still trying to link two forms together

    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...
  18. thisisntwally

    Still trying to link two forms together

    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...
  19. thisisntwally

    Still trying to link two forms together

    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...
  20. thisisntwally

    DoCmd Apply filter

    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.
Back
Top Bottom