Search results

  1. R

    Free Form Reports?

    I have a table, which is a linked table to my CRM package (GoldMine). I need to extract info out of GoldMine which I have found Access to be very good at doing. One of the items I am reporting on is email body information. Problem is when I create an Access report with a text box defined to put...
  2. R

    Update Query

    Tying to update a field in a table to contain only the first n characters of another field in the same table. eg. [master].[field1] Text - contains up to 150 characters [master].[field2] Text - can only contain 24 characters Want to update field2 to the first 24 characters from field1...
  3. R

    Forcing field write

    have a datasheet form with about 10 fields. When I enter data into field 2 for example, is there a way for me to "force write" that data into the table after I make a change and tab to the next field? I have calculations in following fields that rely on the data from field 2. Currently, when...
  4. R

    Referencing Page (tabs) names

    On my form (frmClientTracking), I have setup 4 Tabs (pages). Each tab has a different subform. 2 of the Tabs (Pages) are set to visible=No. On the subform on Tab 2 for example, I have a yes/no field. When I check the field, I want to set "Visible=True" on Tabs (Pages 3 & 4). Form =...
  5. R

    Passing Variable To DCount & Dsum on Rpt

    I have created a report that looks kind of like a spreadsheet where there are rows and columns of information. For some fields, I am using DCount and others I am using DSum to pull the correct information ouf of a table. An example of the DCount expression...
  6. R

    Query Results Driving Me 2 Drink!

    Have a display form that presents global, YTD & MTD stats. One of the fields is TotalRefund. For the global total this isn't an issue because there is data (numbers to add up). For MTD, when there is no values (no refunds Month-to-date), I get a #error in the field. When I change the calendar...
  7. R

    Making Fields Visible on Subform

    Folks - Thanks so far for all the assists out there ... Am learning quite a bit and have been using this forum as a reference to get through some issues. Here's one I cannot quite figure out. I have a form [Details] which has a Subform [PaymentInfo]. the fields on the [PaymentInfo] Subform are...
  8. R

    Display subform depending on field value

    OK, my next adventure is this: On my main form, I have a field (FeePercent) which can contain one of three possibilities; 0%, 40% or 50%. I have three subforms defined, one for each of the 3 percentages from this field. When I open the main form, I would like to know if it is possible to have...
  9. R

    MTD & YTD Summary Statistics

    I have a form that is a display form for presenting statistical info. The table/field info are: Table = ClientTracking / field = InvoiceDate Table = CheckDetails / field = EstRefund I am trying to present on the stats form the year-to-date and month-to-date totals of the EstRefund field...
Back
Top Bottom