Form creating problems...

[slenish]

Im not sure if this is possible or not and from a lot of trial and error i have found a way to create what i need but i feel its not very efficiant.

Ok here it is I am trying to create a form that can be used to enter in names of different people and their date of birth. But i want to be able to enter in many names at once and not have to type them one by one and save them one at a time.

So for example at the top of my form I have enter todays date, and lets say company id, now under this I have 15 text boxes going down that you can enter in the names of say 15 new employees and another box next to that where you can enter in each persons date of birth. What I want to have happen is after I have entered in all 15 names and dob I can press a save button and all of those names will go to a table/query and save in a column titled Employee name. Each name will save in a row going down the column along with their date of births in the next column and todays date and company ID will automatically copy and save along with each persons name in seperate columns. So i am wondering is this possible?? From what I have played around with I have found you cant do it unless you create in the table a section for each name such as name1 name2 and so on. I would like to make it so i dont have 15 columns going across for every single name.

any help would be great thanks!

[slenish]

Also to add to this does anyone know if using something like Visual Studio Datebase devloper would be better than using Access??

[hedges98]

Does the company ID change at all?

Unless I've missed something, couldn't this be achieved using continuous forms?

[topher23]

For the Database Developer software, you will need an SQL server (be that MS-SQL, MySQL, whatever). For Access, you don't need a server connection. That's what makes Access great for prototyping. Then, if you need to upsize to a server-based solution, you can still use Access as the front-end by linking the tables on the server-based SQL database or use Visual Studio, PHP, SharePoint, etc. to create an entirely new front-end.

[topher23]

And hedges98 has the answer you need. Set up a form with a Header, detail, and footer. Put your info that won't change into the Header, put your employee-specific data into the detail section, then set the Default view in form properties to Continuous Forms (the default is Single Form).

With a little bit of playing around, you should be able to get it to work for you.

Also, you don't need a Save button, as bound forms save their data automatically into the table or query that is the Recordsource.

[slenish]

Hi Hedges and Topher,

Well the company ID could change but I want it to save the company ID as the same ID once for all 15 entries then when you press save record it saves all of them to a table and the form is fresh again.

After entering in the first 15 names the company ID could change or it could be the same again.

So basically when I go to pull the information I want to be able to see all the names in one column then the company ID attached to each name and the date they were entered so in total there would be 3 columns.

something like;
Company ID............. .. Date
1234........... ...... 3/3/2010

Name
Adam
Aaron
Alex
Bart
Bret
ect...

Then in the table it would look like this

Comp ID........ Date....... Name
1234....... 3/3/2010...... Adam
1234...... 3/3/2010....... Aaron
etc...

Apperciate the help :)