Recent content by geekdom jester

  1. G

    form help! not able to add values and want to copy previous values

    thanks liv, but how do i get those query values into the control? say for example: cmbSkyCondition is populated by a value list that has clear, rain, fog, snow on it. if i query the day before, then how do i override the value list? is this right? me.cmbSkyCondition.value =...
  2. G

    form help! not able to add values and want to copy previous values

    Hi, I have an access db that is going to be used by laborers. it is a field report of how many people showed up at work, what the weather was, etc. i am having problems with it. 1. i have subforms and while the subform is allowin me to add rows to it (new record), the main form doesn't. it's...
  3. G

    macro: copy form

    is there a way for me to change the record source programatically? i am not good at syntax. is it something like dim tablename as string tablename = "form_y_table" form_y.recordsource = tablename thanks
  4. G

    macro: copy form

    each client is managed separately. each form acts like a spreadsheet that they need to keep and update periodically. combo box values are updated by a query and then account managers have to do some calculations with the values that they selected
  5. G

    macro: copy form

    Hi, i am trying to distribute a blank form_x to be the template for every new customer form. I created a macro that has these steps: open form_x copy form_x rename copy_form_x to form_y close form_x close macro it does the steps fine. problem is, whenever i update form_y, it also updates...
Back
Top Bottom