Creating ID of Date and Name on Form

[raychow22]

Hi Forum,

I would like to create a unique File Name based of the Date() and Name(initials). Below is an illustration of what I want to accomplish. Right now, I have the File Name in a calculated field from the table that does this for me. I hear it may pose problems later so i want to write a VBA code that does this on the form level.



tblQEINames have the names with the associated initials to them.



Thanks!

[ranman256]

on the form , set the textbox FILENAME2 source
=txtName & Format(Date,"yyyymmdd")

if you want the item in the subform, make the query in the subform assemble it:
QEIINITIALS & Format(Date,"yyyymmdd")

[Bulzie]

What if you have 2 with same initials on same day? You probably should ad the time in seconds also after the date. I also would avoid the dashes and make month and day 2 digits so it is all even.
20170706013424RC (013424 is hhmmss)
20170706021441GM

[raychow22]

on the form , set the textbox FILENAME2 source
=txtName & Format(Date,"yyyymmdd")

if you want the item in the subform, make the query in the subform assemble it:
QEIINITIALS & Format(Date,"yyyymmdd")

Is this on expression builder? Should we avoid using expression builder vs. writing a VBA code for it?

[raychow22]

What if you have 2 with same initials on same day? You probably should ad the time in seconds also after the date. I also would avoid the dashes and make month and day 2 digits so it is all even.
20170706013424RC (013424 is hhmmss)
20170706021441GM

No I don't need it to be that specific. If there were two same initials, I would create RC to RC1; however all of our guys here have different combo initials.

[ssanfu]

A couple of things...

- I would suggest you do not begin the file name with a number.

however all of our guys here have different combo initials.

- Right now... Maybe use first, middle & last initials???

You don't really have first and last names in the same field???