Search results

Ok, I see what you were asking.... it is not a list, it is currently document. I want to be able to make regular updates to the document so that's why it isn't a list.

im not sure what the definition of a list is... its an xlsx file that has a table in one of the tabs, which is updated regularly. does that help?

I have an excel spreadsheet in SP, and I'm trying to create a table in Access that is linked to a tab in an excel spreadsheet (which is in SharePoint). I am clicking the External Data > Excel (Import & Link) > copying the sharepoint path (after opening sharepoint in windows explorer) and...

thanks Stopher... I'm new to access... that is good advice.

I just guessed at using rs.Close... and so far.. success!

I really just want to be able to pass an SQL query, see if records exist, and then do something based on that information. Then I want to be able to run that test again with different variables each time, and sometimes different tables.

Ive made progress since posting this, my current script looks like this: qry2 = "Select a,b,c FROM table WHERE a = """ & a & """" rs.Open qry2, conn, adOpenKeyset If (rs.EOF) Then MsgBox ("Hello") End If Im successfully getting rs.EOF = False when the record exists...

Not sure if this should go in the Access forums or the Excel, ill post to both... Im using this VBA line to insert into an Access DB: rs.Open qry, conn, adOpenKeyset rs is a RecordSet qry is a String ("Insert INTO Table (a,b,c) Values(a,b,c)" I want to preface this command...

FYI, I finally solved this... a week later.... by putting brackets around the field names: Insert INTO tablename ([Field1],[Field2],[Field3]) VALUES ('Value1', 'Value2', 'Value3') Now, I've been successful without brackets in the past, my guess is that certain spaces or characters require...

again, what kills me is that I am doing the exact same scenario elsewhere in my code successfully, which leads me to believe its a table data mismatch, but when I use that same insert query in Access, it enters the data correctly with no error.

This is how I'm connecting: Dim conn As New Connection Dim rs As New Recordset strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\localprofilepath.accdb;" conn.Open (strcon) then qry = "Insert INTO tblPartnerCreditRating...

This has been working for me and all the sudden it does not... Here is my query: Insert INTO tblPartnerCreditRating (PartnerID,QuestionID,YearValue,Fitch,Moodys,SP,Local) VALUES ('Partner name', 'G3.1', '2014', 'NA', 'Aa3', 'AA-', 'NA') When I run this through Access is works perfectly...

Thank you for the link for when and how to use [ME]!. How do you correctly use wildcards in a like statement when referencing objects?

I want to use this code in the rowsource for a listbox: SELECT DISTINCT mps.[Partner Name] FROM MasterProfileSummary AS mps WHERE (((mps.[Partner Name]) Like [Me]![TextSearch])) OR ((([ME]![TextSearch]) Is Null)) ORDER BY mps.[Partner Name]; But I'm getting an enter Parameter value error...

awesome. Thanks

This worked successfully. However, if I change Combobox A's value, and Combobox B has a where statement dependant on Combobox A, why doesn't Combobox B automatically update when the Combobox A changes? How can I achieve this goal?

SELECT DISTINCT NetworkManager FROM MasterProfileSummary WHERE Region = [Forms]![formQuestHist]![comboRegion] If the combobox "comboRegion" is null, then I want to include all regions, else I want to filter for the region specified in the combobox. How should this Where statement be altered?