Search results

Ok thanks Gasman i misunderstood MajP's instructions....i've changed it and added it to the subform and all's well. Thanks for your help. Thanks again MajP for your help and also your patience ! Em x

I'm still getting the error attached when i click into the control on the subform. I put your first snippet of code above into a class module on the subform and the other code into a module on it's own ?. I just called them Class1 and Module1....does this make a difference ?

Gasman.....the control Image14 is on the Parent form so i'm confused as to why the error is happening

MajP sorry i was away for a few days. I just tried to update the code with what you suggested but am getting a compile error. It says invalid use of ME Keyword. I'm convinced i haven't followed your instructions correctly. I have the code in a stand alone module now. The code below is in the...

Hi MajP...sorry to drag this one up again. The form where i have the image holder is the main form and the controls are on a subform. I'm getting the error attached when i click into the control. I'm not sure if it's because the controls are on a subform or i've made a mess of the code ?. This...

Pat/George thank you both for the links. Someday i might surprise everyone and actually answer a question in the forum with my new VBA knowledge ;)

Thanks Gasman....i think i'll give the Programming Made EZ one a try

Thanks for the help Pat...the code worked perfectly. My knowledge of VBA is atrocious as you can see ! Do you know a good resource or YouTube channel where i could learn the basics even ? Thanks everyone for the help and suggestions Em x

Hi All, I have a main form called frm_AddNewShift and a related subform called SubRecords. I want to be able to verify that the four controls on the main form have been populated before i allow access to the subform. I added the following code to the GotFocus event of the first control on the...

Hi All, As i mentioned in #5 this is an old database which is still running here on site. I didn't design it and yes this is not something i would do with one of my creations. The form is simply a data entry form and the subform just displays the last five records entered (i'm told it was...

Ok i deleted the link between the two forms and the records are now showing up as normal. Being an amateur i'm not sure why this worked but i'll take it. I also added a little code to the AfterUpdate event of the main form to make the subform update live. Me!subformcontrolname.Requery Thanks...

Hi isladogs......my main form is set to Yes and subform set to No but still nothing. If i open the subform on it's own the records are displayed as normal. The reason for this is i'm trying to repair a legacy database where you enter new records on the main form and the subform displays the last...

Hi DBguy......there was nothing showing up on the subform ? but when i changed both forms to Data Entry = No then the records were visible on the subform

Hi All, Would it be possible to have a Main Form with the properties set to Data Entry = Yes and a linked Subform to display records with Data Entry set to No ?

Thanks a lot for your help GaP42. I'll work away on getting this running and hopefully come up with something they can use. The supplier of the scanner has also come back to me with a configuration which is not far off what i'm looking for so fingers crossed. Thanks again for all your time with...

Hi GaP42.....Sorry for the delay with this. The supplier of the scanner rang me and tried a few things over the phone but didn't work out and is ringing me back. I've amended the table to also accept the PalletNo and Weight. I also deleted the line of code you suggested and now the info for the...

1. I'll be fixing the table over the next couple of days 2. After scanning the second barcode, i don't want the form to move to the next record. I know it's a bit silly but i've been asked to make the system look as much like the existing one as possible....so i'm going to add a Save button for...

Hi GaP42.....as i originally mentioned in Post 1 there will be two barcodes to be scanned. The first one is the one you've been working on which breaks down into BBDate/Batch and ProductID. The second one contains PalletNo and Weight, so i need the first barcode to be parsed into the...

Hi GaP42......i've actually been swapping messages with the manufacturer of the scanner itself to see if they can help. Thank you again for your time with this. I tried your database and when i scan a barcode it's actually parsing the barcode into exactly what i need and saving it to the table...

Yes i have set up a quick form which is linked to a table as you described. The barcode scans into the txt field but i can't break up the information to populate the other fields (BBDate/BatchNo/productID)