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 Wanet Telecoms Ltd 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: gypsylady
  • Content: Threads
  • Order by date
  1. gypsylady

    Lonnie Johnson Forms

    Lonnie, why did you ask me to send you my database if you weren't going to respond?
  2. gypsylady

    Help with IIF statement on Report

    I am baffled. I'm on a report that comes from a query. I want to only show the [Business] name on my form if there is no agent listed in [LName]. I entered: =Iif(IsNull([LName]),[Business]," ") This works in those instances where [LName] is not Null, but if it IsNull then I get ...
  3. gypsylady

    How can I make e-mail address link to new e-mail form

    I have a text box on my form that includes the e-mail address for a contact. Can I make a link so that a new e-mail form opens up?
  4. gypsylady

    sql statemt to return all records even if 1 table blank

    Trying to write a sql statement to return all records from 3 tables, but it is eliminating the records if data is missing from a related table. My statement select * from table 1 table 2 table 3 where table1.idnum=table2.idnum and table2.idnum=table3.idnum. How can I get the data to report for...
  5. gypsylady

    Delete and create new form every time I change the tables?

    I am very frustrated that every time I make a change to a table I have to delete the forms completely and start over. For instance, I used the lookup wizard in one table that looks at values from another table. When I needed to add another record into the table, the new record does not show up...

Part and Inventory Search

Back
Top