How could I set up a numbering system where you have a main number and then have a choice of a sub number? Ie:
Main = 1
Sub = 1.01
But still be able to move on to 2. Would I need a routine to ask if the next number is a sub number?
thanks
How could I set up a numbering system where you have a main number and then have a choice of a sub number? Ie:
Main = 1
Sub = 1.01
But still be able to move on to 2. Would I need a routine to ask if the next number is a sub number?
thanks
What are you trying to achieve with this method?
What is the purpose of the numbering system?
What is the function of the numbering system?
Can you explain in a little more detail what you are doing? Are you Invoicing with something like a ReBill Option?
What is Main? Can't really tell from the vague description but I would think you would need a ComboBox with Options.
it is like a repair order systems
Main is the main repair order and each line added to the main number would be a sub of the number.
1
1.01
1.02
2
3
4
5.01
5.02..........
This is generating a custom unique identifier. Common topic. Search forum.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
As June said, with a little effort in a search, you can perhaps find what you want. That said, here is an Example that may get you started.
Good Luck!
If IsNull(IncrementedCounter) Then
[EndResult] = (0.01 * DCount("[IncrementedCounterField]", "SomeTable", "[PrimaryKey] = " & Forms!SomeForm!PrimaryKey))
End If
Thanks gents, much appreciated. Please understand us newbies to the craft don't know what to search for. I know its a PITA for the oldtimers to answer the same questions repeatedly.
Search the forum on keywords: "custom unique identifier".
Can further narrow the search if you reference user "June7". I have responded in a LOT of threads on this topic.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks all, but I found a simpler way (for me)
I made a field - Sub_Number
I placed the following in a column in the query on the report.
Sub_CRs: CR_Number + Sub_Number*.01
It allows the user to input the integer as needed to add to the CR_Number. I didn't make it fully automated since you would always need a popup asking if the current input is a Main or Sub CR. Works like a charm.