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

...cn = New ADODB.Connection cn.Open "Provider=SQLOLEDB;Data Source=PAERSCBBxxxxx;" & _ "Initial Catalog=mydatabasename;UID=;PWD=;" strSQL = "SELECT * INTO dbo.CC_table_name FROM " & _ "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _ "'Data Source=Y:\TECHNOLOGY\xxxxx.xlsx;" & _ "Extended...

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.

...is currently open. Dim objNotes As Object Dim objNotesDB As Object Dim objNotesMailDoc As Object ''******************************* Dim attachment1 As String Dim AttachME As Object Dim embedObj1 As...

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.