Search results for query: *

I updated my machine to version 20H2. When I look at the "review update history" in settings there is no entry showing the update took place. I thought maybe the log file was corrupt so I ran sfc /scannow and repaired the log file. Rebooted and still no change in the view update history. Is...

I have a master table (tblMaster) with ID, Address, City, and Zip and many other fields. I also have a spreadsheet with corrected information I imported into a table named "Fixed Address4". The imported table contains ID, Address, City and Zip. I can join the two tables via the ID which is...

The code below has worked for several years. I am using Office 2010 and have been for a couple of years and this code always worked until yesterday. I now get an error on the line "Set MyOutlook = New Outlook.Application" in red below and have no idea why. The error is Run-Time error 429...

I am having a problem with getting the WHERE statement to work. I currently get an error saying characters found after sql statement (3142). I think it has to do with having two sql statements in the query. However, I do not know how else to write the where part of sql to include the Where and...

I have used the code below in Access 2000, 2003, 2007 and now 2010. I am also using Access 2010 with Windows 8.1. The problem is this code worked well until I went to Windows 8.1. It should send email to 300 recipients with 3 attachments. However, it sends about 150 and then a message pops up...

I am very new to Powershell. I managaged to create a script and have it execute via a .bat file. My problem is the output is not very user friendly so I wanted to add some HTML to make the output more easy to read. The code below shows what I am trying to do but I only get the heading and...

I am running Access 2010 and when I open my database it says there is a missing or broken api, name: accessibility.api v3.0. When I open the reference library there is no accessibility.api v3.0. How do I get this api? Where is it located? Very lost on this one. Thanks

I hope I am in the right forum. I have a general question that requires some guidance. Is it possible to run Terminal Services on Windows Server 2008 with Office 2010 BUT have Outlook run in the Cloud? In other words we want to keep Terminal Services for Office 2010 but outsource Outlook 2010...

I have code behind a timesheet form that I want to modify. I currently have an IF statement that allows the strTemplatePath to save timesheets depending on which company work is being performed. I need a way to modify the strTemplatePath so that it uses the CompanyName along with the date and...

I just converted an Access 2003 database to 2010. All the queries work but one. the error is data mismatch in criteria expression. below is the sql for the query and I have no idea what is wrong. Suggestions? TRANSFORM Sum([Time Card Hours].BillableHours) AS SumOfBillableHours SELECT [Time...

We currently have Windows Server 2003 R2, Standard X64 Edition that uses Terminal Server. We also have .NET 1.1, .NET 2.0, and .NET 3.0 and .NET 3.5 installed. I am having an issue with QuickBooks and they recommend I run a repair or reinstall .NET My Question is,can I uninstall .net 1.1...

We are a small Microsoft shop that does business with the government. What I am looking for is freeware that can help us identify ISA Server DNS intrusion detection. Any suggestions as to what tools might be available is appreciated.

I have the following code on a form to look up last names that sound like XXXXX. The code works but only finds the first occurance. Can anyone tell me how to modify this code to show all the records that meet the search criteria. Thanks Dom Option Compare Database Option Explicit Sub...

Hi guys, I have code that exports data from Access to Excell and it works fine untile I try to save the resulting open spread sheet to a specific directory. No matter what I try it save to My Documents. I even tried the ChDir command and that did not work either. Can anyone suggest the...

The code below is run from a command button on a form. It opens a query parameter form that I use to select the begin and end dates. The query results go to an excel spreadsheet. A second spreadsheet opens and links to the fields returned in the first spreadsheet. All of this works fine...

I have the following code, which is simply to open a query from a command button. However, I get Type Mismatch error when the code reaches the line in red. Private Sub Excel_Time_Click() On Error GoTo PreviewExcel_Time_Err If IsNull(Me![TimeCardID]) Then MsgBox "Enter time...

We 25 users on Windows server 2003 using terminal server. The users have HP thin client machines with XP embedded. I am having a problem with the GP that sets the inactive session limit to 30 minutes. The problem is the inactive session limit works for some uses but not all of them. However...

I have a single table of names and addresses. I have managed to parse the city, state, zip, etc data but now need a way to clean up the Address1 column. Since all the records that need to cleaned up have the City name someplace in the Address1 column I thought I could select the records I need...

I have a query (qryMasterQuery_WithEmail) that is used to send bulk email. The problem I am having is one of the fields in the query (SWITCH]) can have nulls which makes the code error on the SWITCH field saying improper use of Null values in the line: (MyNewBodyText = Replace(MyNewBodyText...

We are a recruiting firm that has 20 users running on terminal server 2003. We are noticing a high CPU usage on IE7. So much so that if 5 folks are browsing the web simultaneously, the server CPU usage runs at 100%. We also run window 2003 Outlook and Office. No other application pegs the CPU...