Search results

Thanx! especially for providing the complete Replace statement. I'll have a Beer ;-) Have a nice Day!

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

Ok I change the SQL statement. But the 2427 error still occurs on the first line If Forms!frmIdeas.frmIdeas_Questions.Form.maxQID = 6 Then any other ideas?

ideaID (Number type) is the primary key for the main table (tblIdeas), in this case it is a secondary key for the question table (tblQuestions) which ties an Idea to to one or more questions (questionID - Number type). tblQuestions also has Memo filed for Answers to the questions. The insert...

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