Search results for query: *

I have a database that keeps extensive data on response times, by date. I want to get the top 14 people who responded to EACH incident on a selected date. (There could be instances of 7 or 10 incidents per date and 14+ people responding to each incident) I believe that some incantation of Top...

Hi all, I would like to convert a general number into a time format dynamically. Currently time is put in without colons separating the hours, minutes and seconds. It appears as such: 95904 I need the number to appear as 9:59:04 Is there an easy way of converting this text into a time format?

I want to password protect a powerpoint presentation or at the very minimum, make the file read only. Can this be done? I have a number of enterprising co-workers who like to tinker with things and make changes-often inappropriately. Can I by chance, make a file that has to be stored on a...

I know I've asked before, and received an answer but I can't find it in my search so if you don't mind let me ask again, and be prepared to print the solution. I know that I shouldn't print a form, but we have monitors that go out in the field and would like to take a blank report in paper...

Has anybody done this? I have a database that was created in 97 and works like a charm. Security has been set, users are able to log in and out etc... Now our IT department has rolled out 2000 enterprise wide. I've attempted to open the database and get an error that states: The current user...

I want to be able to show records from the database where the beginning date is between 04/01/01 and 6/30/01 and exclude those records that in that date range that have an ending date that is greater than 3/30/01. I can of get the report to work with either of these statements but not with...

Let me preface my request by saying that I searched in the keyword search and FAQ area for an answer prior to posting, but I must be wording my request incorrectly. I am using a business day/holiday formula that I found on the Crystal Decision's Website to determine actual working days between...

Using PROPER in excel changes text to both upper and lower case. Capitalizes the first letter of the name and makes the rest lower case. . . Most of the formula's in Excel transfer over to Access but not this one. Any suggestions for getting text to convert to sentence case in Access? A...

We have a Novell Network and we have 28 users that need access to our database. I have set up security for all of the 28 people by various groups. The problem is accessing the system.mdw file. It appears that I will have to visit each one, to connect them to the proper system.mdw file which...

I want to extend my thanks to everyone on this list. This has been the MOST helpful forum that I have been a part of and I want to say thank you. The tips, tricks and helpful advice that you all contribute to have been lifesavers in many instances. I can only hope that my knowledge will...

I created a toolbar for my database and turned all the other tool bars off except for the menu bar. I don't have time before my 2:30 pm meeting today to create a custom menu bar but I will. In the meantime, I want the toolbars to stay turned off when other users open the database. As it...

I have some reports that must be printed on Legal Paper. Instead of having my user, go to File, Page Setup, Page, paper size, legal... is there a way I can automatically do this through code? Please say yes, and explain to me how to do it. Thanks Sharon

I want all of my forms to open to Full Size. Instead they move all over the place. I have a switchboard that opens to full size the first time it is clicked on. When it opens other forms, they open to various sizes, even though they were created the exact same way the switchboard was. When...

I have a report that is based on staff name. I have a subreport that gives totals on decisions by staff name. Both report and subreport use parameters. For the convenience of my users, the answer to both parameters should be the same, hence I want access to take the value of the first...

Am I experiencing a problem with the brain today? I want to store a concatenated value of 3 text boxes into one text box. I can do it by changing the control source to the concatenated expression but when I go to write the expression in VBA on the afterupdate property it bombs every time. . ...

Can you store the value of a DLookUP in the underlying table? I have my DLookUps working on my form and want to store the results in the table. Is that possible?

I don't want my users to have to figure out what fiscal year we are in for our database. I need to store the Fiscal Year in the table as it is part of our project number. Our fiscal year starts in July. July 1, 2000 was actually FY 2001, the same is true for January 25, 2001. Today is still...

How do I get my column Headings from a select statement to show? We just loaded SQL *PLus on our machines, and everything works well but we cannot display our column headings. A sample statement is as follows but something seems to be wrong in an the configuration of SQL *Plus. SELECT cost...