Search results for query: *

Here's my code Function outliers() 'create outliers report DoCmd.setwarnings False DoCmd.RunSQL "SELECT Skills.Type, Employees.FirstOfKey, Sum(YTD.[ACD CALLS]) AS NCH, Sum([ACD AHT]*[ACD CALLS]) AS Total_AHT, Sum([ATT]*[ACD CALLS]) AS Total_ATT, Sum([ACW]*[ACD CALLS]) AS Total_ACW...

Here's my code... Private Sub prev_month_Click() If Me.hidden_month_clicks = 0 Then MsgBox "went back to the beginning of the year" Me.hidden_month_clicks = DatePart("m", Date) Else Me.hidden_month_clicks = Me.hidden_month_clicks - 1 Me.Month_NCH.ControlSource =...

I need to make a string that is based on what the user selects on a form. I have a continous form based on a table named "Ethnicity" which has a list of all of the ethnicities the user has listed. In order for them to search on the ethnicities I need to popup the continuous form and...

I have a function in the toolbar that produces a report. When the report is open in preview, it is hidden behind the switchboard. Is there a way without closing the switchboard that I can have the form receive the focus.

Interesting Question: I want my users to be able to send email from my database. {I got that part figured out} Now, what I want is them to be able to select the attachment. I need to do a {browse} type function that allows them to browse for the file they wish to attach. When they select the...

I am using Access 97, and I need to allow my users to type in multiple keywords in a textbox and have the database, replace the comma with the word OR. That way my SQL statement will read the textbox field and find any records in the database that have matching keywords. Example: user types...

I would like to have it where users could save queries and once they are saved, they are automatically placed in one of my drop down menu bars. For instance, if I have a menu bar name.... Main Menu and there is a drop down on there name Queries I would like for the saved queries to be...

I am having a hard time understanding how to get the system to search by more than one keyword in a textbox. I know it could be done in which the user types in: Example: computers, handheld, data And it should return all companies that have the keywords, "computers" or...

I wonder if anyone knows a way to allow my user to select whether or not they want the icons I created to show just the Image Or Text or Image and Text. If there is a way to program that in visual basic, where I can setup a form that asks them those questions, I'd appreciate the help.

Now this is my important question YET!, that I've posted on Tek-Tips, and if someone could help me out on this one, I'd be completely grateful. Now here's the lowdown. I have (1)one database, that needs to be used in (3)three different cities. So, because the company doesn't have a WAN set up...

I would like to change the message box buttons to say something else.... right now, they say "Yes" "No" "Cancel" I would like for them to say "All" "Current Year" "Cancel" Is this possible? I'm afraid I'm going to have to make my...

This is so frustrating because I know it's easy. I have the calendar Active Control on a form. When the user selects a date I want the subform to jump to that date and reveal the events for that date. To test whether or not Access could distinguish the date from the calendar, I made a message...

I am trying to write an SQl statement in my Access Module. I can't use the " where they belong, is there a way I can use ( instead? My SQL statement Reads: DoCmd.RunSQL"UPDATE [Quarterly Report] SET [Quarterly Report].Jan = DSum("[Jan]",'Quarterly...

I have a couple of obstacles. #1 A report with the possibility of 56 fields. #2 Getting the database to build an autoreport based on the fields the user selects to have print out If anyone can help with these problems, please let me know.

I have a VB command that I'm trying to run to get my db to create a table. The problem is the code is apparently too long to fit on one line and it is wrapping, therefore breaking the code. Any help is welcomed.

I have a need to allow my user to select from 56 fields the particular fields in which they would like to print on the form. If you have any ideas, please let me know.

Hello Gang! I have a search results page that lists the results from the search the user has submitted. What I would like to do is have every other row highlighted. If you know of a way to do this, please let me know.

I would like to delete a record from the listbox recordsource if it has been selected to be deleted. But I am at a loss on how to run the SQL statement to recognize what the selected value is.

I have a listbox on my Search page with a list of all of the zip codes of the businesses in the system. I would like for the user to be able to select a zip code or many zip codes and hit SUBMIT and the system should return the companies that match the selection(s) from the zip codes in the...

If someone could assist me with this. I am in need of a way to allow my users to search the database using multiple criteria options. For instance; if a user wants to pull a list of companies in a certain range of zip codes. I'd like for them to able to type in the textbox...something...