memo madness part 3! why wont this work?

[narcan2k]

okay.... here is the code:

Private Sub Command168_Click()

houselogsrchtbl.date = date

houselogsrchtbl.staff = currentuser

houselogsrchtbl.logentry = log_enter

log_display = " " & Now & " " & currentuser & vbCrLf & log_enter & vbCrLf & log_display

log_enter = Null

End Sub

What I want this to do is enter the information in 2 spots. The houselogsrchtbl.*'s are on the next page (seperated with a page break) log_display and log_enter are on the current page (same as the command button). the form is based on a qry that links the two tables together so that when a log entry is complete, the user will click the done botton and the entry will add to a memo field so thet is is viewable right on the screen as well as in an independant record in a linked table (page 2 of the form)so that the entries are searchable.

does this make sence???
god I hope so!
help please

 

[neileg]

does this make sence???

No.

I don't understand the following:

1) Why do you want to concatenate your data and store it that way, when you have the base data too? Or is the base data transient and you are only saving the memo field? Or what?

2) What is the relevance of page 1 and 2 of the form? Are these tabs on the form? The data is completely unaffected by where you want to display it.

3) What are you trying to do?

 

[narcan2k]

Okay...this is what I am tryin ta do..

Log entries for a group home. Staff will enter the log entries in a log enter field. It will display the log entry below in a display field with the ability to scroll down through the memo. When the "done" button is clicked, it adds the date, time and current user to the log entry for obvios reasons. It also sets the entry field to nil so it is blank for the next entry.
now in order for senior staff to search through the log entries, I wanted the done button to both send the text to the display field as well as to an individual record for ease of searching and displaying.
I have the first part easy enough, its the second piece that isn't working...I cant seem to make the entry move to the second set of fields (individual records). the table allows for searching by date and staff member as opposed to a big memo entry that is dificult to search and print in reports because of the size. the second page is on the form (page break) so that users can switch to the second page for searching etc. the form is based on a query that links the display and entry memo table with the individual recrd table mentioned above.

Does this make sence...am I going about this in an overly complicated way.

 

[neileg]

Does this make sence
A bit

...am I going about this in an overly complicated way.
Yes

I suspect that you are new to db design and have a background in spreadsheets. I say this because you are not clear on the difference between how data is stored and how data is displayed. In Excel, the storage and the display are the same (mostly), in Access, the storage and the display are independent (mostly).

So...
Let me set out what I think you want, and then how to go about this.

You want staff to log into your system, to let them see who has also logged in, and to hold the data for other purposes.

How I would go about this is to have two forms and one table.

Create a login form that is bound to your underlying login table with all the stuff that you need the staff to enter. Make this form open in data entry mode. Thus every time someone logs in, they open the form, all the fields will be empty and they will be unable to see previous entries. When they close this form, their data will be saved.

Create a second form that is bound to your underlying login table that displays the data you want your users to see about previous logins (this may, or may not be similar to the login form). Make this a continuous form and deny edits, data entry and deletes (this makes it read only). If you really want, you can concatenate the data as you have been trying to do, but I wouldn't bother. As a continuous form, users will be able to scroll up and down to see the data you want.

If you want both forms to be seen together, create a third, unbound form with nothing on it. Add your previous two forms as subforms on this form.