Search results

Data has been imported (from Word, Excel &/or PDF) into a Memo field in an Access 2007 database. Sometimes the data appears fine. Other times there appears to be excessive and unnecessary Linebreaks / paragraph returns throughout the data in the Memo field. Is there a way to search for and...

I have the following code: If Forms!frmIdeas.frmIdeas_Questions.Form.maxQID = 6 Then Else Dim sqlQ6 As String sqlQ6 = "INSERT INTO tblQuestions ( ideaID, questionID) Values (ideaID, 6)" DoCmd.RunSQL sqlQ6 End if *Send email code* And I get the 2427 No data error if there is no data...

I have a combo list where you select a Responsible POC. Want to limit the selection of list to current POCs. But want to be able to display all POCs for historical records even tho they are no longer current. Table of POCs is set up to hold pocID (#), pocName (text) and NLPOC (checkbox)...

I uploaded quite a bit of data from an extensive list of Word Documents. In some of the Memo fields, it imported these weird Squares. Some times at Tabs or Paragraph returns. Is there an Easy way to remove these things? Thanx! RHM

First Time Poster to this site. Im using Access 2007. I've been asked to create a process where users can browse to a file on their computer and once that file is selected, that file is: 1. Saved to a specific Server location 2. URL is placed in database so that others can Click on it and go...