troubleshooting Question

Adding Multiple Records with same information

Avatar of Ernest Grogg
Ernest Grogg asked on
Microsoft AccessVB ScriptVisual Basic Classic
7 Comments1 Solution115 ViewsLast Modified:
Hello,

I would like to see if I could add multiple records with some information that is the same throughout the table.

What I would like to do is have some fields that would repeat the information and fields that have a "through" would be unique...example below:

Field1: 1
through
Field2: 10
Field3: John
Field4: Doe
Field5: (111)123-1234
Field6: Blue Visitor

so it would be:  Enter the Batch of Cards Issued:  1   THROUGH    10
or someone could enter:                                         1   THROUGH   1

Field's 3-6 are the same that would repeat in the records.

so I would like it to enter separate records...if 1 through 10 (so it would be 10 records entered) or if the person entered the same info:  11  THROUGH 11 then there would only be 1 record entered
so the Table would be setup

for the multiple entries you would have multiple entries:
Field1: 1
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

Field1: 2
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

Field1: 3
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor
.
ect...

so for the single record you would have 1 entry in the table:

Field1: 11
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

ect....

don't know if I could do this with VB and how could I do this?  this is also thinking ahead but the same concept would be if I wanted to return those cards, I would have a similar process that would enter a separate field that would show it returned and repeat it also....
ASKER CERTIFIED SOLUTION
Abhigyan Srivastava

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 7 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 7 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004