Re: Multiple Record Inputs with one Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Perhaps other newsgroup readers have a better idea what you are trying to
accomplish, and experience doing that. I've reached the end of what I
understand/know about.

Best of luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:604555DB-09B1-4A96-BF82-2CE58C442572@xxxxxxxxxxxxxxxx
Sorry for the massive posts... I was told to take on a job I have no
experience with the language... i found this:

Dim strSQL As String
Dim intCount As Integer

For intCount = 1 To Me![txtNumberofRecs]

strSQL = "INSERT INTO table (field1, field2, etc.) "
strSQL = strSQL & "VALUES(" & Me!TissueNumber & ", "
strSQL = strSQL & Me!field2 & ", etc.);"

DoCmd.RunSQL strSQL

Next intCount

This code looks like it will do what i want. Create a access table with
all
the entries from the form inputed. Lets say we start out with two
entries.
A Date the person worked and their Social. I have a form with two entries
for social security numbers. This is the code I'm working with now:

im strSQL As String
Dim intCount As Integer

For intCount = 1 To 2

strSQL = "INSERT INTO PayrollTable (Date, SSN) VALUES ( & Me!DateField &
Me!SSN(intCount) )"

DoCmd.RunSQL strSQL

Next intCount


"Jeff Boyce" wrote:

I'm sorry if I sound like a broken record ...

"making a database", by itself, is worthless ... having a database (a set
of
data stored somewhere) only provides work for the person who designs the
database.

Having a way to report payroll to the CEO, by month, is a business need.

"easier data entry" is, by itself, worthless ... unless you ALSO have
some
way of getting the data back out and doing something with it.

I really am looking for a better idea of what having easier data entry
and a
database (apparently payroll-related) will let you do.

If you only need to recreate a payroll form, you are taking on a
tremendous
learning curve trying to force it into a relational database.

If you entered data on an Excel spreadsheet, you'd simply save the file
...
THAT is a database, of sorts. What is it that you want to DO with the
data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:217CCA58-82E1-45D2-9AA2-10CC3E360A68@xxxxxxxxxxxxxxxx
The underlying business need is to recreate the payroll form, making
data
entry easier than to do by hand. Also to take all entries entered into
computer and store into a table and make a database.

"Jeff Boyce" wrote:

It all starts with the data. You're describing the forms.

Hint: whenever I see a description of a form "with 12 entries", I
suspect
someone has tried to convert a spreadsheet into an Access database.
Access
is not a spreadsheet on steroids, it's a relational database, and
requires
some new ways of thinking about data.

I'm still looking for a description of the underlying business need,
rather
than the approach used to satisfy the (as yet unclear) need.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08E5BF7E-CDC6-4437-A0F4-398A4BD4C363@xxxxxxxxxxxxxxxx
I'm working on a payroll form and there are twelve entries on each
"form".
I
want to be able to recreate this form that has been used as paper,
which I
have I just can not get the next record of information to be
separate
when
adding to the table. I actually double posted my problem....sorry
about
that,
the other titled Mulitple Record(12 entries) w/ form. She asked me
to
look
up an append query but I still have only basic knowledge of this SQL
language
from w3schools.com. Also when i create my form I can not seem to
separate
the
information entered in the text box name1 from name2 the same name
pops
up
on
both text boxes when i enter in of them. Thanks for your time

"Jeff Boyce" wrote:

You've described a "how" ... as in how you are trying to do
something
("send
more than one record to the table with one form").

Now, "why" ... as in what will having multiple records generated
from
a
single form allow you to do (i.e., business need)?

This isn't idle curiosity ... if we knew more about the underlying
business
need, we might be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7D0D8222-A344-40E4-99DD-CFD6A6EC850D@xxxxxxxxxxxxxxxx
I'm programming with SQL and can't seem how to figure out how to
send
more
than one record to the table with one form.











.

Relevant Pages

  • Re: Multiple Record Inputs with one Form
    ... Dim strSQL As String ... Lets say we start out with two entries. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Multiple Record Inputs with one Form
    ... Having a way to report payroll to the CEO, by month, is a business need. ... database will let you do. ... "Jeff Boyce" wrote: ... whenever I see a description of a form "with 12 entries", ...
    (microsoft.public.access.formscoding)
  • RE: repeated conversion of data summarized into rows and columns
    ... the database name, table name and field names I used in the code. ... Dim currentUser As String ... ' Column Pointer to work through Hour entries ... Dates and to the HoursDates table and containing a usage entry. ...
    (microsoft.public.excel.misc)
  • Re: Split database into smaller db based on values
    ... "Jeff Boyce" wrote: ... Disclaimer: This author may have received products and services mentioned ... I used Dirk G's code to build out a database for each level I need then ... included code in the Excel file that will copy the file from the sever to ...
    (microsoft.public.access.modulesdaovba)
  • Re: timesheet question - (Jeff)
    ... The database that is separated is ... timesheet is input from the employee, it is why I chose to separate ... "Jeff Boyce" wrote: ... Microsoft Access .mdb file? ...
    (microsoft.public.access.forms)