Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Namsha
  • Content: Threads
  • Order by date
  1. Namsha

    ON NO DATA IN FIELD TRIM AND ELIMINATE

    I am trying to create an envelope that when there is no street or no PO Box it trims it out completely and doesn't leave a blank line where a street or PO Box would be. Thanks for your help. I know to use If ISNULL but from there kinda lost. I can expect anything and everything of myself; But...
  2. Namsha

    NOT PRINT RECORD RE VBA CRITERIA

    I am trying to print some records (envelopes) but don't want them to print if the po box and street are null. I have the following code: If IsNull(me.PO_BOX AND Me.STREET) THEN This is where I am not sure what to put in because if they both are null I don't want to print that particular...
  3. Namsha

    Need function to Append/InputBox/then Delete on Response

    I need a function to append the data to another table then pop up with a message box that requires a yes or no answer and if yes deletes data from original table.... I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  4. Namsha

    Use & as Literal Character in a Label

    I am trying to create a label with the & such as: Markets & Food How do I create that as a literal character without the program thinking it is a concatenated field? Nina ;cl I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  5. Namsha

    Using & as a literal character

    I am trying to create a label with the & such as: Markets & Food How do I create that as a literal character without the program thinking it is a concatenated field? Nina ;cl I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  6. Namsha

    MERGE MORE THAN ONE RECORD

    How can I merge one company name and many records attached into Word? Is there a way to do it with the merge functions? I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  7. Namsha

    Table of City/State/Zip or Software

    Looking for tables of information on City/State/Zip or Software that has all the Cities in any country along with Zip codes in order to make my database more efficient. Thanks for any and all your help in advance I can expect anything and everything of myself; But can only accept or reject what...
  8. Namsha

    Date Update

    I need to set a control in the form to change the date when I add any new registrations or checks in my table. I know I need to do a date/time control and a Me.Date = Now but in where? I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  9. Namsha

    Return Data

    I am trying to create a report that automatically returns the string "Renewal for the Year" plus the next year. How exactly do I do this? Do I use a multi-data control? I can expect anything and everything of myself; But can only accept or reject what you have to offer!
  10. Namsha

    Update many date fields using Criteria

    Trying to update a date field using Registration Beg number and REgistration End number. Using three forms two subfrms and one main. Two subfrms have the information to update and need to update the current record only.

Part and Inventory Search

Back
Top