Search results

  1. A

    More numbering / best approach

    *pondering* I'll have to talk to the project lead that requested the database. I suspect that we care more about the individual samples and how they score than we do where they are located during the screening. I can kind of see a set up in my head, though, where, when sampling, rather than...
  2. A

    Are you an atheist?

    Yes. I tend to use Eostre as the Goddess name and Ostara for the holiday. *shrug* Just the way I was taught, I suppose.
  3. A

    More numbering / best approach

    Perhaps this is better shuttled to another thread, but did you build out your own system or purchase one of the varies add-on packages that's out there? (Those samples are of plants that will go on to be the next generation. So many things that need labeled, and labeled in a way that can...
  4. A

    Are you an atheist?

    There's very little, aside from a few lines from Bede and Grimm, to support Eostre as a historical goddess. That being said, as a Pagan, I celebrate Ostara over Easter. I've always loved the story of the "Ostara bunny" that was told to me when I was in college (keep in mind that I've never...
  5. A

    More numbering / best approach

    I agree. I do not, however, hold the purse-strings. The use of my time alone is a non-zero cost, and I've found software that is less than that. I do not always understand why certain decisions are made, which, I'm sure, is a problem we've all experienced at one point or another. I find...
  6. A

    More numbering / best approach

    I'll have to look into that. I suspect that the current task is above my current skillset, so I've been looking into more learning resources. Fortunately, this is the kind of project where it's okay if I hit a wall and tell the bosses that it's beyond what I can cobble together. (I started...
  7. A

    More numbering / best approach

    It's currently done manually in Excel, to the tune of 10k or more samples a week. The Excel files (and there are hundreds of them) barely open on most of our computers, which is why I've been tasked with getting it into Access. (The hope is that eventually the information in Access will port...
  8. A

    More numbering / best approach

    I'm working on a database that my scientists can use to submit samples for analysis. I've got the piece working where they can say the number of samples, have it insert the correct number of lines (into a temporary table), and the pieces are automatically named (sequentially). I also have it...
  9. A

    Nature shot, nesting Falcon

    It's technically possible, if the wood was unprocessed (ie, not heat treated or sealed) for it to regenerate into a new tree. Far more likely, I think, is that a sapling started near the base of the fence post, and grew up around the wires. Plants, woody plants especially, will grow around...
  10. A

    Use VBA to increment field on a continuous form

    Nuh-uh. You won't get me there. I've broken too many things to not play around in a tester first.
  11. A

    Use VBA to increment field on a continuous form

    Yes :) I caught it. Just thought I knew what it meant, and was wrong. That worked for me, and you are officially awesome! Time to transport this from my CodeTest database to the real one! Gonna bang my head against the wall a bit with my other problems before begging for help again :)
  12. A

    Use VBA to increment field on a continuous form

    What I end up with showing up in my table is the entry "TESTDATA-000" for all of the inserted entries. Inserted into the field [PlantName], the second field in the list. Here's the relevant section that includes the changes. I feel like I'm missing something really obvious, like a comma or...
  13. A

    I used to be a biologist, anyway...

    I laugh every time someone at my company refers to me as the resident computer expert. I'm good with computers. I can wrestle them into submission most of the time, but I haven't taken a programming class since BASIC was all the rage on my Apple II/e. I have to admit, I've been lurking on...
  14. A

    Use VBA to increment field on a continuous form

    Please don't laugh at me if it's an ugly mess! ;-) Private Sub Image22_Click() 'Define variables. Dim MySQL As String Dim MyCounter As Byte Dim Entries As Byte MySQL = "INSERT INTO TempTable (Planting, SampleDate, SampleResearcher, gene1, gene2, gene3, gene4, gene5)" MySQL = MySQL & " VALUES...
  15. A

    Use VBA to increment field on a continuous form

    I have a form that is being used for sample submission. Ideally, the user will be able to put in some information (3 or 4 fields) and the number of samples that they're taking, click the arrow and it will insert that number of samples into a temporary table that is then displayed on a...
  16. A

    I used to be a biologist, anyway...

    My name is Amber, and I live in San Diego. I currently work at a biotech, and at one point was asked to start keeping track of our data in Access. That has, of course, ballooned, possibly past what I can teach myself. (Who needs a LIMS system anyway?!?) I'm my company's resident computer...
Back
Top Bottom