Search results for query: *

We just upgraded to Access 2010. I have an Access front end with SQL server backend. Before the upgrade, users entered their login information when they opened the database and it passed the information through to SQL. Now, when the database is opened, they have to enter it twice (once for...

I have all of a sudden started getting an error trying to open an database. I get the following error: "You do not have the necessary permissions to use the "..." object. Have your system administrator or the person who created the object establish the appropriate permissions for you" I have...

When I run the following code I get an error 3001: Invalid Argument Here is my code: Dim rsinstr As DAO.Recordset Dim sql As String sql = "SELECT qryEMS_TestResults.* FROM qryEMS_TestResults WHERE (((qryEMS_TestResults.CourseID)=[Forms]![frmEntry-Field]![cboLocateRoster]));" Set...

I have the following code running in an Access 2002 database without any problems: Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) With MailOutLook .To = Email .Subject = CourseDescription & " -...

The company I work for would like me to create a simple page on our website. They do not want to involve the consultants that developed the website. I am not a web developer, but I am pretty good at taking pages that already exist and modifying for my purposes. I have found a page that works...

I have a table that I automatically assign certification numbers based on those assigned (for example 1240000-1241500). Occasionally a number will get skipped or deleted and I need to be able to find those numbers that are skipped. The only field I need to look at are...