TextBox Question

[Gregm66]

Hi All,

My question is


if I have 2 textboxes called txtName and the second called txtImage, is it possible to get txtImage to duplicate what is typed into txtName and add the file name extension .jpg? Automatically without the user having to type it in.

[ItsMe]

I would probably have the user type only the file extension into txtImage. Then, in a query I would concatenate the two columns. With that alias in the query, you could create a new column or update the existing.

If you are working in a form, you could have VBA update a field in a table. Also, you will probably want to run some validation code to make sure the extension is spelled correctly.

[Gregm66]

thanks for your input ItsMe,
I might just stick with the user to add the file name plus extension, I'm having enough trouble getting my addnewform to work.
excel I can do this all day long but access I'm still learning.

[ItsMe]

Well, Access is not for everybody. But, I cannot running a business that does not depend on relational databases. I say, don't give up yet. You have to be able to let go of Excel and understand it takes time to learn relational database theory.

[Gregm66]

lol thanks ItsMe, I have no intention of letting this go its a whole new learning process that I have to go through I am slowing starting to understand how it works, it will just take time. I have a million questions bur I guess they are for another thread.

I have built this same project in excel as well as open office calc, but I do need to understand access to make this project more easily re distributed.