Search results

  1. J

    queries and dates

    I have a table identifying termination dates of a contract. I need to identify which fiscal year the date falls in - (users can't seem to figure this out on their on)....So I have another table listing fiscal years and the corresponding periods..... how do I query so that field is added to show...
  2. J

    email

    Okay experts - I need to send emails to people that have an email stored in the database, some do, some don't. query says to return not null, then i want to write code to send one email to all of these people......how? I don't want to send anything from the database, just need their addresses...
  3. J

    Reference Frame Selection in report

    I have a report based on a query that is sorted by a user selection in a frame on a form.......make sense? here is the problem. On the report, I want a text box to show what the user selected as the sort order and display it. I used a text box to look at the frame on form as follows...
  4. J

    combo box to update two fields after update

    My problem, any suggestions appreciated: I have a table, tblFiscalYears, 3 fields: FiscalYear, FYBeginDate, FYEndDate. I have a search form that lets users establish criteria for a query against another table. On the search form, I have a combo box,cmboFY, that is populated by tblFiscalYears...
  5. J

    Sorting a Query through VB

    I am sure this is an easy one for the pros. I am new at this and love these forums, I have learned so much. Here is my newest stumbling block: I am using a form to allow users to identify criteria for a query. When the records are returned,(using a form)I want to give them four sort options...
  6. J

    Toolbar/Menus

    How do I hide all standard toolbars and menu bars in my application using vb? Any suggestions appreciated.
Back
Top Bottom