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

It appears my security file was corrupt. I am not sure what caused it and had tried replacing it multiple times, but on the last try, it suddenly opened. Yes, it was a front end and I did have back-ups of both the front end as well as the mdw file. Thanks.

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

The following comes up in the immediate window: SELECT qryEMS_TestResults.* FROM qryEMS_TestResults WHERE (((qryEMS_TestResults.CourseID)= 1567)); This is what it needs to be. When I pulled the field name out of quotes, as suggested, it started working if I switched to ADO instead of DAO...

If I copy what is in the Immediate Window in to a query, I get data. I switched to: Dim rs As New ADODB.Recordset sql = "SELECT qryEMS_TestResults.* FROM qryEMS_TestResults WHERE (((qryEMS_TestResults.CourseID)= " & [Forms]![frmEntry-Field]![cboLocateRoster] & "));"...

Thank you for the suggestion. I tried both and I even tried just throwing in a value and finally added the condition to the query. I get the error: Run-Time Error 3001: Invalid Argument. The error comes on the line: Set rsinstr = DBEngine(0)(0).OpenRecordset(sql, dbSeeChanges) Any other ideas?

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

Try this: Format("12/31/" & Year(Now()),"y")

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