barcode scanner not picking date up

[cfinch100]

hi
i have been racking my brains for 2 days now and have not come up with a solution can any one help please,i scan in barcode in frmissued and save ,writes to sheet3,frmret runs ,scan in barcode and all boxes are filled apart from issue date , and 4 bowes at the bottom which is looking up sheet3,
have 3 long codes in combobox that seem to work,have tried different length barcodes still no good,could it be wrong sort of barcode have used 39,coding not good,tried formatting boxes or something just mind boggling easy,this is the last piece to get working before i can use inventory,please someone out there must be brainy enough to figure this out
cheers colin
forgot to say frmret must be picking up the issue date because it transfers it to sheet3 but does not show on userform weird

[cfinch100]

hi
any one to help please ,would vlookup be any good
cheers colin

[Charles]

Hi,

I do not quit follow what your problem is. Are you wanting the "Barcode" combobox to be populated when you select
the "Id" number?
Perhaps a step by step would help.

[cfinch100]

hi
ok here goes,run frmissued,enter colin as name,i now scan in,but as scanner at work i click on comboboxes id,there are a few in there,enter location and plant number save and exit,these get saved to sheet3 ,run frmret enter name and click on id number boxes,for some reason or other one minute all boxes are populated when you enter id number ,sometimes date issued is not and sometimes none of them
hope this explains a bit more charles
cheers colin

[cfinch100]

hi
any ideas anyone
cheers colin

[Charles]

Hi,

If you select "Collins" in the frmissued and the do the rest of the selections you then save and exit.
Now if you used the same form and selected Collins" again with different input and save it.
Now you use the fmret form for collins how do you know which "Collins" you are selecting when there is more than 2
collins in sheet3. You need to determine which "Collins" you want. And from what I see with your current code it does not do this.

[cfinch100]

hi charles
id and id number are unique numbers never to be used twice it has conditional formatting on that column so any duplicates it joins them together and posts them
good you looking at different bits to me though
cheers colin
not sure why it would put date in some and not others but even if it does not show date it still enters it in sheet3 so must know its there

[Charles]

HI,

Can you provide an example of data that you say puts dates in but not others?
Provide a sample that shows the date and a sample that does not but should.

[Charles]

Hi,

I now see what your referring to. Will see why it happens.

[cfinch100]

hi charles
sorry for not answering earlier have been working on another version will hopefully be done tomorrow ,have taken your advice frmissued looks up sheet1;have now made frmret look up sheet3 so should only look up what is there,bear with me till then ,would be nice to know why the other does not work though,will see if this works ,have done quick test and all is as should be,now will try with scanner in morning
cheers colin

[Charles]

Hi,

Ok, the reason you had the date and then no date is because your code for sheet 3

Please Login or Register  to view this content.

You are using the Combobox listindex as the "Row" number. You can not use the "ListIndex" as the "Row".
So if you have an index of three and row 3 does not have data then the date in the form will not be populated.
If the "Id" number is unique then you must do a "Match" or "Find". The Id can not be in sheet 3 more than 1 time. Otherwise the Match and find will not work correctly.

[cfinch100]

hi charles
thanks for that knew i must have done something wrong,have updated now,so frmret looks up sheet3, after running frmissued and saving now run frmret it now only populates the rows thats in there in sheet3,eg items issued ,if not there textboxes are blank,only prob i can see at min is comboboxes hold their values, i would have thought they would only hold the barcodes that were entered through frmissued but seem to have all barcodes i have ever entered,any ideas,will look at other one you sorted and see which one is best,if you have time can you have a play with it and see if you see any problems,have uploaded new version,i have done it this way to avoid complications, like you said about finding which "colins " data is the one i want,is there a way in frmissued to stop a double entry, ie combobox1=st0199 and combox2=st0199,to stop double scanning
many thanks colin

[Charles]

Hi,

I'll take a look. But, if you do not want "Double" scan you need to set a verification (code?) that tells you you've already scanned the item.

[cfinch100]

