Search results

Hi Brian Thanks. Might you know of a good reference link where I can look up these data types and other thing in Access. I am happy to RTFM before posting next time.. :D I know what you are saying having been in support role many years. Sometimes the brain just does not click until you hit...

Brian I agree with you and SOS I thank you. I am a newbie and that is frustrating for me as well. I am working on issues out of email for past 6 months and wanted a way to capture these better. I found an access template that does 95% of what i need - it is really pretty nice. But when I...

Nevermind figured it out again. Murphey's law you never find the answer till you post. I had it as integer and changed it to single.

How do i stop the field from rounding. If I enter 1.75 it reads as 2. I want to see 1.75 physically. Even in the DB it shows 2. Stop auto rounding up or down?

Think I found it. When I changed format from short time to general number that fixed it. Thanks for the help.

Primary Key field name is ID and it is an auto number

Oh yeah - data type I specified is "number"

Hi all, I created a new field and set the field size to integer. zero decimal places, required no indexed no. That is it none of the other properties are filled in. I go to the form and enter a value of 30 and I get this error. What I am trying to do is have a field I can limit to 4 places...

On this one I did not want to have to remember for an eternity Category = Severity. I like to be more thourough in my solution so that someone else could come in and pick up where I left off. But your right I did not have to.

Actually i figured it out. There was a small piece deep find did not touch and should have. But I fixed it and I appear to be running again without errors. Thank you all for the help. :)

Hey guys thanks that seems to work very nicely. Thats a great tool. Almost too great. I can see where this might be dangerous. But exactly what i was looking for. I have one issue. I have a CHART that used to say: Issues by Category and display three categories 1,2,3 with seperate values...

Hi All, I need to change the word "Category" to "Severity" on all table columns, fields, reports forms, etc. Globally make this change but I need to do it safely without breaking any of the refer to or send to links. Is there somewhere in Access I can go to make this change one time and have...