Search results

  1. C

    Qry locked for editing in subform

    HI I have an input form whereby i enter batch information for products we make. I have a subform that summarises my recent entries which i then want to review and tick a tick box in each entry and then click a button to confirm all have been checked and can be uploaded to the proper stock...
  2. C

    HOw to split back end and front end

    Hi. Thanks to all the support on this forum i am nearer the stage of rolling out my database at work. It is by no means perfect but it will do the job in the short term while i work on improvedments etc. My question is: Is there a good guide or accepted way as to how to split the back end...
  3. C

    Sub Form Flickering

    Apologies. Now tested and working my end for you to see issue. Conditional formatting is quite limited. IN fact dont think i have any in the subform. See uploaded database. Thanks for continued support and patience
  4. C

    Sub Form Flickering

    Actually i have noticed another finished form doing same thing so can post database now. Database attached. 1)Open Frm_Bed 2) in the subform click on down arrow on vertical scroll bar and watch the flicking occue 3) Hopefully tell me what i have done wrong.
  5. C

    Sub Form Flickering

    Hi both. Will try get my database uploaded later on but in meantime just wanted to say thanks for suggestions and give some feedback on what trying to achieve with the form and subform. As we create products at wokr we give all products a batch name and record various things about the batch...
  6. C

    Sub Form Flickering

    Hi. I have a form with a subform embedded. The subform is a continuous form that presents similar to a datasheet (but with added features) The problem is when i use the scroll bar to go up or down the data, the continuous from starts to flicker so much. Looks very unprofessional and also hard...
  7. C

    CBO query issue

    OK somehow now not working. It seems to have amended my code to the attached image and doesn't work
  8. C

    CBO query issue

    Cheers also Arnelgp
  9. C

    CBO query issue

    Awesome. Thank you so much Minty. Much appreciated
  10. C

    CBO query issue

    Hi I have 3 comboboxs. FOr ease lets go with Country > State > City Obviously when i choose an option in Country cbo it then populates the options available in the State cbo and then when i choose option in state in populates option available in City cbo. What i want to achieve is to allow...
  11. C

    cbo AFTER UPDATE EVENT NOT WORKING EVERYTIME

    Here it is
  12. C

    cbo AFTER UPDATE EVENT NOT WORKING EVERYTIME

    Got an upload file size issue. Working on it
  13. C

    cbo AFTER UPDATE EVENT NOT WORKING EVERYTIME

    Hi, Thanks for feedback so far. Decided best to post my work to illustrate my problem. See file attached. Follow these steps to see issue: 1. Open Frm_AddTier3 2. In top combobox enter Fuchsia 3. You will then see second combobox is automatically populated and locked and the form moves to first...
  14. C

    cbo AFTER UPDATE EVENT NOT WORKING EVERYTIME

    HI. Been a while but as snow has ground company to a halt i have some time to crack on with access. I have a form with 2 comboboxes. THe second is populated depending on the choice of the first combobox. What i wanted and what is kind of working is the following. I wanted that if i chose say...
  15. C

    Requery a subform form another form

    Follow up question within form 3 i already have defined form 1 as StrForm why wont the following code work. FOund a workaround but just interested why it wont work Const FN As String = StrForm If CurrentProject.AllForms(FN).IsLoaded Then Forms(FN).RequerySubforms
  16. C

    Requery a subform form another form

    GENIUS thank you so much for solving that one for me and in such a neat way that i can utilise for other things going forward. Had no idea about the close sub so very useful to know.
  17. C

    Requery a subform form another form

    Cheers Mark, WIll give that a try now and report back. Just chekcing it is the actual control holding the subform rather than the subform name itself i reference? I rather sloppily have named the subform control Child585 and actual subform as Frm_AddSubform Your understanding of my query...
  18. C

    Requery a subform form another form

    Hi Ridders TRied your suggestion and i get the following error - Run time error'2465: Application-defined or objectdefined error. In my code should i be referencing the subform or the child control the subform sits in?
  19. C

    Requery a subform form another form

    Hi I have a form with a subform embedded. WIthin the subform there is a cmd button that when clicked opens another form. The other form that is opened allows me to edit the names of data in the subform. When i click amend in the pop out edit form the name in the subform of form 1 changes as...
  20. C

    Set Subform REcordsource on loading of main form

    Hi I have attached a smaple database of what i am trying to acheive. In the smaple database there are 4 tables, Category, Compost, PotSize and Greenhouse. Rather than create 4 different forms and go through hassle of changing all the labels etc and message boxes i have designed a master...
Back
Top Bottom