Search results for query: *

I am trying to write a where clause in a macro in a MSAccess 2007 project. I need to reference a control value on a form for my where criteria, like: [participant_id]=[Forms]![frmGroup_Sales_MainData]![txtParticipantID] However, I get "Incorrect syntax near '!' error. Anyboyd know what will...

I am trying to read a few columns from a SQL table into a MSAccess Project report. I only need a simple recordsource select statement for the report's recordsource, but I need a where criteria that is an integer on a form in the project that is always open. However, I cannot get the syntax...

I am using the ...SetText / .PutInClipboard code as follows: With myobj Set myobj = New MSForms.DataObject myobj.SetText varReasonFinalText myobj.PutInClipboard myobj.Clear End With ..in an Access 2007 project behind an Access form. It works great, as long as the text...

I have an MSAccess project with linked SQL tables. I need to import data from an Excel spreadsheet into a SQL table that is linked to my Access project. I have the following code: Dim cn As ADODB.Connection Dim strSQL As String Dim lngRecsAff As Long Set cn = New ADODB.Connection cn.Open...

My company is using MS Access 2007 projects (.adp) with SQL 2005 very successfully. Now the company will be upgrading to SQL 2012. Will there be a compatability or connection issues with our current Access 2007 projects and the new SQL 2012? Thanks for any advice you can offer.

My company is using MS Access 2007 projects (.adp) with SQL 2005 very successfully. Now the company will beto upgrading to SQL 2012. Will there be a compatability or connection issues with our current Access 2007 projects and the new SQL 2012? Thanks for any advice you can offer.

I want to send a Lotus Note with VBA with an Excel file as an attachment. I can do this easily with the code below, (varPath is my path and name) but my task is to attach an Excel file that is created just before the Note is sent, without saving the Excel file in a folder. When the Note is...

I have the following code that creates an Excel file, puts data into the cells but now I need to save the file. I cannot get the syntax correct for the .......SaveAs FileName:= "xxxxxxx" Set obj = CreateObject("Excel.Application") Set oApp = obj.Application Set oWb =...

I have the assignment of opening and retrieving info from a Lotus database using VBA script. I have the following: Dim db As NotesDatabase Dim nsession As NotesSession 'As Object Set nsession = CreateObject("Lotus.NotesSession") Call nsession.Initialize Set db = nsession.GetDatabase(serv, app)...

I have the assignment of opening and retrieving info from a Lotus database using VBA script. I have the following: Dim db As NotesDatabase Dim nsession As NotesSession 'As Object Set nsession = CreateObject("Lotus.NotesSession") Call nsession.Initialize Set db = nsession.GetDatabase(serv...

I have the follwing code but cannot get to compile: serv = "njros1nap2020" app = "webchat\iLi\cvcchatlog.nsf" Dim db As NotesDatabase Set db = Session.CURRENTDATABASE Set db = New NotesDatabase(serv,app) I get' Expected: end of statement error' at the '('character before...

I am tasked with extracting data from IBM Lotus Notes db's and inserting the data into Excel. Does anyone have familiarity with the following code: searchFormula$ = "'((Form = 'ITAgentLogEntry') & ITLog_ConversationText = 'Sample Logging' )& '" If so, can you provide assistance into...

To any MS Access 2013 users out there: if you were using an earlier version of Access as .adp projects with SQL back end tables AND stored procedures, were you able to convert to MS Access 2013 by linking your SQL tables AND by linking your SQL stored procedures? Or were you only able to link...

I know SQL has the Datediff function but does anyone know of a way to determine the difference in days when just using the month and day from two dates? For example, I need to know if today's date, GetDate() is within 60 days of a given past date, like 10/23/2003. Seems simple enough using...

My company uses many Access 2007 client end applications with SQL tables and stored procedures as server support. Naturally, they are all .adp project files. My question is, I've heard that Access 2013 will not support .adp files anymore but you can still link SQL tables to the files. But...

I'm using Access 2007 and was recently upgraded to Windows 7. Since the upgrade, I've noticed that the 'Design Tab' on my Menu bar no longer contains a drop down listbox (ddl) that lists all the control names on the form currently displayed (in design view). It was located directly above the...

I have just been upgraded from Windows XP to Windows 7. Now I am missing the comctl32.ocx file when I try to set my references in Access 2007. It is not in the C:\Windows|System32\ directory. Is this a file that has to be registered in some way by a system administrator? Thanks for any help...

I have a combo box that is correctly displaying a list of employees and a number assoc. with each. However, when I select one of the names and move off the control (with the cursor), on the name of the employee is displayed in the combo box. I have the bound column and the employee's ID number...

I have to add a new database role to one of my SQL 2005 databases so I can grant execute permissions for it to some applicable sp's. Is this something my company's SQL database administrator has to do or can it be done locally, by me, for example, thru a wizard or by executing some script...

I am sending a Lotus Note using VBA code behind a MSAccess 2007 form. All works great, except now I want to send to more than one recipient in the 'Copy To' part of the process. A snippet of my code is: ... ... Call objNotesMailDoc.ReplaceItemValue("SendTo", strRecipient) Call...