Search results

  1. T

    Syntax error

    Hi! I'm trying to run a report that is filtered by a form that contains several text fields and multi-select list boxes. I am working on one section right now and I'm getting a syntax error. If I run the sql by itself, I get correct data. Here's the code: Variant Dim sSql As String Set...
  2. T

    Multiple list boxes as report parameters

    Good morning all! Inherited another old database. There is a form (Projects by Salesperson Parameters) on which exists 6 list boxes (each with multi select set to extended), 2 start and end date groups, and 3 combo boxes. Right now I am just concerning myself with the list boxes (named...
  3. T

    Output multipage reports by customer id

    Hello all! I have to send statements on a monthly basis, currently done by hand, (printed and mailed), some of the customers get one page, others (if they are past due) get 2 or more pages depending on their late status. All of them are currently printed in one batch. I want to be able to...
  4. T

    Trouble with control DSUM

    Hello all! I am creating a payments form in which I need to lookup how much a person has paid this month. I am using 2 date fields on my form to determine the first and last day of the month (firstday, lastday) I have a field on my form called PaymentsMadeToday (means as of today actually) with...
  5. T

    Exporting to XML, need headers and footers

    Good morning all! I apologize in advance for cross posting, but I was't getting any response on the other forum. I am using this to write out an XML file (found it on the web): Dim tostate3 As AdditionalData 'Dim objOrderDetailsInfo As AdditionalData Set tostate3 =...
  6. T

    Complicated request from client

    Hello brilliant minds! I need some ideas for a customer satisfaction survey that includes the employees that worked the job and their pictures. Customers are to rate each employee in several areas. In addition to some basic yes/no questions about the company in general. I am stuck in my own...
  7. T

    Struggling with multi value criteria

    Hello all! I have read too many threads I think and am now totally confused. I have an inventory table - linked to an inventorylocation table. By inventoryID. When it comes time to count, I want users to be able to choose multiple count locations. Which I use a list box filled with locations...
Top Bottom