Search results

  1. J

    Creating Pop up based on Conflicting Dates

    Hello All, So I posted something similar about a month ago but didn't really understand the answer... Let me lay done what my database entails. - I currently have a table that is labeled WorkSchedule. I then Created a query called WorkSchedule Query. - The column labels are as follows...
  2. J

    Hide/Show field using checkbox

    Hello all, I have a sub form with checkboxes. Each check box represents one of the columns/fields in my query. If one of the boxes is checked, I only want the column that matches with the check box to appear. I have done some research and have came upon the ColumnHidden property. How...
  3. J

    Matching an Indivual then determing if conflicting date

    Hello All, I have a database with two tables. One with a schedule that lists all of the events with the person assigned to, with there start date and end date in separate columns. My second table lists a persons leave. So I have there name and the start and end date of their leave in...
  4. J

    Creating a Pop-Up Form

    Hello All, So here's my idea. I have a list of people in a list box. In the list box I only have the people names listed. (example below) 1. John 2. Frank 3. Tim 4. Jessica I want to click on one of the names and have a form pop up on the same screen that lists the persons contact...
  5. J

    Opening Query in Pivot Chart View

    So I have a code that opens a query but I want the PivotChart to show. Below is my code related to opening the query. If vartyp = 0 Then varQueryName = DLookup("Query", FileName, Criteria) If IsNull(varQueryName) = False Then DoCmd.OpenQuery varQueryName, acNormal End If
  6. J

    Using Checkboxes to open certain Forms

    Figured it out... Thanks for the help!
  7. J

    Using Checkboxes to open certain Forms

    Is there a way to do something similar but instead of using forms you are using queries?
  8. J

    Missing Criteria in Table

    I was dumb. It works. I just have to make sure the column is labeled "number" for data type.
  9. J

    Using Checkboxes to open certain Forms

    So this is question probably has a pretty basic answer... I have 6 different check boxes that I want to attached to one button. If a check box is marked I want a specific form that is related to that checkbox to open when clicking the OnClick button. I am not to familiar with VBA but...
  10. J

    Missing Criteria in Table

    Hello, I was wondering if there was a special character you entered into the column area if you have missing data. For example, I am trying to run some statistical analyses using a pivot chart. I want to make sure that every box in a specific column is filled. For some of rows I am...
  11. J

    Filtering Queries using Macros

    Hello, I was wondering if there was a way you could filter data by just using a macro. I know how to filter the data by using a text box with a button and typing in the critera, but I want the criteria to be pre-set and have the select data open using only a button on a form. For example...
Top Bottom