- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To parse a Text field that contains two words separated by a comma, follow
these steps:
Open any existing database.
Create a table with the following structure:
Table: Parse2Words ------------------ Field Name: Empl Data Type: Text
View the Parse2Words table in Datasheet view and type the following
three records in the Empl field:
Smith, John
Callahan, Laura
Fuller, Andrew
Create the following query based on the Parse2Words table:
Query: QueryTest ------------------------------------------------------------------ Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1) Show: True Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1) Show: True
NOTE: You can modify the QueryTest query to account for spaces between
the two parts in the Empl field. For example, if the text in the Empl
field is "Smith,John" without spaces, remove the -1 from the FirstName
field expression.
Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below:
FirstName LastName -------------------- John Smith Laura Callahan Andrew Fuller
Do you hear the type hitting the paper? Is the ribbon installed properly and in good working order (a carbon film ribbon is all black, or a cloth one has ink in it)?
You cannot open a PDF file directly in MS Word. You must first convert the PDF file into a Word file.
Of course, you can also open the PDF file in Adobe Acrobat or Acrobat Reader and then copy and paste text from it into Word.
If you have Adobe Acrobat, though (not just the free Acrobat Reader), you can open the PDF file with that program and then save that same file as a text, rtf or a Word document file (go to File, Save as, and then choose the type of file to save as), you can then open and edit in MS Word.
Make sure you black is in the lower palette box as shown. When it's reversed with white below the black, as you type the text will show in black, but not within the actual text are. Take a look at this image to see what i'm talking about.
Why not use Word Automation? You instantiate an object with a reference to Application.Word, load your document, then use the built in functions to extract the text from the document and paste it into the MSP document.
Make sure the drums are properly seated in their cradels, and if posible, avoid designing with white small text in heavy solid areas that are made up of process colours. For reverse type in a black background, use spot color black rather than rich black. Other than than printing on a not as heavy card, that is about all you can do.
×