[AccessD] Can I do this?

[Tina Norris Fields]

As a follow up - if I use temporary variables, this looks feasible.
TNF

Tina Norris Fields
tinanfields-at-torchlake-dot-com
231-322-2787

On 06/02/15 11:51 AM, Tina Norris Fields wrote:
> I'm making a database for a local law firm.  They have in place a 
> paper system that is complex, but, it works.  They are sort of ready 
> to switch to an electronic system, but, it has to look just like the 
> paper system already in place.  Once they know they can trust an 
> electronic system, they'll allow remodeling to simplify. That's the 
> situation.  I'm working on a particular part of the system now, and 
> could use some help.
>
> A new file number is created from a six-digit sequential number, a 
> dash, a two-digit number for the month, a dash, and a two-digit number 
> for the year, resulting in numbers (short text) such as this:  
> 011456-05-15.
>
> I've made a form that has unbound controls for crafting the number.
> A textbox txtMaxSeqNo displays the value DMax("File_SeqNo","tblFiles") 
> as a starting point.
> A button btnMakeNext runs the Event Procedure:
> Private Sub btnMakeNext_Click()
>     TF_number.Value = Format(Int(txtMaxFileSeqNo) + 1, "000000")
>     TF_month.Value = Left(CStr(Date), 2)
>     TF_year.Value = Right(CStr(Date), 2)
>     TF_Date.Value = Date
> End Sub
>
> I want to add these values as a new record to the existing tblFiles.  
> Can I make a temp table from these values, append them to the real 
> table, and delete the temp table?  Can I craft a query from these 
> unbound control values and use it to make a temp table, or to append 
> directly to the real table?  I'm not seeing how to capture the values 
> from this form and put them eventually into the the real table.
>
> Ultimately, of course, all this will be behind the scenes, attached to 
> a click event, but, while I'm building it, I want to see each step 
> succeed before moving on.
>
> I'll appreciate ideas.
>
> TNF
>