Search results

  1. B

    Open Report w/ Subreport based on Unbound Form

    Any help would be greatly appreciated. I am trying to open a report (rptGMX-IRG) that includes a sub-report (srptRG) based on criteria that is set with two unbound fields on a form (frmGMXbook). This form has two dropdown boxes (cboGMX_No & cboMachSize) and a command button. The first...
  2. B

    Data Validation with Comboboxes

    Hello. I am hoping someone can help me with this. My Situation: I have 2 combo boxes on a form. The 2nd box is not visible unless the 1st box is set to a specific value (Illness). Once the specific value is set, the 2nd box appears with appropriate data for selection. :banghead: Goal #1: I...
  3. B

    Update Single Field from Multiple Fields

    :banghead: I wrote a database several years ago and recently pulled it out to give to a friend. The problem is, back then (not knowing better) I set the Employee table up with as a single field "NAME". Now, in order to make it effective, I need the Employee's name in four (4) parts (First...
  4. B

    SIMPLE but Can't find Syntax Error

    Trying to parse first two sections of a five section string. Now getting a SYNTAX COMMA ERROR. Can someone take a look and tell me what's wrong. I've looked at it TOO long. Thanks...
  5. B

    Datasheet Search from another Form

    :banghead: I have a form that shows details of a record. I have a command button to open associated records in another form in DS view. My code will open the DS and show all records or filtered to specific record. What I would like to do is use code on command button to open DS view and simply...
  6. B

    Create a Graph (report) based on a query with form filters.

    I am trying to generate a report that is based off of a query. The query has a form filter that it needs to filter the data. I keep getting a jet engine error and couple others. The form has year, start week, and end week on it. I can get the query to work fine. When I try to open the report...
  7. B

    Filter a Report via Unbound Form

    Can someone give me a suggestion as to where my code is wrong? When I have a value in "WorkCenter" everything works great and graph looks fine. When I leave blank in order to see all records, I get a blank graph. Here's the code: Private Sub Open_Downtime_Graph_Click() Dim strCriteria As...
  8. B

    Displaying query criteria in a report header

    I can't get my reports' unbound field's to display the criteria parameter I enter when report is opened. I have done this before but not in Access 2010. Can someone please give me a hand. In my parameter, I do have a long string inside the brackets (e.g. =[Enter START Date "1/1/14" or Leave...
Back
Top Bottom