Search results

hi everyone, i am having issues with a form not seeing or linking to my main form. on my main form i have a button that opens a new parts form (which is based on a query from a table). when i open the new parts form the ID of the main form is not displayed - even though i have a relationship...

Hi Guys, thank you so much for the help, managed to get it sorted and rempped the text boxed with the builder seemed to have worked ...yeahy!! thank you very much again for your help. you guys are starts as always. cheers munk

Hi everyone I am having a bit of an issue with calling data(Totals) from a subform in a text box. I have setup a subform 'frmSubRolesSelect' on my main form 'frmmainsheet' and i have a two totals text boxes on the sub form footer to calculate the Total hrs and the Total charge rate...

ahh of course, thanks Ranman star mate :) munkey

Hi Everyone just a quick query is it possible to update a text box from a multi value list box? i have a roles table with role_id, roles, charge rates. at the moment i have it set on a combo box, which once i select a role it shows the charge rate a text box labour_£. i have done this on an...

Hi Plog thank you for your message, i shall give that a read up fella. ok so basically i am trying to stream line the item select process as we have many products that relate to each other and that can be used with in conjunction with. so we have a system type which is just another category...

Hi i don't know if this is possible, i have been looking into organising a parts list, however an orders table needs to access the data. on the orders table i have fields "system","Category","Part type" "item description" . the issues i am having is that each Item has the potential to be in...

Hi Ranman scratch my last message managed to sorted it i didn't realised i had a SQL qury on the table for the ITem Desc .....ohhhhh rookie mistake lol thanks chap for your all help munky

Hi Ranman thanks for the info bud, just applied the changes you have suggested, the part number now displays, however i am getting an issue that it will not let me move to the next row in the subform. I've popped some screen shots on for you mate. thanks again for your help Ranman Munk

Hi Ranman Thanks bud, i have just gave it a go, yeah still no change fella..this is puzzling. i'll put the DB up for you chap, i prob have it all wrong lol cheers munk

Hi all I hope someone can point me in the right direction, I am a little lost on this one. i hope i explain this correctly :) and sorry my VB is not so good I am Trying to Create a Job Sheet and I have a Form "Main Sheet" which has 2 combo boxes System and Part Type, these are populated by a...

Hi Guys thank you so much for your help and pointing me in the right place, however stuck again lol. ok so here is how far i have got. I have managed to setup the Qrys for the cascading combo boxes: and set up a combo box on the "frmMainSheet" "System" which will pickup all the "system" data...

Thanks for your time minty i'll give it a go munk

Hi Guys i have been having a re-think on the db. on the index form their is a System Combo box i have populated this by the systems column from the parts_listexl (I can get this to link to the table but lists every individual entry when i use the combo box . not sure how to get them to only...

Hi Guys thank you for your time, ive managed to strip the db out so thier is only sample info (data is sensitive) and also put an execl spreed sheet in that i am basing the db on and also the db it self. so i have created the form sales tool from the index table their is a parts sample table...

Hi Doc man, thank you for you time for this i will take a look and thank you to NauticalGent for your comment i will try to a db on here so i hope it will make it clearer cheers munk

Hi everyone, its been I while since I've done a db and prob being thick but here goes. I have a parts list with part type part descriptions and costs etc this was imported from an excel Sheet Into a table (I have created its own key). The parts list cannot be split up as it gets updated from...

Hi I hope some one can help I am creating payment database for a community gym, i'm not very good with vb. the data will be created on a data sheet. there are 2 payment types monthly and annual (these are on a dropdown box with their own id number). I have a joining date and a paid date, but...

Hi Hope anyone can help I am trying to setup a graph on a form, but the data seems to be all over the shop. I have a single form called Log with "Customer" and "Line" Fields (These are both combo boxes). On the Log form i have a Datasheet view subform called data. This includes Customer...

Hi mate Just done what you said and brill it worked, your a star mate Thank you very much for your help Kind regards