Search results for query: *

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

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

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

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

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

I have a query that shows the same workorder several times because they have worked on them different hours/different days. This is what it looks like when I run the query. Start Date WO# Name Hrs 7/7/08 285324 HW 3 7/22/08 285324 HW...

I am writing a report using MS Office Access 2003. Currently the output looks like this: Department Name Equipment # Category Hrs. OPR-012 BM 2 OPR-058 CM 3 OPR-061 BM 2 I want it to look like this...

I have a Access 2003 database that includes the following fields: Drawing Type Equip. # Equip. Name Drawing # Revision # Title Location When I enter the Equip. # I want it to automatically put in the Equip. Name. Example: I type in OPR-001 and it automatically puts in the name Sensor Heating...

I have a query that asks for the user to enter the machine number: PPR, CPR, MPR, or OPR. How would the user enter for both OPR and CPR? Right now they have to run the report twice but would like to just run only once. Tried using :, & but neither worked. Any deas???

Help! I'm new to this Access stuff. First of all, I'm using Access 2000. I created a nice report for my boss that has the following info: WO# Worktype Status equip# Problem Countermeasure Resp. Person Start Date Finish Date Now the hard part is I need to export this report to an existing...

We have a database here that our Mgmt. uses for reports. I did not create the database but rather inherited it. I put the icon for the database on someone's computer this afternoon and the switchboard does not show up for some reason, but I can hold the shift key and double click the icon to...

I need to write a query that shows all of my open work orders thus far. I did that with no problem. However, I also need to show what work orders are past due. For example, if today's report date is 1/17/06 on the Work Order and it is still open on 1/24/06 then it is 1 week past due. And if...