Recent content by jimbo100

Thanks, yeah I did realise I would encounter such issues. The idea of using the Left function was to see how it would work within a form. The Access file I have uploaded shows the form that has an ID, getting characters from other fields such as firs tname and last name. This works on the form...

Thank you, I appreciate both of your replies. I will go with the Autonumber approach, based on your suggestion and what many websites are recommending as well. Is there a link to show how I might be able to approach the Left function within the form? I keep coming across resources but they all...

Hi there, I can use the left function to strip characters from different fields and concatenate them into one field. This is easily done using a query however when I try to do this using an entry form, I seem to be getting error messages such as: "You must enter a value in the...

Hi there, I teach networking and some programming in Python at high school. I have used this website in the past to develop my database knowledge and I have finally registered because I need some help with some things. I guess I will need to pay the favour back some day.