Recent content by BA777

  1. B

    Searching a field for a value using IIF

    Thanks guys, say i changed the * in the field to a ^ then which function should i best go for to get the best results?
  2. B

    Searching a field for a value using IIF

    Guys, In my database report I want to search the Product Title field for a * at the end of it. Then if the mentioned product has the *, I want to display the description of that product. At the moment I have the following IIF statement, but it shows every single description, how can i narrow it...
  3. B

    Duplicates in exported report...

    Guys, Have a report set up in a database of mine that obv. runs off a query, and I've set up a button to automatically run the query and export the report to an external file. So I tried saving them as both .htm and .rtf but 2 of the entries on the report appear twice, unannounced. Any ideas...
  4. B

    Form problem!

    Hi, Thanks for that link it's helped a lot! I've setup a query that shows all 63 products that can be chosen to go into the quote. Now I want to make a form where I can select just on a one-by-one basis as in the sample you provided that then fills in the rest of the details about it and...
  5. B

    Form problem!

    Hi everyone, I'm working on a database at the moment for my dad, and what I'm in the process of doing is making a form in the Forms section of Access 2003 that I can then introduce as a subform in a larger report etc used to make a quotation for a number of products as the end result. What I'm...
Back
Top Bottom