Recent content by fblittle

Yes. My internet connection is terrible! I live in the country and have a wireless antenna that should work to 6Mbps Down, but the connection is on and off for some reason, Up is worse, I'm lucky when it gets 1 Mbps, usually .3 Mbps. I have called numerous times for them to fix it, but they say...

I want to enter and edit data into my Access database from my home PC and my work laptop and a tablet that I have. It is a personal database so I am the only user. I travel every week and want access to it on my work PC and also on my home pc when I get home. I tried using OneDrive to have the...

I used your SQL and updated my tables. Work like a Charm. Thanks, saved me hours of manual editing.

Thanks, If I eventually have both Letter codes in my database table how will I be able to attach the letter code to the field without creating another field with just the letter code?

Thanks for the tips. I created this database about 5 years ago so I am stuck with it now unless I do something major to mod it. There is a possibility that in the future the people that issue this call number will up the letter to M or some other letter, But today the letter "N" stands for...

Thanks, Really Appreciate this it will save me a lot of time.

My database has a field called "CallNumber", and the data is formatted like this: N140040 It is limited to 7 characters with the first character as a Letter and the rest all numbers. When I created my database I had the field limited to 6 characters with the same format, example: N78345 . When I...