Search results

  1. T

    Sort Combo lookup box

    I have a form with a combo box at the top. This box has two columns. Next to the combo box I have an option group. The option group has two choices. Option 1 (By Name) Option 2 By Number. I would like for one of this to be default sort order. I would like the user to be able to click the...
  2. T

    IF Statement

    I have a point group on my form which stores a value into my table. It is setup to store 1,2,3,4,5, or 6. On My report I would like to show the results. BUT, instead of showing the number, I would like for "1" to show "Active" and "2" as "Not Active" and so on. Can I write an IF Statement? If...
  3. T

    Table setup - Is my thinking correct

    I have created two tables. One is call "employees" the other is called "projects". I setup a form that links the two tables by setting the master and child fileds to the same field. The form is working correctly. AS I scroll through my projects I can see the assigned employees to each project...
  4. T

    Email From Form with Combo box

    I have a report when opened from my menu it calls the form "Selecthandler". The form has a combo box which references back to the table where all the handler info is stored. The Table is called "Registration" I have a command button which contains the code: Dim stDocName As String Dim...
  5. T

    Combo Box Selection Method

    I want to make a report with several subreports. My report file will call back to a form which will have the parameter box. For example: My form will have two combo boxes side by side. The first combo box the user will select from a list of data. The second combo box will be a sort order...
  6. T

    Merging Multiple reports into one

    This is off the wall but maybe someone out there can help me with my problem. I have several custom reports that are sorted in various ways. What I need to do is compile all my reports into one printable document. More specific, I need the report to look like it is one continuous document...
  7. T

    Query based on a form page

    I have a form that displays account information. AccountName, AccountID, etc. I have attached a subform that displays transactions posted to each accountname. I have a combo box that allows me to retrieve each account and the subform changes to the appropriate transactions for that account...
  8. T

    Pulling Data from Multiple Tables

    I have three tables. Each table has a list of names and birthdays. I need to query a list of all birthdays from all three tables. Can this be done? Thanks, Tim
  9. T

    Date Range in a Query

    I am trying to create a Birthday Query. I want to extract the data per month. It is entered into my table in ##/##/#### format. I have tried the between ##/##/#### and ##/##/#### but that only gives me results for a particular year. Ex. I need every birthday in march for every year...
Back
Top Bottom