Search results

  1. B

    Linking an Access table to an excel file in Sharepoint

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

    Excel VBA insert into access query - Check if 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...
  3. B

    Passing Access SQL query through Excel VBA Code

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

    MS Access SQL - Like statement with object value

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

    MS Access SQL Where statement based on Combobox value

    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?
Back
Top Bottom