Search results for query: *

Thanks for the input. I was able to get it to work using a Command. -Rod

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...

Running the CrystalReports.msi file did the trick.

We tried that before the original post. Same issue.

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...

PROBLEM SOLVED! Placed the following for the OnExit Event for sfrmOne Forms!frmLog.Refresh

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...

This form is to notify coworkers and external entities that they are requested to review documents. The documents will be stored on our servers for internal reviewers, and on an ftp server for external reviewers. Persons filling out the form include hyperlinks to the respective directories...

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 had people here at work giving me the same code. After much frustration and trial and error, I got it to work. Thanks! -Rod

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

I think it was an extra ) that was in there. No big deal. Access picked that up right away. I kept trying to tweak the NextBDay and Criteria statements because I kept getting a data mismatch error. In the end, your code was fine, my criteria statement was the problem. Thanks again. -Rod

PH- After tweaking the code you supplied and searching through help files this is what finally worked: ========== NextBDay: DateSerial(Year(Date())+IIf(Format([dteDOB],'mmdd')>=Format(Date(),'mmdd'),0,1),Month([dteDOB]),Day([dteDOB])) Criteria: Between Date() And DateAdd("d",60,Date())...

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...

Thanks Gerry. It worked just as I intended it to. This will be benefitial in creating this template. -Rod

Is it possible to do this same process but have different font formating in different locations? Everytime I try this method in my document, it carries the formatting of the original field...whether I have the "Preserve formatting during updates" box checked or not. -Rod

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...

I'm now getting the following error: ========== Run-time error '2118': You must save the current field before you run the Requery action ========== And again, when you click OK on the error message it completes and gives me the results I wanted anyway. Rod

forgot to include that I was quoting the generic version of your code. I did replace with the proper names. And still got that error