Search results

  1. J

    Running Report for each value

    I need to run a report based on a query for each value in a field of the query. Here's what I have, a query that shows a list of users and projects. I would like to run a report that shows all the user's projects for each user, it needs to be a separate report for each one since I will be...
  2. J

    Overwriting excel files

    I have a database which allows users to import data from an excel file that is located in /forms/user.xls off the root of the database. There is a button to open the spreadsheet to edit it and a button to import the data from the spreadsheet. The problem is that the spreadsheet retains the...
  3. J

    Auto fill based on second form

    sorry, maybe it wasn't clear, what I would like is when the user closes the second form after adding a new name, to have that name appear already filled in in the combo box, not just on the list (I know it is a small thing, but really would make it much nicer)
  4. J

    Auto fill based on second form

    I have a form with a combo box on it that shows our companies employees. It has 2 columns the first one bound [UserID] and the second one an expression showing [LastName]&", "&[FirstName]. The first column has size 0. If a name is not in the database there is a button next to it that opens a...
  5. J

    Putting a date on a report

    use an unbound text box to refer to the date you input by whatever is contained in brackets in the query (I assume this is how it is queried with a variable for instance if the criteria in your query is "[Input Date]" then have a text box with =[Input Date] in it.(whatever is contained in...
  6. J

    Adding columns to a report

    does anyone know a relatively simple way to add add columns to a report depending on values in a field. The example is we want to generate an invoice showing people that billed hours to a certain client, but it HAS to be in the clients format which has the names of billing attys. as column...
  7. J

    SendObject syntax

    How do you specify a template with the SendObject command, I can't get it to work. I have tried the full file path, relative file path, in quoted, not it quotes.... Do the other parameters matter (do they cancel the template??)
Back
Top Bottom