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

Hello: When I tried the code, I received a Type mismatch error. Does anyone know how to avoid that. The error comes on the Set prop3 = fld3.CreateProperty("InputMask", dbText, "(###) ###-####")

In your macro the first line needs to be set to SetWarnings and in the bottom box it will say "Warnings On". Make sure this setting is set to No. Your last line needs to be set to Setwarnings and in the bottom box "Warnings On", it needs to be set to Yes

They would be able to select more than one ethnicity, which I wouldn't even know what the ethnicities are because they aren't static they are put in by the user. So it needs to look for anything in the ethnicity table that has an "-1" and search for anything company in the vendor...

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

thanks for the advice...actually when I posted that, I thought about the DoCmd.SelectObject function and I have decided to use that

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.

You'll find that this is relatively simple: Right click on the Menu Bar: 1. Click Customize 2. Click on New {off to the right} 3. Name the toolbar 4. Go to Commands, {second tab} 5. Here you can pick what function you want to appear on the toolbar. Or you can create a custom function.

I need the code that will pull back the whole file. Any givers.

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

Can you explain that code to me.

In Access97, the Replace Function isn't available. Somehow I need to write my own, but I don't know how.

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

peitzza: I know this has been a long time ago, but if you still have that database can you email it to me at kleadon@gccc.com

Maybe you can help me out....I know you pretty much wrote the code out there for me....but sometimes I don't know where to insert my stuff and where not to change the code... The textbox I want it to retrieve the data from is called keywords the delimiter I want is , {the comma sign}

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

If I could get the query to understand that the Or statement needs to be inserted in every occurence of a space or a comma

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.