Adding multiple IDs in a table with time

[SBBmaster09]

I want to make a table where in I have to input atleast 10 numbers in one reference ID which there is a start time and end time. Can someone give me an idea on how to do it?

A form with inputing one reference ID and then adding multiple numbers at once and saving the data with a start time and end time. Is it possible to capture the time for that specific reference ID?

I hope someone could give me an idea on how to do it or a sample tracker on measuring it. Thanks.

 

[Uncle Gizmo]

>>>I want to make a table where in I have to input atleast 10 numbers in one reference ID<<<

What does this table look like?

 

[Uncle Gizmo]

>>>A form with inputing one reference ID<<<

Do you mean an Auto number Field?

 

[Uncle Gizmo]

>>>adding multiple numbers at once<<<

Do you want these linked to the reference ID?

 

[Uncle Gizmo]

>>>saving the data with a start time and end time<<<

It looks like you will need a table to store these times, what does this table look like?

 

[SBBmaster09]

It's like this,

Reference ID Numbers
DocIDA1 001
DocIDA1 002
DocIDA1 003
DocIDB2 A01
DocIDB2 A02

There is 1 field for Reference ID and a table(which i am still thinking on how ill i enter it all at once) for inputting multiple numbers all at once. (But if you have better idea much better)

Then there is a Start time and End time for the tracker, which will reflect that Reference ID start time and end time.

I dont know how it will looks like, I need an idea on how will I do it. Or is it possible to capture all the numbers all at once with the real time start time and end time of processing that specific reference ID.

I have a text field for numbers before but it takes time on inputting numbers especially when it is a bulk orders, that's why i am thinking of putting numbers all at once.

Any suggestions. Thanks.

 

[Uncle Gizmo]

>>>I have a text field for numbers before but it takes time on inputting numbers especially when it is a bulk orders, that's why i am thinking of putting numbers all at once.<<<

Do you mean you want to copy and paste the block of numbers in and have code to sort them out?

 

[Uncle Gizmo]

>>>DocIDA1<<<

Where do you get this number from?

 

[Uncle Gizmo]

>>>Or is it possible to capture all the numbers all at once with the real time start time and end time of processing that specific reference ID. <<<

This does not make sense to me... Please explain..

 

[SBBmaster09]

>>>I have a text field for numbers before but it takes time on inputting numbers especially when it is a bulk orders, that's why i am thinking of putting numbers all at once.<<<

Do you mean you want to copy and paste the block of numbers in and have code to sort them out?

Yes exactly

 

[SBBmaster09]

>>>Or is it possible to capture all the numbers all at once with the real time start time and end time of processing that specific reference ID. <<<

This does not make sense to me... Please explain..

For every processed orders, there should be a start time and time to capture the real-time of processing that order.

If there will be a block of inputs, i dont know how to deal the processing time of each reference ID.

 

[Uncle Gizmo]

>>> i dont know how to deal the processing time of each reference ID<<<

The best way is to sit down with a piece of paper and work out how you would do it without a computer...

 

[Uncle Gizmo]

>>>I have a text field for numbers before but it takes time on inputting numbers especially when it is a bulk orders, that's why i am thinking of putting numbers all at once.<<<

Do you mean you want to copy and paste the block of numbers in and have code to sort them out?

You replied "Exactly"

This would most likely be possible, however, you would be better off importing all the data at once instead of piecemeal.

To check to see if this is possible I ask the following:

Where is this Data?
What does it look like?

 

[SBBmaster09]

You replied "Exactly"

This would most likely be possible, however, you would be better off importing all the data at once instead of piecemeal.

To check to see if this is possible I ask the following:

Where is this Data?
What does it look like?

Here is a sample data that should be entered in a table.

In a form:

There is one field for all of these fields. For Numbers column, putting it in block or all at once. But how can we deal with the time? per processed orders?

It is possible to enter all at once but how can we capture the time for each numbers entered in bulk?

Thanks.

