Is This Possible?

[JPW]

Not sure if this falls into the reports, query or macro part of the forum so I'll post this simple question here.

I have a fully working database that records car information. More or less every day we print of various letters for that vehicle. I have been tasked with making a database look and feel very, very simple with minimum forms and clickin involved.

I have at least 8 macro buttons on the forms screen linking to query and reports that print off a certain report, and those work fantastic.

However, I would like the database to record what letters have been sent without having to flick through all the records. I know if I put tick boxes within the form setting up a system would be possible. However, I don't want any more tick boxes I want it to react the the person clickin on the macro button to print report then it records that information.

Is this possible at all?

 

[GaryPanic]

sure that should not be too complicated ..
now what you need is a letter history table

once button 1 has been push - which creates letter this letter (I presume these are all preset letters ) will need to be added to the letter histroy table

so button 1 = report letter 1
button 2 = report letter 2
etc

now if it is this easy and you never deviate from the letter issue (no free form ) then all you need to record will be
the record source - which will be the PK from your underlying table
the letter (I have mine set up as numbers -letter 1,2 etc) and the date sent
you can then use either an append qry or the add. fuction to populate your letter hsitory table

if you are doing free from letter which could change then you need a differnt route -
outline of which is similar to the above but
PK underlying table
name and address
subject
bodyofletter (memo) field
if its this option then you need the .add fuction for sure or alternative look at the letter writers in the samples

gp

 

[GaryPanic]

also the on click of the button could punch a date and flag a letter sent yes/no option - i have all of these options built into mine d/base

one of which is is a standard doc sent- click report produced and next to it a date field with the date - if you need the date field unchangeable then tweak with coding - or have a hiddne yes/no box on the table and flag it to allow updates when no and not when yes then the button once pushed will be to flag this as yes ..