userform not picking up first row sheet

[cfinch100]

hi
my userform frmret looks at sheet3, but will work if you click red combo boxes and bring up barcode no it shows correct records ,but if you scan them it shows first record twice,anyone any ideas please, have just played about with it there are 3 records entered in sheet3,run frmret and enter the 3 barcodes in top 3 comboboxes then swap them around they show different st numbers but same barcodes
cheers colin

[tehneXus]

fixed: logg7(bvj)v3.xlsm

[cfinch100]

hi tehnexus
thanks for trying not sure what you have done ,but afraid still not working frm ret is still returning items that is in the same order that it has been saved in sheet3,
in combobox1 it always wants to enter first row of sheet3
cheers colin
enter5004 in first combobox comes up with nothing.5003 in first is ok ,5002 in second is ok but 5004 in third comes up with 5003 st number
hope you can follow that
cheers colin

[cfinch100]

hi tehnexus
have also lost combobox4 now ,name and company
any ideas think i out of my depth a bit
cheers colin

[tehneXus]

Hi,

I misunderstood you problem in the first place but I think it works now.

Please note that while reading the code to find out what is happening in this form I renamed most of the controls for a better identification during programming.
Another reason for renaming the controls is the usage of a combobox class which controls the red comboboxes with less code and much faster. I also improved the selection of the Name but not sure if this was done correctly, please check. You'll see that some code of yours was dropped as it was replaced by another code or was connected to buttons which do not exist.

In case anything is no longer working properly which was before please let me know and we will solve that.

File: logg7(bvj)v3.1.xlsm

[cfinch100]

hi tehnexus
that is awesome work and i thought it was a quick fix,makes my code look like comes from the ice age,many many thanks for how much you done till now will try scanner in while but on save and exit i get(application or object defined error 1004)with

Please Login or Register  to view this content.

have tried different things but no good
also date returned does not populate in textboxes but could prob sort that one
cheers colin

[tehneXus]

on save and exit i get(application or object defined error 1004)with

Please Login or Register  to view this content.

That's weird, I have no error there..

also date returned does not populate in textboxes but could prob sort that one

When I run it the Date Issued box is filled, the other one not as there is no data n the table.

I made some adjustments: logg7(bvj)v3.1.xlsm

[cfinch100]

Please Login or Register  to view this content.

hi
stops at this line now ,when i start up and scan in,has error 401,cant show non modal when modal form displayed,i removed frmissued.show from commandbutton but now stops at line at beginning
cheers colin

[tehneXus]

Hi,

Weird, the comboxbox event was triggered when changed its rowrource, fixed. Also I've implemented a suggestion to the main userform, instead of showing it in the entire screen you can hide the excel workbook, if you don't like it its easy to remove.

At some point you write the information from FRMRET to sheet3 but I don't know were to get the information for a complete record..

logg7(bvj)v3.1.xlsm

[cfinch100]

hi tehnexus
have uploaded new program have dicarded frmret ,replaced by frmissued1 which acts as a return form,because frmissued seemed to work i thought why not try to clone and use for returns,this frm gets issued date from sheet3 and puts todays date in return date,frmissued enters a -h and frmissued1 I-L and leaves m blank,next looks at all coloumns to see if populated if yes entered posted in m and copies all completed to sheet4 and deletes completed ones in sheet3,all works ok but not sure if it will stand the test of time needs to cope with 1000+ items in and out in a month,still bit basic in coding nowhere near yours,have tried yours again and still crashes on first screen this time scan out
its dead weird as you say
cheers colin

[cfinch100]

hi
method apply of object sort failed on first screen then turned off and was on desktop now works looks good will just have to sort saving frmret to sheet3 as above
many thanks for all your work up to now
cheers colin

[tehneXus]

method apply of object sort failed on first screen then turned off

this happens when Sheet3 does not contain any records except the headings while filling the combo boxes on the form with its data.

So basically you want to get rid of FRMRET? means all the work I did was for nothing..
If you want something similar on another form start with setting meaningful names to your controls like I did on frmret, remove all code which is not used, e.g. in the modules..., then we'll talk about the rest.

Regards

[cfinch100]

hi
no all your work was not for nothing at all it was just an option that i thought of, did not know if it would work,will do as you say and strip it down and put better names on and will get back to you if thats ok
many thanks colin