UsernameDateActivityReference IDNumbersStatusStartTimeEndTimeProcessingTimem483253/11/2014Processing Order5435106020128814Complete03:08:13 PM03:17:58 PM0:09:45m483253/11/2014Processing Order5435106022701702Complete03:17:59 PM03:18:59 PM0:01:00m483253/11/2014Processing Order5435106022723849Complete03:41:05 PM03:41:12 PM0:00:07m483253/11/2014Processing Order5435106022728149Complete03:41:13 PM03:41:19 PM0:00:06m483253/11/2014Processing Order5435106025643612Complete03:41:20 PM03:41:26 PM0:00:06m483253/11/2014Processing Order5435106026798692Complete03:41:27 PM03:41:33 PM0:00:06m483253/11/2014Processing Order5435106026798714Complete03:41:34 PM03:41:41 PM0:00:07m483253/11/2014Processing Order5435106027634301Complete03:41:42 PM03:41:49 PM0:00:07m483253/11/2014Processing Order5435106027634315Complete03:41:50 PM03:41:57 PM0:00:07m483253/11/2014Processing Order5435106028159212Complete03:41:58 PM03:42:04 PM0:00:06m483253/11/2014Processing Order5435106028776211Complete03:42:04 PM03:42:11 PM0:00:07m483253/11/2014Processing Order5435106030120675Complete03:42:11 PM03:42:25 PM0:00:14m483253/11/2014Processing Order5435106030120675Complete03:42:25 PM03:42:33 PM0:00:08m483253/11/2014Processing Order5435106030820847Complete03:42:34 PM03:44:56 PM0:02:22m483253/11/2014Processing Order5435106030820854Complete03:44:56 PM03:45:04 PM0:00:08m483253/11/2014Processing Order5435106030950837Complete03:45:04 PM03:45:11 PM0:00:07m483253/11/2014Processing Order5435106030950844Complete03:45:11 PM03:45:19 PM0:00:08

 

[Uncle Gizmo]

Here is a sample data that should be entered in a table.

You should be able to import that excel spreadsheet straight into MS Access as a table.

Have a go at importing it yourself, if you run in to problems then search the forum as I'm sure there must be some previous posts on excel import. If you can't find anything, post back here and I will search for you... Alternatively start a seperate thread on importing a spreadsheet, and I'm sure someone will help you.

With regard to your other questions, we can look at those once the data has been imported.

 

[SBBmaster09]

You should be able to import that excel spreadsheet straight into MS Access as a table.

Have a go at importing it yourself, if you run in to problems then search the forum as I'm sure there must be some previous posts on excel import. If you can't find anything, post back here and I will search for you... Alternatively start a seperate thread on importing a spreadsheet, and I'm sure someone will help you.

With regard to your other questions, we can look at those once the data has been imported.

Its a sample data that should be look like. In a way I am seeking help on how to enter it at one using a form. The form is like the attached file.

how in number text field can enter a multiple id???!!!

 

[Uncle Gizmo]

how can we deal with the time?

how can we capture the time for each numbers entered in bulk?

Regarding the above I suspect there is something significant about your problem I do not understand.

With regard to helping me understand the problem better, please could you annotate the screenshot "Number Porting" with the following; showing where on the form "Number Porting" each item should go:

Username: m48325
Date: 3/11/2014
Activity: Processing Order
Reference ID: 54351060
Numbers: 20128814
Status: Complete
StartTime: 03:08:13 PM
EndTime: 03:17:58 PM
ProcessingTime: 0:09:45

 

[SBBmaster09]

Regarding the above I suspect there is something significant about your problem I do not understand.

With regard to helping me understand the problem is better please could you annotate the screenshot "Number Porting" with the following; showing where on the form "Number Porting" each item should go:

Username: m48325
Date: 3/11/2014
Activity: Processing Order
Reference ID: 54351060
Numbers: 20128814
Status: Complete
StartTime: 03:08:13 PM
EndTime: 03:17:58 PM
ProcessingTime: 0:09:45

------------> Field Names (TextField Label)

Username: m48325 ------------> Username
Date: 3/11/2014 ------------> Production Date
Activity: Processing Order ------------> Activity
Reference ID: 54351060 ------------> Document ID
Numbers: 20128814 ------------> Subscription
Status: Complete ------------> Order Status
StartTime: 03:08:13 PM ------------> StartTime
EndTime: 03:17:58 PM ------------> Time Out
ProcessingTime: 0:09:45 ------------> Processing Time

 

[Uncle Gizmo]

On the form "Number Porting", Is the area below the "Green Line" a "sub-form"?

 

[SBBmaster09]

On the form "Number Porting", Is the area below the "Green Line" a "sub-form"?

No.. its just a one form..