Recent content by ed_the_unlucky

finally figured it out--rolaaus, you suggested using the builder to get the correct syntax for the reference and of course, that turned out to be at the heart of the issue, once i cleaned up a few things. thank you, guys! ed

rolaaus: the dates are defaulting to the current, but the user can opt to change them. and there is an expressed desire to make data entry on the form a necessity, which will not permit me to prompt for the parameters within the query. ruralguy: an excellent point re: debugging, shall attempt...

guys, thank you so much. i'm a bit tired and hence am having trouble keeping the details straight. on open event: the code in my previous post runs and automatically runs the report based upon a default period of time, then e-mails it. the form itself: there are 2 text boxes for the user to...

bob: thank you, but for some reason, while i understand that, when the query runs, the parameter is still not understood. i'm realizing now that the subform is housed in a tabcontrol on the main form. have i just made a mess of this? ruralguy: gosh, i'd honestly forgotten! i'm not sure that...

ruralguy: um...either i'm being obtuse or i didn't explain properly, but that might all be irrelevant. OK, i believe this is now in the wrong subforum but apparently, i'm passing the date from the form to either the query or the resulting report incorrectly. i am using...

oliver: i know you can by going through the properties, which implies that it should be possible, although i second ruralguy's question: why is the database window visible in the first place? ed

rolaaus, thank you for the prompt reply. am attempting your suggestion but the reference is not recognized by the query. ruralguy: i'm not sure i quite understand your clarification re:syntax. am using forms![switchboard].[subform].[controlname], but you mentioned...

i have encountered a situation i don't understand. i have a subform that runs some VBA on the on open event. (code takes 2 dates from textbox on form, runs report, e-mails to user.) when i open the subform independently, everything works fine, but when the main form opens, the code doesn't...

OK, i see that what i'm doing here isn't working b/c the query is passing a result of 0 records, and i'm doing a sum on that field. but i still need to try to produce this figure, the result of a static weight and which may have 0-3 records reducing the weight. and i'm at an utter loss re: how...

thewilli: if it's structured member1, member 2, etc., i would think that you could write a procedure to run the same append query the requisite # of times, no? am i missing something? but 168 fields?! don't tell me it duplicates [fields] for each of the 1-20?! ed

darn it. so lookups within the table proper are bad b/c they introduce bloat, are inaccurate, and add a layer of complexity without adding any value, then? i didn't know that. thank you. ed

i would think that if you did a simple select query based upon the field(s) that define dupes and ran a delete query on the resulting records, that would do the trick, no? i guess the real question is what defines uniqueness? ed

you can simplify your life by adding a control source in the table proper, on the second tab of the field properties. that way, when using the form wizard, if you use it, it will create a combobox item rather than a boring old text box. if you check out the properties of the combobox, on the...

interestingly, that seems related to an issue i experienced last night, and i was wondering if perhaps it was merely fatigue that made me see things last night. i'm working in access 2000 and at various points, i made some substantial changes to my form. i selected save as, gave it a related...

i definitely agree it sounds like the control box & borders have been disabled, but that's easily fixable, fortunately--unless you've got a .mde rather than a .mdb, i suppose. that's not the case, i sit? ed