Coverting a Record to Multiple Lines

  • Thread starter Thread starter G Sandoval via AccessMonster.com
  • Start date Start date
G

G Sandoval via AccessMonster.com

I have a form made where people fill out information used to determine time
to . and a when they are done the button they push sends the info to a
table i print at the end of the year. the code i use looks something like
this...

Private Sub NewDate_Click()
' open database
Call OpenDB
' SQL Statement to be used.
strSQL = "SELECT * FROM PS_MWF_1130AM"
' setup recordset for reading data.
Set rsNewDate = New ADODB.Recordset
rsNewDate.Open strSQL, dbConnection, 3, 3
If Not rsNewDate.EOF Then
rsNewDate.AddNew
rsNewDate("Start Time") = txtStart.Value
rsNewDate("Finish") = txtFinish.Value
rsNewDate("Date") = Now - Time
rsNewDate("Name") = txtName.Value
however instead of all this going on the table in one line, i would like it
to be split into two lines
Name
Date StartTime FinishTime

Is this possible... sorry for the ling post... im a new access user so i
have a hard time explaing. thanks in advance for any help
~~~Gabriel
 
Hi Gabriel,

Instead of printing the table, create a report based on the table. That
way, you can print each record on multiple lines (and adjust the layout
in many other ways).
 
Thats a great idea. But now I have a follow up question. I want to use a
code or macro or somethings that will enable me to print the tasks daily.
I came across a code online that would filter the records to only show
those that have today's date. If i print a report can i still specify what
dates i want for when i want daily reports or yearly reports.
Thanks again for your help
~~gabriel
 
Create a query that returns the records you need, e.g. by using

Date()

as a criterion in your date field. Then base the report on this query
rather than on the table.
 
Back
Top