Search results for query: *

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

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

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

Yes I have written a query before.

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

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

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

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

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

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

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

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

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

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

Thanks dhookom. That worked.

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

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

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.

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

Awesome! You Rock! Thanks