Search results

  1. K

    Changing Text to Hyperlink in Query

    I have been looking for this for a few hours and maybe I'm just not searching the right way. I was trying to see if there is a way to convert text to a hyperlink in a query. Background : I'm pulling information from a lotus notes database using an OBDC connection and storing it into an access...
  2. K

    Report showing all categories

    I have a bunch of records that are assigned to categories which are problem tickets. I would like to print the report showing not just the categories that have records open in them now, but also ones that don't have any records in them. So say I have these three categories. Power, Circuit...
  3. K

    Copying a table and appending new

    I'm not sure if I'm going about this correctly. I have a linked table to Lotus notes that I cannot change at all, but for whatever reasons not all the columns are named right. So I copy that table over and have the columns renamed. ( I probably could rename them in a query, but sometimes when...
  4. K

    Linked Table Date is Text

    I'm trying to create a query that will convert the text fields that have dates in them to dates. I cannot change the table this is linked to, our group does not own it. I tried doing a cdate() on it, and it displays the test as a date. But then when I try to run a query based off of this one...
  5. K

    Pivot Chart Decimal Displayed

    I have a pivot chart that has site locations, and hours on the bottom, and then count of records with each site. Which is how many people used this site during this time for each bar. My problem is when I generate my pivot chart, every single time I have to fix the scale on the right hand side...
  6. K

    Parameter Value Error when doing Cascading combo boxes

    Sorry, I have been looking for the last few days on how to do this. Either I'm not searching right, or I'm the only person who had trouble following other people doing cascading combo boxes. I tried following microsoft example and several others but my problem comes up when I click on Group in...
Top Bottom