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 wOOdy-Soft 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: *

  • Users: scra
  • Content: Threads
  • Order by date
  1. scra

    Setting up permissions in Access 2010

    I have a database in Access 2010 and would like to set permissions to allow other users to have the data tables as READ-ONLY and have no permissions to make changes to them but me as the author. I would allow users to link to the tables from my database and have those users open the linked...
  2. scra

    Excel- How to copy values for each row using a macro?

    Hello. I have a flat file in Excel. There are missing values on each row when value changes. I need to copy those values to each row. I'm not sure if I'm making any sense, but here is an example. Current Output Ticket # Patient Date of Service 1712612 111111 9/15/2011 null null...
  3. scra

    Changing Colors on Option Button

    I have a report in Access where an option button is visible for each record. As of now, the option is shown in color black when the answer is true or yes. When No, the option button is not filled-in which is expected. However, I do want to change the color in Green when Yes or True and in...
  4. scra

    Assigning a number

    I have a command button name "New Issue" on a form. When I click on that command button, I get a clean form to enter new data. Within that form, there is a field named Issue Number. I would like to assign that field an automatic fill-in number (i.e. last issue number is 35..would like 36 to...
  5. scra

    How to clear a form?

    I just want to see a blank form after it's been opened. Undirty it, I guess.
  6. scra

    Change color of value if value is negative

    I know there is a way to code a field if a value of that field is a negative. I want to code a negative value in color red font and positive value as green.
  7. scra

    Sorting in form

    I have a subform that needs to be sorted by review date (review_dt) in descending order when the form is opened. What and where do you insert a code?
  8. scra

    Converting reports to PDF

    I have 12 pages of Access reports. Each page is its own report. To convert all reports to PDF, I have to convert each report and then 'bind' them into one using Adobe. Is there a way to convert all 12 pages into one PDF file?
  9. scra

    Printing multiple reports using Adobe Acrobat

    I have multiple page reports. Each page of the report is setup individually. I would like to print all pages into one PDF file. Is there a way to do this without having each Access report page as a PDF file?
  10. scra

    Setting up a read-only tables

    I share a database to other front-end users. I want to be able to setup the data tables so that the users CANNOT make any changes (add/delete) to any of the data tables. They would still be able to run queries from them. How can this be accomplished?
  11. scra

    Printing command for more than one copy

    What is the code to print 2 or more copies of a report? I have a print command button and needs to print multiple copies of a single report.
  12. scra

    File sharing in Win2000 XP

    I have a file folder in my local drive. Can this file be shared to network users so it is accessible?
  13. scra

    Temp Folder

    Where is the temporary folder in Win2000 Home Edition?
  14. scra

    Batching reports for printing

    I would like to setup a form with an option group (something like that) to select 1 or more different reports for printing at the same time. Any ideas?
  15. scra

    File sharing from Win98 PC to XP

    I had just bought a laptop with XP Home Edition. My old laptop serving as the host for networking has Win98. How do I setup for file and printer sharing?
  16. scra

    Separating last and first names

    I have a field with last, first names, title. I would like to place them into 4 separate fields as: name SMITH, JOHN R MD last name SMITH first name JOHN middle init R title MD Please advice. Thanks.
  17. scra

    Problem with sharing the form with other users.

    I'm experiencing difficulties if more than one person is in the Access97 form. The error message as it appears.... &quot;Whenever you are not using <name of database> in Access, please be sure to close it out so that others can get in and enter/review data.&quot; Please advice on what to do...
  18. scra

    'Check all that apply' list box

    Would like to have the user the ability to 'check all that apply' method on the list box which allows to check and uncheck their choices. Suggestions?
  19. scra

    Page numbering in report

    I would like to add a page number on the report, but how do I add it on page footer if the page number starts at Page 8 and goes through 10.
  20. scra

    Formatting-add a back color property on report

    I would like to add a back color on every other line to make the report more readable. Is there a special code under the properties?

Part and Inventory Search

Back
Top