Search results

  1. J

    Display coloured rectangle, where colour changes based on table data

    Hey guys, It's been a while since I was last here, but I need to scratch your brains for some advice. Some background info: I have a table named tblCompanies. In this table, there is a field named BeenContacted. The BeenContacted field is a checkbox on my form so would take a Yes/No value. My...
  2. J

    Subform issue in one form but not the other

    Hey guys, I have two forms each saving data in the same table (tblCompanies). On each form there are 3 subforms. On "FormA" everything works perfectly. On "FormB" one subform (frmProgress) is stuck on the same record. I have frmProgress on FormA too with no problems. By 'stuck', I mean that...
  3. J

    "subReport"

    Hey guys, I'm very new to reports, and hope you may have some advice for me: I have a form with comboboxes each relating to a field (some in different tables). I then have a button which will open a report (which I haven't made yet; or rather which I made, remade and deleted over and over)...
  4. J

    Conflicting Data Types & Linking Tables in a Form

    Hey guys, Some background: I have a table named tblCampaigns (which has a list of campaigns offered, format is text); another table CompanyParticulars has a field named Campaign. In the CompanyParticulars table, the Campaign field is set to lookup values from the tblCampaigns. It allows...
  5. J

    common field used to link multiple forms to a main form

    Hey guys, I have a form (for reference purposes call it "frmMain") on which I have placed various buttons; each linking to another form. My main form has a Payments button linking to a Payments form and a Meetings button linking to a Meetings form. On my main form I have 3 subforms (not sure...
  6. J

    Subform query from main form's data

    Hey guys, I have a field on a form called Type. I then have another field (named Categories) in a subform. What I am hoping to achieve is that depending on the value of Type, the Categories value will change. Categories is a combobox of values. These values are stored in two separate tables...
  7. J

    Specific Navigation (Using a Query)

    Hey guys, Does any one know if it is possible to use the standard/built-in navigation in access (I have access 2007, but the question is valid for other versions), but omit certain records as you navigate? I have a field: "companies" which falls into two types, for reference purposes call them...
  8. J

    Please Help... Forms are now my nightmare!

    Hi guys, I'm new to Access. I have had experience in designing tables and queries but that is as far as it goes for my "expertise". I now find myself trying to make 2 forms - one to enter info and the other to update the current info already stored in the database. I have the tables, and the...
Back
Top Bottom