Search results

  1. A

    Button on form fills text box on subform

    Hi all, This should be relatively simple to do; I've Googled, and tried Allen Browne's suggestions, but I just can't get it to work and I don't know why: I have a form [frmTransects] and a subform [sfTransects_Distance]. The form records details of a transect observing animals. The subform...
  2. A

    Calculating greatest common denominator

    Hi all, I'm trying to calculate the lowest common denominator between the values of two textboxes on a form, [malerats] and [femalerats]. I'm using a function called Denominator, below: Public Function Denominator(MaleRats As Long, FemaleRats As Long) As Long While MaleRats <> FemaleRats...
  3. A

    Populate unbound control using DLookup(?)

    Hi all, I need to enter a value into an unbound text box on a form (frmCaptures) from a table (tblSeason). tblSeason specifies a SeasonID (eg. "2017-2018") and the start and end dates for that season (e.g. the 2017-2018 season starts in June 1, 2017 and ends May 30, 2018). I need users to be...
  4. A

    Importing from a text box containing submission from multiselect dialog box.

    Hi folks, This is a bit of a run-one from a previous post but I thought it was enough of a tangent to start a new thread. I'm using the following code to enter filepaths from a dialog box into a text box on a form, which then tells an import routine which file to import using the transfertext...
  5. A

    Importing mulitiple .txt files into Access

    Hi Folks, I'm attempting to import multiple tab-delimited .txt files into a table in my database. The files are then deleted (manually) and the folder gradually repopulates over time (one a day) with new files produced automatically by a weather monitoring station. I'm using the following to do...
Back
Top Bottom