I need some help getting my head around a possible data entry form i need to produce for my system here at work.
I'm more than a bit rusty on Access but really eager to get this working.
I'm really struggling to see how i would do it despite Googling a'plenty on possible solutions: I feel like I've looked into it far too much and have just walked in circles to a point where i'm just missing something now. Perhaps this is actually extremely easy.
My goal is to speed up my Data entry system significantly. At present i'm able to scan a bar code and enter in the relevant data that is applicable to the unit that the bar code is sourced from. When multiplied this quickly becomes a long task: A Repetitive task where i have to keep repeating the same data.
I want to be able to predetermine the data for the batch of units i'm about to scan into the system and then scan a bar code and save it: Often no other field will need changing when scanning multiple units.
If we say that i'm entering ten units. All of which have six of the same fields, date sent, software version, model version what have you. I want to remove the need to repeat that on each new record.
I've played with the idea of having the form remember the previous record entry or using a form to edit a sub form but i would really love some guidance as to whether this is possible. You can almost think of it as setting the template for the batch and scanning in each bar code which then auto fills the fields based on that template. I would then save the record and ultimately: save a lot of time.
The form would all save to one table. 'Units'. This is a running count of all processed units. The form will also draw on other tables for choosing existing clients and specialized versions of units. All this exists as present. I'm struggling to put together a concept for completely eliminating repeated data. Would remembering a past records input be the better way of handling this? I really need some help in clearing my mind and pinning down a technique.
I would really appreciate any guidance, help or suggestions on this one.
Anything you need to know from me, i'll do my best to provide.
I have an image diagram as a proof of concept example but i am unable to post it.
I'm more than a bit rusty on Access but really eager to get this working.
I'm really struggling to see how i would do it despite Googling a'plenty on possible solutions: I feel like I've looked into it far too much and have just walked in circles to a point where i'm just missing something now. Perhaps this is actually extremely easy.
My goal is to speed up my Data entry system significantly. At present i'm able to scan a bar code and enter in the relevant data that is applicable to the unit that the bar code is sourced from. When multiplied this quickly becomes a long task: A Repetitive task where i have to keep repeating the same data.
I want to be able to predetermine the data for the batch of units i'm about to scan into the system and then scan a bar code and save it: Often no other field will need changing when scanning multiple units.
If we say that i'm entering ten units. All of which have six of the same fields, date sent, software version, model version what have you. I want to remove the need to repeat that on each new record.
I've played with the idea of having the form remember the previous record entry or using a form to edit a sub form but i would really love some guidance as to whether this is possible. You can almost think of it as setting the template for the batch and scanning in each bar code which then auto fills the fields based on that template. I would then save the record and ultimately: save a lot of time.
The form would all save to one table. 'Units'. This is a running count of all processed units. The form will also draw on other tables for choosing existing clients and specialized versions of units. All this exists as present. I'm struggling to put together a concept for completely eliminating repeated data. Would remembering a past records input be the better way of handling this? I really need some help in clearing my mind and pinning down a technique.
I would really appreciate any guidance, help or suggestions on this one.
Anything you need to know from me, i'll do my best to provide.
I have an image diagram as a proof of concept example but i am unable to post it.
Data Entry System - Struggling to produce the concept
0 commentaires:
Enregistrer un commentaire