Access VBA Problem
- Thread starter Abhijeet
- Start date
- Status
@Abhijeet,
It is not really clear from your post what you are trying to accomplish (i.e., how you are using this), but I believe that you will need to make this a text string rather than a number. Numerically 4.10 is equal to 4.1, so you should create a text string to maintain the example above. However, if you need a number, you should determine the number of digits needed after the decimal (based on the MAX of the numbering scheme) and ensure that you format the number to be 4.01, 4.02, ... 4.10, etc. Depending on how you are determining the count, you should be able to come up with a formula based on the values in the appropriate fields (if using a query) or divide a counter in VBA by the appropriate divisor (e.g., the above would be i + j/100 where i = 4, j = 1, 2, ... 10).
Hope that helps.
Regards,
Ken
It is not really clear from your post what you are trying to accomplish (i.e., how you are using this), but I believe that you will need to make this a text string rather than a number. Numerically 4.10 is equal to 4.1, so you should create a text string to maintain the example above. However, if you need a number, you should determine the number of digits needed after the decimal (based on the MAX of the numbering scheme) and ensure that you format the number to be 4.01, 4.02, ... 4.10, etc. Depending on how you are determining the count, you should be able to come up with a formula based on the values in the appropriate fields (if using a query) or divide a counter in VBA by the appropriate divisor (e.g., the above would be i + j/100 where i = 4, j = 1, 2, ... 10).
Hope that helps.
Regards,
Ken
SirJB7
Excel Rōnin
Hi, Abhijeet!
No need to remember you that these are Excel forums, not Access ones. Surely from time to time there's a user which handles easily Excel VBA and has a little and simple issue regarding other Office products and post a non-Excel related question.
But in this exceptional cases these users:
a) Understand that it's a non-Excel question and start their requirements with that acknowledge
b) If it's has an Excel component usually they're proficient in Excel and what they lack is Access' (or Word or...) skills
c) Describe their issue more thoroughly and in detail that if it would be about Excel
d) Actually post a non-Excel question.
Let me start from d) to a), today I look kinder than usual.
d) Your question is not Access VBA related at all, despite in which application you'll be using it. It's a simple VBA issue. Not Access.
c) You were not very clear with your posted numbers. Don't elaborate, instead upload a sample file with numbers from -2.0 to 5.0 in steps of .1 (or the step you think that will clarify and that contains every possible combination); in 2nd column include the desired result.
b) No comments. Remember how does this paragraph begins.
a) It'd have been very kind and polite if you'd have started alike, but...
Regards!
No need to remember you that these are Excel forums, not Access ones. Surely from time to time there's a user which handles easily Excel VBA and has a little and simple issue regarding other Office products and post a non-Excel related question.
But in this exceptional cases these users:
a) Understand that it's a non-Excel question and start their requirements with that acknowledge
b) If it's has an Excel component usually they're proficient in Excel and what they lack is Access' (or Word or...) skills
c) Describe their issue more thoroughly and in detail that if it would be about Excel
d) Actually post a non-Excel question.
Let me start from d) to a), today I look kinder than usual.
d) Your question is not Access VBA related at all, despite in which application you'll be using it. It's a simple VBA issue. Not Access.
c) You were not very clear with your posted numbers. Don't elaborate, instead upload a sample file with numbers from -2.0 to 5.0 in steps of .1 (or the step you think that will clarify and that contains every possible combination); in 2nd column include the desired result.
b) No comments. Remember how does this paragraph begins.
a) It'd have been very kind and polite if you'd have started alike, but...
Regards!
SirJB7
Excel Rōnin
This topic is the same as last question of this, just five hours of difference:
http://chandoo.org/forum/threads/how-to-increment-number.15701/
What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered or to disperse our efforts thru repeated threads on the same subject. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.
And you've been told and warned about this repeatedly.
If you'd have read the main green sticky post at this forums main page...
http://chandoo.org/forum/threads/new-users-please-read.294/
...you should have noticed this points:
"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."
"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."
"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."
"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker.
If you do cross post, please put that in your post.
Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."
"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question for free. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."
Regards!
PS: If it's a high priority issue and you can't even wait... how much?... oh, 5 hours... absolutely unbearable... but you always have the alternative of hiring a local consultant who may provide you the exact tailored service. Should I remember you that these forums are supported by contributors who dedicate part of their time in an absolutely free way to help other people and answer questions?
http://chandoo.org/forum/threads/how-to-increment-number.15701/
What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered or to disperse our efforts thru repeated threads on the same subject. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.
And you've been told and warned about this repeatedly.
If you'd have read the main green sticky post at this forums main page...
http://chandoo.org/forum/threads/new-users-please-read.294/
...you should have noticed this points:
"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."
"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."
"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."
"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker.
If you do cross post, please put that in your post.
Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."
"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question for free. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."
Regards!
PS: If it's a high priority issue and you can't even wait... how much?... oh, 5 hours... absolutely unbearable... but you always have the alternative of hiring a local consultant who may provide you the exact tailored service. Should I remember you that these forums are supported by contributors who dedicate part of their time in an absolutely free way to help other people and answer questions?
- Status