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!

  • Congratulations strongm 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. jerryreed

    Change length of Functional Band

    I believe I've figured it out. Highlight the outline of the band, richt-click properties, then select protection. Uncheck the Height selection box. Click ok. Select Window>Show ShapeSheet. The first grid should be Shape Transform and the Height value will have a GUARD() function...
  2. jerryreed

    Change length of Functional Band

    I'm creating a Cross-Functional Flowchart with veritical Functional Bands within Visio Standard 2002 SP-2. I'm able to change the width of the bands, however I'm unable to change the height. Thanks in advance for any assistance. -JerryReed
  3. jerryreed

    Multiple spool definitions within stored procedure

    thanks SantaMufasa & jaggiebunnet -- I'll keep after it with your suggestions. Tek-Tips always has great feedback. -Jerry
  4. jerryreed

    Multiple spool definitions within stored procedure

    thanks so much for the prompt reply. Doesn't a system admin or DBA need to create/and or set something within an Oracle folder to use this Utility (UTL_FILE) correctly? I started with this in mind, however, I continually received the below error message (the c: is a valid path). I've pasted a...
  5. jerryreed

    Multiple spool definitions within stored procedure

    I'm curious if it is possible to have multiple Spool outputs within an Oracle Stored Procedure. Basically, if a record hits a certain condition,in this case if it is located within the second loop, write it to one file. Else write it to another. CODE example (receiving errors when assigning...
  6. jerryreed

    Form not working after upsizing

    Hi, I ran across this thread while looking for a way to set a condition in a query against field with a boolean value. What I ended up deciding on was to check for 1 (if you're looking for a 'TRUE' record) and 0 (when checking for a 'FALSE' record.) This is a work-around for SQL which doesn't...
  7. jerryreed

    Component Hit Counter

    OK, OK I know this post is a tad bit old...but THANK YOU sierraonsite! You rock!
  8. jerryreed

    'database is read only' on users machine

    Thanks guys -- I'll start testing the security settings for all users to 'Full Control' and go from there. Again, appreciate the responses.
  9. jerryreed

    'database is read only' on users machine

    Thanks for the prompt response. I've checked the Hidden Objects option within the Show frame from the Tools/Options menu within the mdb design view. Unfortunately, the user still receives the 'database is read-only' message. I appreciate the thought though.
  10. jerryreed

    'database is read only' on users machine

    I've completed some general programming updates on an existing Access 2000 .mdb in a Windows XP environment. The mdb now uses no internal tables -- it links to SQL Server 2000 data. The mdb runs fine from all machines -- users can still work and modify data without problems , however, when...
  11. jerryreed

    Text Box Length on Form

    Problem Solved.
  12. jerryreed

    Text Box Length on Form

    Hi, I have an ACCESS application which pulls data from an SQL Server table and displays it on a form for the user to update. One of the form fields is a text box which is populated by a varchar(16) column from the SQL table. I want to allow the user to add more than 16 characters into the...
  13. jerryreed

    Blank subreports for certain users

    Solved. Thanks to anyone who took a second to look at this problem.
  14. jerryreed

    Blank subreports for certain users

    Hi Everyone - I'm working on a previously created ACCESS 2000 application and am in a jam. From the main user interface, a user can fire an event (preview report for example) opening another form which contains several sub reports. Depending upon which parameters are passed (color, weight...
  15. jerryreed

    Hidden Sub Forms on User Machines

    thanks. i'll do that.
  16. jerryreed

    Hidden Sub Forms on User Machines

    Hi Everyone - I'm working on a previously created ACCESS 2000 application and am in a jam. From the main user interface, a user can fire an event (preview report for example) opening another form which contains several sub forms. Depending upon which parameters are passed (color, weight...

Part and Inventory Search

Back
Top