Question The value entered isn't valid for this field

[mdexter]

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 where you can enter a number value that represents how many minutes you spent on the ticket. I want to be able to calculate the field so I don't want to make it text.

Thanks,
Mike

 

[mdexter]

Oh yeah - data type I specified is "number"

 

[SOS]

What is your primary key? Perhaps that is the actual error and not the number you are putting in.

 

[mdexter]

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

 

[SOS]

can you post the db?

 

[mdexter]

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

 

[SOS]

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

cool, glad you got it. That is definitely not one I would have thought to look for.

 

[mdexter]

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?

 

[mdexter]

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.

 

[SOS]

You need a different datatype than Integer. An Integer has no decimal places.

 

[SOS]

I actually started posting the answer but got a phone call which delayed me. Good you figured it out.

 

[Brianwarnock]

I would like to commend SOS's patience and manners on this thread.

Brian

 

[SOS]

I would like to commend SOS's patience and manners on this thread.

Brian

I try (heaven knows I try) but am not always successful. But I keep trying.

 

[gemma-the-husky]

note that single and integer datatypes are fairly specialised, and support smaller ranges than alternatives

unless there is a special reason to use these, i would always go for LONG and DOUBLE, or CURRENCY datatypes

 

[mdexter]

I try (heaven knows I try) but am not always successful. But I keep trying.

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 want to make changes I get stuck working around access.

I wish I had a ClearQuest license because I could have done all of this in ClearQuest without any issues. Access being so tricky to work with makes the experience not so fun.

Sorry guys. but thank you very much for your patience.

Mike

 

[Brianwarnock]

Hi Mike

Welcome to the forum I'm sure that you will continue to get lots of help here, but can I suggest, without offending or being condescending, that you slow down a bit, some posters get a bit miffed at people who chose integer and complain of no decimal places.

Best of luck for the future with Access.

Brian

 

[mdexter]

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.. I know what you are saying having been in support role many years. Sometimes the brain just does not click until you hit the send button. No offense taken here.
Mike

 

[Brianwarnock]

Sorry don't know a good ref book, since retiring I have to rely on the help which is not very good, even when the info is there it can be a devil to find.

Post a thread asking and you may get a response.

Brian