Search results for query: *

Thanks for the tip Philhege. That, and when I used the stmt as a report recordsource, I forgot that the where clause can be stated as: ...where participant_id = ?. When you use the ? character, the report knows to look down at the Input Parameters property box where the criteria can be...

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

Thanks for the advice lameid. What I ended up doing is creating a local table in my project, using TransferSpreadsheet command to get the data from Excel into that table then did a local 'Insert Into' stored procedure to get the data into my SQL table. For now, we have a SQL database/server...

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

After much trial and error and a little help from a Lotus db programmer, below is the answer to my question. Note that '@Created' is a field in the Lotus Notes db. This format is useful when the LotusDBSQL OBDC driver is not an option. varA = "Form = ""ITAgentLogEntry"" & @Created > [" &...

After much trial and error and a little help from a Lotus db programmer, below is the answer to my question. Note that '@Created' is a field in the Lotus Notes db. This format is useful when the LotusDBSQL OBDC driver is not an option. varA = "Form = ""ITAgentLogEntry"" & @Created > [" &...

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

SkipVought: Can you provide any assistance? Would appreciate anything you can provide.

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

Yes, sorry. Its MSAccess 2007.

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

Thanks for all your responses. I am looking at all them to see what works for me. LyndonOHC: can your response be put into SQL. Thanks again, I will post whatever I come up with that works.