Create rows based on cell value in different table (access)

%3CLINGO-SUB%20id%3D%22lingo-sub-1421400%22%20slang%3D%22en-US%22%3ECreate%20rows%20based%20on%20cell%20value%20in%20different%20table%20(access)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421400%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22x-hidden-focus%22%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20Access%20VBA.%20See%20Attach%20screen%20grab%20of%20the%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20we%20have%20the%20number%20of%20offspring%2C%20we'd%20like%20for%20access%20to%20auto%20create%20that%20number%20of%20rows%20in%20the%20AnimalID%20table%20and%20fill%20in%20the%20AnimalID%20that%20are%20the%20ClutchID-%23%20of%20each%20offspring.%20This%20would%20save%20time.%20Right%20now%20we%20are%20manually%20retyping%20the%20TES-2020-02-%23%23...%20for%20every%20snake.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assuming%20this%20will%20need%20to%20be%20done%20in%20VBA%20but%20I%20have%20no%20idea%20where%20to%20start.%20I'm%20a%20novice%20when%20it%20comes%20to%20VBA%20in%20excel%20and%20a%20toddler%20when%20it%20comes%20to%20access%20VBA.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1421400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Greetings,

 

I need help with Access VBA. See Attach screen grab of the tables.

 

Once we have the number of offspring, we'd like for access to auto create that number of rows in the AnimalID table and fill in the AnimalID that are the ClutchID-# of each offspring. This would save time. Right now we are manually retyping the TES-2020-02-##... for every snake.

 

I assuming this will need to be done in VBA but I have no idea where to start. I'm a novice when it comes to VBA in excel and a toddler when it comes to access VBA.

0 Replies