hi
not sure how you would do a verificaion code,will have to google later
cheers colin

[cfinch100]

hi
i have just redone the comboboxes on frmissued and frmret frmissued works good but still having problems with frmret,if i enter 3 items st0195/6/7
and then start frmret it looks like it works, but if you enter st0200/201/202 it returns different items,completely lost now pleeze help,have uploaded this new version frmret now looks op sheet3 so it should only return what is issued through frmissued
cheers colin
ps frmret seems to be returning the first entries only as the st numbers are the same but do not match the barcodes for items

[cfinch100]

hi
after quite a bit of testing frmissued seems to work ok,but frmret is not recognising barcode correctly ,if i scan or use drop down combobox as is at the minute it returns items in the order that it was entered on sheet3 and not by barcode number,any ideas anyone please,been at it all day and exhausted most of the threads posted,can not be much hopefully
cheers colin

[cfinch100]

hi
updated a new frmret have used me. in comboboxes and userform initialize seems to work better now any one know why ===confused==
cheers colin

[cfinch100]

hi
have just sovled this by using same userform frmissued and where it saves it to sheet3 i made a copy and just adjusted the postions of date ext on sheet3
i knew frmissued worked so seemed logical to use and modify it,if anyone ants program let me know and ill post it on thread
cheers colin

[Charles]

Hi,

I modified the code so that you can only select 1 "ID" in the form "FRMFET".
I added a "Check_Id" code at the bottom of the code module for this form.
I also modified the "Combobox2" code. For combobox1,2 and 3 I have the code modified for the validation
See combo2 format. The other combo codes probably should be formated this way. It's eaiser to read.
You can adapt the code that I have for combo2 to the rest of the comboboxes.
I added "Public" for some of the validation.

Hope this helps you. And thanks for the "Rep".

Check workbook code. I have the Open form remarked out. You can reset it and also remove the "Test" button and the code associated with it.

[cfinch100]

hi charles
this is spot on thanks very much
cheers colin

[cfinch100]

hi charles
found bit of a problem ,have changed all boxes as suggested ,if i enter some new barcodes into sheet1 ,frmissued uses them but frmret does not recognise them and textboxes comes up blank although bar code is there,bit weird as it is alright on the first 3 barcodes,any ideas ,have messed around a bit on a copy of yours to no avail
cheers colin

[Charles]

Hi,

Post what you did and I'll check it over.

[cfinch100]

hi
have sent posted it has gone in previous post,have just tried it again and now works,had good trial at work and would not so not sure whats happening,definately
was not working earlier,have a look and see what you think enter some new barcode in sheet1 and see if you can issue and return thats how i found out
many thanks colin

[cfinch100]

hi
have just tried again enter 10008 and 10003 in scan out,then scan in and enter same numbers barcode there but does not populate textboxes but first 3 barcodes do
cheers colin

[Charles]

Hi,

Your using the "FRMISSUED" form. And this is causing the problem?
I have an amend code for the "FRMRET" code take alook. I modified all of the combox codes.

[cfinch100]

hi
i use frmissued to scan out which writes to sheet3 and frmret to scan back in to sheet3 also then they combine duplicates to make one row ,have tried frmret again and does still not recognise entries from frmissued,im a bit lost think im missing something somewhere,have tried to use frmret to scan out and then back in but that does not work,sorry to be a pain
cheers colin

[Charles]

In the file I sent the Return form works as far as I can see.
I'll look at Frm out as soon as I can.

[Charles]

Hi,

Looked at your code for FormIssued.
When you send data to a cell you should use.

form

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Note I entered the ".Value".
You need too correct all of you code to this format. It will reduce errors.
Also clean up your code. Get rid of all non necessary code and command buttons.
Once you make the changes for a clean code structure. Test and then let us now if your still having the same issue.

[cfinch100]

hi charles
have changed code for frmissued as suggested but frmret still does not recognise and populate boxes for returning gear
not sure what is happening
cheers colin

[Charles]

Hi,

