Search results

Please see attached my database

Hi guys. sorry for the late reply. Tarcona - Im searching through a subform. Mikeg51 - thank you for the search database, it looks excellent. What im hoping to do is, create a form from (table 1) which is where all the old and new repairs are stored, and then create drop down boxes, so the...

Hi all, It's been afew months since i've last been on here. I would be very greatful if anyone could help me. Ok, I have an access database called "Service & Repairs" which is currently being used by our engineer team to enter Old and New Repairs, it has been working great for over 6 months...

Hi all, hope someone can help me.. I have a form on my database called "Stock Maintenance". The form has been designed so users select from two combo boxes one named "Part No" the other named "Descripton", once they have made there selection, there information appears in boxes ready for the...

I have learnt so much from you, im truly greatful. I seem to be occuring some sort of problem though, i typed in; "There are just " & Me.QTY & " of part " & Me.cboHorizonPartNo & "(" & Me.cboDescription & ") left. You may want to reorder.", but this error message keeps on appearning...

hi again. the code works an absolute treat and looks fantastic. just a quickie really, where you've made it add the QTY & part no. how would i add in the description? thank you once again :)

Hi Fearoffours, Thank you very much, the database works a treat and is exactly what I was after. One slight problem, which i hope you'll be able to help with me. When the message box appears saying "Stock Low, Send Email?" When i Click On Yes, another box appears asking me what format I want...

i have changed the file to access 2000. thanks again

fearoffours i have upload the database. thank you for all your help

Thank you for your help FearOffOurs, I really do appricate it. I've mananged to figure out the DoCmd.SendObject and it opens up Microsoft Outlook, which is exactly what i wanted. The main purpose of my database is to edit the Stock Qty, the user selects from two combo boxes, 1 called Part No...

Fearoffours, Thank you for your reply. is there a way that I could create a message box, that says Stock Low..Send Email..Yes?No? Once Yes is selected, Microsoft Outlook opens then I can send an email to the admin team asking them to purchase new Stock. thank you once again!

Hi Georgedwilkinson, i've managed to get it working and it looks great. any ideas how i could add a message box to the code, saying "Stock Low".

Hi There, i added the code to the OnCurrent and i keep getting this error: Compile Error: Method or Data Member Not Found any ideas on how i can solve it? Many thanks

Hi all, wondering if anyone can help me. I have an access database, with a form called "Stock Maintenance", the controls on the form are QTY & Min QTY. What i would like if possible, is once the Min QTY is below (10) an alert message/flag appears, saying QTY LOW Re-order Stock!! I hope I have...

Hi Namliam. i searched through all the samples, they all seem brillant and definitly what im after. i downloaded one of the templates, but im literally at the end of my teather, i dont understand what goes where and so on. maybe you could give me some ideas on how you would go about doing...

Could you give me an example of how you would go about doing this please? im sorry im a beginner and havnt had much experience. thank you

Hi again. right ok, so far i have created 2 tables; Table 1 - Faults Table 2 - Fault Codes Table 1 (Faults) contains all the Faults Possible. Table 2(Fault Codes) contains all the codes that match the faults eg: FC0** - User Damage FC1** - No Fault Found FC2** - Display Problems I...

Hi there, thank you for your quick reply. i've found a template on the net, which is exactly what im trying to do. i just dont understand how to put it all together. maybe you could shed some light. if possible, thanks

Hi All. I'm Sure this is simple enough, but i just cant seem to figure it out. I want to use a Combo dropdown box with Codes FC000 - FC900. to return records in a second drop down box that begins with the Letters selected in the first dropdown box. So When a Record is Selected in ComboBox1...

Hi thank you for replying. please could you guide me through how to do that. thanks and sorry to be a pain