Search results for query: *

I have the view listed below and want to add a table from another data base to it. The data base is Institute and the table is Prospect_Applicant. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME, dbo.PEOPLE.LAST_NAME, dbo.ACADEMIC.ACADEMIC_YEAR...

I have databases that I have created in Access 2003 that work fine, but in the last few days when I try to import a form and query into a new db it freezes up and works very slow. Can any one provide any insight as to what I can do to make it run alot faster like it should?

Has any one had a problem with Access 2003 locking up and not working or opening forms, queries, tables extremely slow. I created a new db and imported all the above into it and it still performs very slow!

I have the following code and need help in creating a left outer join with the People table using People_Code_ID as the join. Here is the dba db and table name. dbo.Institute.Prospect_Recruiter. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME...

How can I rem and add multiple subscribers in audix in order to clear the subscriber so a new person can add their own messages. If I export and import will this do what I want? When I select export do I have to put the extension(100) along with the number and follow the steps or is there...

I understand the concept of Max and Min for a criteria, but is there a way to bring back records that are between them as well. There are people who may have attended one class year or two class years or three class years. Example: Name Bob Jones 1980 High School 1984 Junior College 1986 Senior...

I have a query that should list all the records with a yes for Recruiter_Selected yet they do not. The main problem I am having is that this query worked great before and now it does not work at all without any changes made to it. Here is the query; SELECT DISTINCT People_Information.*...

What causes # ERROR to show up where the data is supposed to be in a report. I know if you key in the wrong information for criteria of a query or have the report using a different query than what it should it will cause this error but this is not the case with me getting the # Error.

I want to change about six hundred stations with names to have no names associated with them. Based upon having a COR of 8 or 9. Is there a way to export this info and change it and then import it back into ASA. I have tried it but not having much luck.

I have a form with a subform. In the subform the selections are based off a combo box and an active X calender as the start date. If I have some with a start date of 10/3/2003 and 10/6/2003 they both show up in the subform, but when you run the query for the report only one the 10/3/2003 shows...

I would like to put a combo box on a report based off a query so when I made a selection from the combo it would display that info based upon the criteria selected. I have never done this with a report and would like some help/suggestions.

I have a query that runs extremely slow and want to know where the problem lies. If I go to tools-analyze-select the query I do not get any information back saying there is a problem. Is there another way to check?

Is there a way to have a cordless analog phone flash so that some one knows they have messages in audix. Currently the person has to remember to check for messages. Could I put a splitter at the wall jack and make one side go to the cordless phone and the other go to another analog phone that...

Using this code below for a text box in a report can I make the Name: in red and the First_Name and Last_Name in black? ="Name : " & [FIRST_NAME] & " " & [LAST_NAME]

I know there is a property for a text box called can shrink and can grow. My question is I have a report that has text boxes lined up horizontally and want them to grow or shrink according to the text in them because I am getting text cut off. I tried the can shrink and can grow and it made the...

I have deleted a switchboard which opened when you clicked on the db icon. I have instead created a form that should open upon clicking on the db icon. The problem is I get an error saying that it is looking for the switchboard and this no longer exists.

I have a letter and have data from a query in the detail section of the report. I have a footer before the page footer which say Sincerely the person's name. How can I make this footer be spaced depending on how many records are in the detail section. The way it is now if there is one record the...

The report I am making prompts me for a First_Name and I do not have anything in the Criteria for this field name how od I get it to stop prompting me for the name?

I want to set up a COR to receive calls but only make local calls. How would I do this. I have looked at the COR's we have in place. Would it be page 3 and 4 in Avaya Site Administrator? If so what are the changes I need to make?

I have a question about a send calls button! I thought that if you program a button to send calls and put the extension beside the button all the calls will go to the ext that was ssigned to the button? Example: If I call extension 8112 and this extension has a send calls button programmed to...