Recent content by ansentry

  1. ansentry

    Duplicating only Certain Fields in a record

    MKDREP, Have a look at this very OLD example of mine, it may be of help. Link Here
  2. ansentry

    Automate Mail Merge from command button

    cikwan82, That post of mine is over 8 years old, I make no promises but will try and see if I can find a sample to send you.
  3. ansentry

    Make Label invisible if no info in text box

    1. Does my sample work? 2. Why are you putting the report name in? 3.Is "Price" the name of the control in the report? Post a copy of your database with just the report and applicable table(s) and I will have a look at it for you.
  4. ansentry

    Make Label invisible if no info in text box

    I think this will work for you; Me.Price.Visible = Not IsNull(Me.Price) Have a look at my attached sample.
  5. ansentry

    Sequential Numbering of Subform Lines

    feinj, Have a look at my attached sample. I have two types of numbering in it, you can choose which one you want to use.
  6. ansentry

    Add record in sub form.

    Raghu, Glad to help, something I forgot to mention, when you open my subform you will note that some of the controls have a yellow background - these are the ones I have set to visible = no. Also have a look at the small amount of code behind the subform - all for re-query Good luck with your...
  7. ansentry

    Add record in sub form.

    Raghu, Have look at your db now. I have created 2 new forms frmCustomer & sfrmAccounts. Open FrmCustomer and you will see what I have done.
  8. ansentry

    Adding Up Totals from Subforms

    Open the subform (sfrmDefects) in design view and you will see it (TxtTotalEqupment) to the right of "Notes". Have a look at both of your tables you will see that I have made changes to them, I have used "AutoNumber" instead of text as the primary key. Have a look at the relationships and you...
  9. ansentry

    Adding Up Totals from Subforms

    Have a look at your db now.
  10. ansentry

    Word resorting merge data

    I am using Access & Word 2003. When I merge to word labels using an access query word sorts the data in ascending order even though I have sorted it descending in access. How do I stop word from re-sorting. Thanks in advance.
  11. ansentry

    Save concatonated record on form?

    Did you change Name to FName? Better to do it now than have trouble at the end of your project. Have a read here
  12. ansentry

    Save concatonated record on form?

    First base your form on a query (use query as record source) In a new column in the query enter this: FullName:FName &" "& LastName This will return John Smith I have changed "Name" to FName (for first Name) , you should not use the word Name as it is a reserved word in MS Access. Hope this...
  13. ansentry

    Sub form won't allow me to enter data

    Post a copy of your db so that we can have a look at the problem.
  14. ansentry

    labels or textboxes?

    Dave, To my knowledge you can't set a default value for an unbound text box in its control source it has to be done with code. .................I could be wrong. Do you want to use code only or input from your user to fill in the value?
  15. ansentry

    labels or textboxes?

    Dave, Glad you got it working.
Top Bottom