Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skoutr1

    Displaying/Surpressing Groups based on Most Recent Record

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

    Displaying/Surpressing Groups based on Most Recent Record

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

    Shortcut not opening CR Report

    Running the CrystalReports.msi file did the trick.
  4. skoutr1

    Shortcut not opening CR Report

    We tried that before the original post. Same issue.
  5. skoutr1

    Shortcut not opening CR Report

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

    Updating Subform to Requery Second Subform

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

    Updating Subform to Requery Second Subform

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

    Hyperlink in Text Field of Protected Form

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

    Hyperlink in Text Field of Protected Form

    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?
  10. skoutr1

    Return All Records If...

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

    Return All Records If...

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

    Upcoming Birthdays

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

    Upcoming Birthdays

    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())...
  14. skoutr1

    Upcoming Birthdays

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

    Repeat same text throughout document

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

    Repeat same text throughout document

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

    Changing view of

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

    Conditional shading

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

    Capturing current record or Requery?

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

    Capturing current record or Requery?

    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

Part and Inventory Search

Back
Top