Just want to pass along this incase any other newbie is reading this.
I started out making my database and I really did not pay enough attention to my Table and Field names. (Or queries or reports either.) I read things that said do this or do that. And at one point I started doing things the right way.
Lots of places tell you that you should name things this way or that way. But they fail to explain what happens if you don't.
I was trying to work with a couple forms and Text Strings and I kept getting weird errors and or results. I finally figured out that because I used a dash (-) and blank spaces in my field and table names, Access was trying to use the dash as a minus sign, and shortening my names to only the part before the first blank space. Well no wonder things were not working.
So I bit the bullet and just spend the better part of the last 2 1/2 work days (about 2 days altogether along with my other duties) renaming all my tables and fields to get rid of spaces and dashes. So of course I had to go through all my Queries, Forms, Reports and a couple macros, updating all the field and table names. Pan in the rear let me tell you.
And of course while I was doing the fix, I had about 6 "Need this done now!" situations pop up with my other duties. I normally get 1 or 2 a month.
LEARN FROM MY MISTAKE!
I started out making my database and I really did not pay enough attention to my Table and Field names. (Or queries or reports either.) I read things that said do this or do that. And at one point I started doing things the right way.
Lots of places tell you that you should name things this way or that way. But they fail to explain what happens if you don't.
I was trying to work with a couple forms and Text Strings and I kept getting weird errors and or results. I finally figured out that because I used a dash (-) and blank spaces in my field and table names, Access was trying to use the dash as a minus sign, and shortening my names to only the part before the first blank space. Well no wonder things were not working.
So I bit the bullet and just spend the better part of the last 2 1/2 work days (about 2 days altogether along with my other duties) renaming all my tables and fields to get rid of spaces and dashes. So of course I had to go through all my Queries, Forms, Reports and a couple macros, updating all the field and table names. Pan in the rear let me tell you.
And of course while I was doing the fix, I had about 6 "Need this done now!" situations pop up with my other duties. I normally get 1 or 2 a month.
LEARN FROM MY MISTAKE!