Search results

Hi thanks for getting back to me. I have a blank form called snakes, that contains a Tab Control with 2 tabs "Details" and "Health" The Details tab has a subform called SDetails which is in form layout containing ID Key and attributes. The Health tab has a data sheet subform called SHealth with...

Hi hope any one can help, I am a reptile breeder and I am trying to make a database to log all reptiles and when they fed etc. I am working in access 2007 I have a form with a tab control, 1st tab is details and the second tab is health. The details TAB has Key ID and other attributes that do...

again your a star!!!! Thank you very much for your help, i am so appreciative of your help my friend. matt

Hey mate Just to let you know all that work and.....it works ha ha awesome cheers mate your a star just a quick one when the scanner scans in the data from the barcode it just enters to the next field in the same record how do i get so that when its done what it needs to do so it...

Hey mate ooohhh mate you are a star pal, thank you. i'll have a bash at the code. yeah the barcode data is litterally just click scan bunch of numbers appear in the field and automatically enters across to next field it works on a keyboard widgit apparently which just acts as a person typing...

hi mate Right process i've got so far step 1 Form:- Goods in User inputs date,supplier [dd],weighbridge no. selects Barcode subfield an scans in barcodes step 2 Form:- Refurb user locatcates record by find button and scans in barcode user fills manually fills in item type, manufacturer...

hi mate right ok cool thats no problem, i'm working in 2003 anyway mate. i had a play around with the relationships but thats did work lol which im not supprised ha. no worries i'll upload in a tick. matt

ok cool, the user clicks in the "barcode field" and then the barcode is scanned. The barcode numbers automatically fill the field and a new record is created. the user manually inputs ITEM TYPE | MANUFACTURER The data is just stored in the table

hi mate ok sorry to bother you, ok barcode is scanned, item type, manufacture is inputted manually. on different form barcode is scanned and the item type and manufacturer is autofilled when barcode is scanned hope this helps

Hi mate ok pal no problem thank you for getting back to me. sorry to keep picking your brain pal, when i scan in a barcode how can i get the barcode to pull the info from another table? matt

To cbrighton Hi mate, oh thanks mate for heads up thats great i'm getting a better idea on how to do this. thank you for your help. p.s just a quick one with barcode reader i'm finding when i scan into a cell it enters across to the next cell, is there some code or setting in access that...

to Steve R Thanks mate i'll have a look, thankyou for the link matt

to cbrighton Hi mate thank you for your post. yes the items booked in will be booked out at a later date as a customer will purchase them. i have to log items booked in that come in to goods in against the weighbridge ticket, supplier and date. then when a new customer purchases these...

Hi all hope you can help i have created a few form databases but am a bit stuck on this one i am designing a booking in booking out system quick layout of what i like to acheive booking in a load comes in and an open weighbridge ticket gets created via another programme and given a...

Hi Uncle Gizmo Thank you for the informtion, yeah i've managed to find the scanners that no problem, its more of the programming access to allow me to scan single items and add them to a booking out spreadsheet or equivalent in access to then generate a printable report. this is what i'm...

Hi i am designing a tracking data base i am looking into the booking out side how would i be able to batch barcode scan a load of items on a booking out/purchase screen in then to be saved and can be printed out at goodsout? if anyone as a template would be fantastic cheers hope anyone can help