Search results for query: *

I have a report grouped by Reference Number (see example below). I want to display any Reference Number groups when the most recent status is "Closed" and is within a given quarter. All statuses need to be displayed even when a date/time is outside the target quarter. RefNo:[tab]A219488...

I have a shortcut to a CR report on my desktop. When I double-click the shortcut, instead of opening the report Windows tries to "configure Crystal Reports 2008 SP2". I have no issue with opening the report within CR, only when trying to access from the shortcut. Our IT guy recalls correcting...

Looking for VBA to do the following (some names have been changed to protect the innocent): I have a form (frmLog) based on a table (tblLog) with 2 subforms (sfrmOne and sfrmTwo). sfrmOne Record Source is a table (tblOne) and sfrmTwo Record Source is a query (qryTwo). Forms and subforms are...

Is there a way (VBA sollution or otherwise) to allow a user to insert hyperlinks in a text field of a protected MS Word form?

I have a MS Access database with a table that includes the following fields: [numID] and [numYear]. In a query, I want to return ALL records for [numID] if at least one record for [numID] has [numYear] = Year(Now()). -Rod

Hi all- I have an MS Access database with a table that contains employee information, including a field for date of birth (dteDOB). I want to run a query from this table and only display employees that have a birthday occuring within the next 60 days. This does not seem to be working for...

Hi all- When resizing or moving tables (for example, in the relationships window) I only get an outline of the table/box. How do I turn on/off this feature so I can see the table/box while resizing or moving? Thanks. -Rod

Hi all- I am trying to shade the rows of a report based on one of the fields. For example, if a certain field is null then I want to shade that row gray. I'm not sure how to set up the IF statement. I keep getting the error message "object needed". Here's what I have so far...

First, let me say that I am new to the world of coding. I have a subform nested in a parent form. One field in the subform contains a drop-down list for the user to select an entry. The data in this field is limited to the list. Here's what I want to do: If the user tries to input something...