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

    Select several items in combo box

    Acces 97, no VB.  In the db I have an employee table and a table with 31 codes. In the data entry form I have a combo box that drops down & lists the 31 codes. The user may need to select up to 20 of these codes for each employee in the employee db.  How do I do this? Or am I...
  2. Daybreak

    Print every other record gray

    Sorry, Access 97, no VB.  It is a report. The font is sized 8, and about 25 to 30 lines per page, landscape mode.
  3. Daybreak

    Print every other record gray

    I know I have seen the answer on one of the forums.  How do I print every other record in gray?  You help is greatfully appreciated.
  4. Daybreak

    Need idea on how to query?

    our mssgs crossed paths...I was receiving your &quot;find duplicates qry&quot; comment as I sent mine.<br> <br> so.....find duplicates qry.....might work.....have never set one up......so would I run this 'find duplicates qry' off my existing qry? And what might some of the criteria look...
  5. Daybreak

    Need idea on how to query?

    Yes, a new line for every change in court level per &quot;case nbr&quot;<br> ex:<br> at court level &quot;supreme&quot; days calculated= closed date minus reviewed date <br> Like<br> 1 pass thru records case #123 court=district closed dt 2/1/00 reviewed dt 1/1/00<br> 2 pass thru records case...
  6. Daybreak

    Need idea on how to query?

    Thank a million for the response.<br> <br> Yes, everytime the court level changes a new line is written for the case number.<br> <br> A field in the query tracks the days at a court level:<br> ex: Days: [closed_date]-[reviewed_date]<br> <br> Anxiously waiting to hear back.
  7. Daybreak

    Need idea on how to query?

    Access 97, No VB. Have run out of brain power. How might you suggest I set the criteria in a query for this, or should this be done in the report. I am counting duration days on the &quot;entire&quot; length of a case as it passes through the different court levels, (rpt: with one line for...
  8. Daybreak

    Hyperlink in a Form

    Question: could the problem be that I have secured the db? I am the owner and the admin of the db. I have an older backup of the db & using a normal .mdw file, and it the &quot;insert hyperlink&quot; works fine. When I launched the secured db using the secure1.mdw file, then I can not...
  9. Daybreak

    Hyperlink in a Form

    Thanks for your reply. I am the admin on the db and have setup user authorization in the mdw file, but no password on the db itself. I believe the path I used last week was already in the &quot;named location in file&quot; box, but when I type the location (ex: N:\XXX Reports\secure xx1.mdb) I...
  10. Daybreak

    Hyperlink in a Form

    Access 97. I am working with a switchboard form. I have previously built hyperlink buttons. (make a lable, insert hyperlink, browse, highlight rpt name). This week when I make a lable box, then select insert hyperlink, them select the browse button in the &quot;named location in file&quot...
  11. Daybreak

    OOPS, User-Level Security

    Thanks for all of the great feedback. I solved my OOPs problem. I could pull from LAN backup a copy of my db from 5 days prior to turning security on, I did have to make some updates to reports, etc. In all the documentations I read about security, I wish they would have said the FIRST thing...
  12. Daybreak

    OOPS, User-Level Security

    Thank you Elizabeth for responding. I have tried logging on as each user I have set up in all groups, plus us three admins and the Admin default, and still can not run nor design any of the macros. Any other suggestions??? I need all the help I can get at this point. Thanks
  13. Daybreak

    Crosstab Qry Nightmare

    Tried all the above, still receiving the jet engine error. Here is the SQL:, maybe you can find something here.<br> <br> Query passthru 1:<br> <br> SELECT TV_MATTER.CLOSED_DATE, TV_MATTER.REVIEWED_DATE, TV_MATTER.MATTER_TEXT_VAL1 AS [Account #], TV_MATTER.MATTER_TEXT_VAL2 AS [Claim #]...
  14. Daybreak

    OOPS, User-Level Security

    OOPS, Need urgent help on how to do a fix. Access 97, No VB. I have setup the workgroup. I had added the other 2 admins to the group. I was in the user & group permission area, on the change owner tab, groups selected was admin for the new owner, and object type was macro. I highlighted the...
  15. Daybreak

    Crosstab Qry Nightmare

    Thanks DougP for responding. To answer your question about the [start date?]. I use this in my query (ex: date_closed is the date filed i want to search on) when I enter the &quot;criteria field&quot; and/or the &quot;Or field&quot; with the Between [Start Date?] and [End Date?], this prompts...
  16. Daybreak

    Crosstab Qry Nightmare

    Access 97, No VBA. I am having problems with a crosstab query. I have 2 underlaying queries (ex: passthru 1 & passthru 2. The problem: I am receiving the &quot;the microsoft jet engine does not recognize &quot;[start date?]&quot; as a valid field name or expression&quot;. I have the...
  17. Daybreak

    Rotate text in a lable

    Is this possible or not? Access 97 I have a report with 16 lables with text, in the page<br> header from left to right. I do not have enough room for all 16 lables. Is there a way to<br> rotate the lable or something like one can do in excel? (ex: format cells, alignment, text orientation) Any...
  18. Daybreak

    Problem Calculation

    Access 97. Report, after the detail section I have a &quot;counsel footer&quot; with<br> many fields of calculations. Below are a few samples:<br> =Abs(Sum([Court1]=&quot;Bureau&quot;))<br> =Abs(Sum([Court1]=&quot;WCAC-APPELLEE&quot; Or<br> [COURT1]=&quot;WCAC-APPELLANT&quot;))<br> All of...

Part and Inventory Search

Back
Top