Recent content by bitech

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