Does the sheet3 in the attachment you sent have the data you want to see in the form?
If so which Item does not populate the return form?

[cfinch100]

hi
yes when frmissued is populated i would like to see this in frmret ,thought that when frmret is used it would take the info from sheet3 only,so if st0194 and st0195 is selected in frmisued name company and date would be transferred aswell and not st0199 because it was not selected,does that make sense
cheers colin

[Charles]

Hi,

In the FrmIssued, you do not select the ( Barcode) "ST0194" You select the "Id" and this populates the form.
THe selection of the Id populates the FRMISSUED. You the click the "Save" this action send the selection to "Sheet3".
You then select the "Id" in that form you not the "BarCode".
Now to my "Question" in sheet3 in the attachment you posted, "Which Item (ID) do you select that you say should populate the form?".
Does the "ID" in question actually populated in sheet3.(From frmissued)

[cfinch100]

hi charles
many apologies i have that many versions i have messed up,have changed both,frmissued uses barcode to selectand populates all textboxes (a to h),frmret uses barcode to get add info (i to o) minus (m) to sheet3, and joins them together on sheet3, i would think that what was selected in frmissued would only be available in frmret,meaning you can not return what you havent taken out,hope that makes some sort of sense
cheers colin

[Charles]

Hi,

You need to do a "Find" in sheet3 to return the values for the population of the Return form.
So you will need to find "10003" and then populate the return form.
This will work only if the "10003" is not duplicated in sheet 3.

[cfinch100]

hi
ok think i know what you mean will give it a go may take a few hrs so will let you know how i get on tomorrow
cheers for help colin

[Charles]

Hi,

I modified the code for "Add"."FRMRET"
Take a look at it. I put remarks in it for you.
You will need to modify the code for all of the comboboxes except for
combobox1. I modified it and formatted it. You should use the formate that I
have in place. Also before you test disable the code for the command button that you have in place
to move the data to sheet4.
"sheet3.Commandbutton2" disable the code for this.
Also make sure that the data I have going to sheet 3 is correct.
You have so much "Other Stuff" that I may have populate or omitted.
SO VERIFY THE RESULT!

[cfinch100]

hi
charles thanks very much, will do as you suggest and sort the rest out before testing and will get back to you
cheers colin

[Charles]

Hi,

Another suggestion is make the userforms smaller so that the fit the screen.
I modified the "FRMRET" so that you can see "All of the Text and Comboboxes".

[cfinch100]

hi charles

have done as you suggested when i run frmret ,enter a barcode number the st number does not tally with what is entered in frmissued enter 4 or 5 different barcodes and st number is st0194 or st0195 instead of 194,195,197,ect and if you save it says (object
does not support property or method,highlights frmadd_click,i think ive done everything
right,frmret only sends st number,date returned ,location returned,name returned,company returned
cheers colin

[Charles]

HI,

You did not correct all of the code as I suggested.
Some of the code has "iRow" where it should be "c.row".
Please go over the code again.

As for the error. Change the code from "FRMRET.cmdAdd_Click"
to
"cmdAdd_Click"

[cfinch100]

hi charles
have done that now dont know how i missed that ,have tried it and still populating st0194 and st0195 entering different barcodes weird
cheers colin

[Charles]

HI,

I see what you are saying. My suggestion is to do a find instead of the current code you have to populate
the form when you make the combo box selection.

[cfinch100]

hi
ok will give that a go many thanks charles
cheers colin

[Charles]

HI,

I modified the code for the first 2 combo boxes.
You need to follow the format for the other combo boxes.

[cfinch100]

hi
have updated program just couple of things to iron out front end seems to work
click scan out
enter name drop down menu
click next
click couple of comboboxes
save and exit
click scan in
do same as previous
return screen appears
save and exit
have had loads of help with this from various people mainly charles lately he's a legend
cheers colin
d

[cfinch100]

hi
completed program many thanks to all who helped ,guided me, only reports to do now
cheers colin
last and latest update any comments from anyone ,gone wrong anywhere exct
cheers colin