Recent content by skoutr1

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