Recent content by Takunda Mafuta

  1. T

    Duplicate Form with Subform

    @Gasman....Thank you so much, it worked!
  2. T

    Duplicate Form with Subform

    @arnelgp....it's only duplicating Main form and subform of a form with the Mainfield1 textbox value "Bird".
  3. T

    Duplicate Form with Subform

    @Gasman...The actual database I tried to use the code is too big to attach on this platform so I made that sample database so that I can get the idea.
  4. T

    Duplicate Form with Subform

    @theDBguy ..... That's exactly what I thought was going to finally work after trying different other things on the internet but it still didn't. Maybe I failed to translate it into my own database, you can try for me please.
  5. T

    Duplicate Form with Subform

    @theDBguy ..... That's exactly what I thought was going to finally work after trying different other things on the internet but it still didn't. Maybe I failed to translate it into my own database, you can try for me please.
  6. T

    Duplicate Form with Subform

    I'm a newbie to Ms Access and I have tried to follow a lot of content on this subject title but I wasn't successful. Can someone demonstrate for me on the attached sample database.
  7. T

    Concatenate query records

    I want to create a query (Resultant Query) which concatenates records from another query (Source Query). For example: Source Query A 10 B 15 A 6 C 4 C 5 Resultant Query A 16 B 15 C 9
  8. T

    Dlookup into a query field using Date Criteria

    I want to query figures from a table into my query using date criteria but when I run the query I get only blanks. The expression I'm using in the expression builder is as follows. See also attached images. XE: DLookUp("EXCRate","ExchangeRates","EXCDate=#" & [DateEntered] & "#")
  9. T

    Write conflict: I want to always Drop Changes

    The writes conflict dialog box is still popping up and the answer for all the users is just "Drop Changes". Can there be a code which automates "Drop Changes" so that we don't continually do that manually?
  10. T

    Write conflict: I want to always Drop Changes

    I have a split database and I have duplicated front-end file to make multiple copies for different users. Every-time a change is made on one front-end form, I want the other forms in other front-ends to always drop changes. How can I trap this write conflict to always drop changes maybe through...
  11. T

    Conditionally Lock Data on Current Form

    I am a newbie to MS Access VBA. I want to lock fields on a form (PaymentRequest) "Payment Request 1" using a checkbox such that if I go to the next form (PaymentRequest) "Payment Request 2" the fields will be editable until I also lock them with a checkbox on that particular form. I have tried...
  12. T

    Cascading combo-boxes in table form

    Hie I have created a tabular form and I inserted second column with combo boxes which are dependent on combo boxes in the first column. However when I select a combo-box value in the next row of the first column, instead of updating just the combo-box of that very row in the second column, it is...
  13. T

    Hello from Zimbabwe!

    Hi I am new to Microsoft Access. Creating and using automated systems is my hobby. I have been using Excel workbook functions for a long time now and Excel VBA macros for the past few months. Now I want to get into more sophisticated platforms and so here I am
See more
Back
Top Bottom