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

    Access 2010 Question

    Holding the shift key while opening the file worked. Thanks for your help.
  2. ccoffelt

    Access 2010 Question

    I tried F11 and nothing happened. I also tried to get to the Navigation pane by going to Creat tab>Navigation but it was grayed out and wouldn't let me click on it. I welcome any more suggestions
  3. ccoffelt

    Access 2010 Question

    We have a database that was created in Access 2003. We could double click on the database and it would bring up a switchboard. We could then go Window> Unhide and see all the Tables, Queries, Reports, etc. on the left hand side. Access 2010 doesn't have that option as far as I can tell. Or I...
  4. ccoffelt

    Need Help with Query

    Yes I have written a query before.
  5. ccoffelt

    Need Help with Query

    I have a table with the following fields: Name Start_Date Start_Time End_Time I would like to write a query that shows all work done on a certain start date (entered by user) between the time of 7am -3:30pm. I don't know much about Access and was hoping someone could offer a simple...
  6. ccoffelt

    Microsoft Access can't complete the Output operation...

    I should also mention it is not just this report that won't export. Same message for all reports while trying to export to Excel using Analyze with Excel option
  7. ccoffelt

    Microsoft Access can't complete the Output operation...

    Well shoot I seem to still be having the same problem. I've done the following so far: 1) Repair 2) Uninstall/Reinstall Access 3) Went to view code/tools/references and checked to see if any were missing. I've compared the references checked with a pc that works. Looks to be the same. I...
  8. ccoffelt

    Microsoft Access can't complete the Output operation...

    Could be. Maybe if I re-install Access and make sure full version is installed that will fix the problem. Thanks
  9. ccoffelt

    Microsoft Access can't complete the Output operation...

    If I go to another computer then it works fine. So must just be something with my pc
  10. ccoffelt

    Microsoft Access can't complete the Output operation...

    Recently when attempting to change a Report to a MS Excel File Format , I get the following error:- "Access cannot complete this operation.The Visual Basic code you entered contains a syntax error or the Output procedure is not available....." As far as I'm aware , I was not attempting to...
  11. ccoffelt

    HELP! I've really screwed up

    I was looking into how to secure a database by setting passwords and user-level security and stuff. I did something I shouldn't have and now I'm screwed. Every database I try to open comes up with a Logon screen that has my login and wants a password. Even if I create a new database it asks...
  12. ccoffelt

    Report to Excel

    I've created a report that I need to put into an Excel file. I've tried the Analyze it with Excel option, and I've tried the File, Export option. It doesn't transfer all the data. It looks like this on the Access Report: Dept Name Equip# BM CM DAILYCK DC 701 Maint OPR-001 2...
  13. ccoffelt

    How would I drop down a category?

    I'm using Dreamweaver 8. I was wondering if there was an easy way to do the following: I have it set up like this (heading called Policies and 601/701 underneath) Policies 601 701 and I would like to make it so that when the user clicks on 601 there are different categories that...
  14. ccoffelt

    Newbie Needs Advice

    My boss has asked me to build a website for our department. The software I have chosen to use is Dreamweaver 8. I took a class on Dreamweaver MX but it has been a few years and things are just slowly coming back to me. I was wondering if it was better to use frames or tables? I want the...
  15. ccoffelt

    query needs work

    Thanks dhookom. That worked.
  16. ccoffelt

    query needs work

    That kind of worked. When I entered a shift of 1 it pulled up workorders that had a shift of 1 in the box as well as some with blanks. However, when I did it for a shift of 2 it pulled in the 2's but also the same ones with the blanks again. I'm looking for all the 1's, 2's, 3's and then a...
  17. ccoffelt

    query needs work

    When the query is run, I want the user to enter the shift. So, in the Shift field I have the following in the criteria box: Like "*" & [Enter Shift] & "*" However, some of the workorders do not have a shift(the box was left blank). The query as is doesn't pick those up. How can I modify it...
  18. ccoffelt

    Analyze it with Microsoft Excel

    Yeah it was a Id 10 T error. I went back earlier today and realized I hadn't named them duh. New to this stuff. Thanks for replying.
  19. ccoffelt

    Analyze it with Microsoft Excel

    I just completed a report for my boss and he wants to export it into Excel so that he can manipulate the data some more. When we use the Analyze it with Excel option it does not carry over the Label Name. Instead it says Text 4, etc. Example: Text4 Text73 Text75 Plant 701 OPR-012...
  20. ccoffelt

    Query help...

    Awesome! You Rock! Thanks

Part and Inventory Search

Back
Top