Computer Support Forum

MS Access 2000 text field characters.

Question: MS Access 2000 text field characters.

Hi all, been away for a long time.My problem is this :I have an MS Access 2000 database listing song titles. I have built a form and added control buttons for "First Title", "Last Title","Next Title" and "Previous Title"These four controls work successfully, going to the denoted record as required with no problems.THE PROBLEM:I have tried to add a combo box using the "TITLE" field only from my form data. Song titles often include the character apostrophe ('), example...."Don't Cry For Me Argentina"When I click in the combo box and select a title with the ' in it I get a runtime error 3077 and cannot go to that record. Titles without the ' in them display in the form with no problem.MY QUESTION:Is there any way to display the song title correctly (including the ') without the combo box treating it as a rem and thus throwing up the runtime error?My db has a number of fields giving info on the song and display on the form.Operating System Windows 98SEProcessor Intel 600E CoppermineRAM = 256 MbHDD 40 GbMS Access 2000 is the db.Grateful for any advice.btw....I only have a very limited idea of Visual and Access Basic !!!

Relevance 100%
Preferred Solution: MS Access 2000 text field characters.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: MS Access 2000 text field characters.

I would do a search of the MS knowledge base, refining it to searching Access 2000.

3 more replies
Relevance 77.49%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\Source.dot" AA} and {IncludeText "C:\\Source.dot" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,

Stuart
 

Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.
 

3 more replies
Relevance 77.08%

Hi,

I have a doc which I have added the many checkboxes by using Check Box Form Field. Now I want to add textbox for others to enter text. I have added a Text Form Field to the doc but it is kind of hard to tell that there is a field in there. How I can make something like this:

___________________________________________

___________________________________________

___________________________________________

so others can enter text above the lines only or making an enclosed box so others can only enter text inside the box?

Thank you for any help,

Peter
 

Answer:How to use the Text Form Field in MS Word 2000?

7 more replies
Relevance 73.39%

I am currently building myself a stock database system in MS Access 2000. On one of my forms and reports. I want my text in a textbox element to flow vertically. I have found a method to do this, but the text runs the wrong way. Would it be possible for my to correct this in anyway? If so how would I do it?

Answer:MS Access text field orientation

Help! Anyone? Please.

2 more replies
Relevance 72.57%

I have a memo field in my application that the user needs to put a lot of text in with numbered items that require indentint. The finished report looks awful because she is forced to space between the numbers and the text instead of a clean indent. I am using the runtime version of Access 2007 field. I need find a text editor that will hold formatting and keep it in the field for the report.
 

Answer:Text Editor for Access 2007 Field

8 more replies
Relevance 72.57%

I am trying to insert an address and slide the text up so I do not have to see the blank lines plus extra space.
 

Answer:Access - slide text up if blank field

7 more replies
Relevance 72.57%

My Access 2007 database contains records with a text field of up to 255 characters. these records are being imported into a system that allows up to 39 characters for this data. I'm seeking help to create a query(queries) or macro(s) that will create additional records with each one containing the next 39 characters in the text field. For example, a record contains 125 characters in its text field. I need to end up with 4 records such that record #1 contains the first 39 characters, record #2 contains the next 39 characters, and so forth.
 

Answer:Parsing text field in Access 2007

6 more replies
Relevance 72.57%

Hi,

Help, I am a novice at Access 2010 and am attempting to write a custom [COLOR=green !important][COLOR=green !important]database[/COLOR][/COLOR] from scratch.
How do I get data from multiple text fields to show up combined in a seperate text field. I want to combine the First, Middle Initial, and Last Name fields so they will be combined in a seperate field I named Complete Name.

I typed the following into the Validation Rule of the Property section for the Complete Name text field however, the Complete Name text field remains blank in Form as well as Table.

Trim$([FirstName] & " " & [MI] & " " & [LastName])

I hope I explained this correctly as I am relatively new to Access. Can you give me any advice or suggestions? Thank You

VMM101
 

Answer:MS Access 2010 Text Field Question

There are 3 ways to do this.
1. This method uses a query to combine the data, but it will not store the combined data and it will not refresh on it's own if you add or change the data.
2. This method combines the data in and Unbound field by making it the Control Source of the Field. This will not save the data to a table but will automatically update.
3. This method uses VBA in the After Update Event Procedures of the 3 fields and will automatically update the data and also save it to a table if required.
The choice is yours.
 

1 more replies
Relevance 72.57%

I want to combine a text field and a date field into one field to use as a reference number. IE 'Mil - 05/11'.

I have got a field with the standard short date format 29/05/2011 (that I have to keep) and I have created a second field with the same date but formatted to a "mm/yy". When I concatenate the Operater Ref field "Mil" to the Date Ref field "05/11" I still get the full date format IE Mil - 29/05/2011.
 

Answer:MS Access Concatenate a date and text field

Jerry-

If you are creating the second field in your table, go to design view and change the Data Type to Text then try your concatenation. I built a mini-table and queried it and this worked for me... hope this works for you!
 

19 more replies
Relevance 72.16%

Hello everyone


Can insert more than 255 character in Text field ? .

Answer:Can i enter more than 255 characters in (TEXT) type in M. Access?

Yes you can use more that 255 characters in a text file.

What version of Access are you using?. I am using Access 2013 & below is a copy from the help files that may help you. In older versions of Access you would use a Memo for long text, but Access 2013 now calls it Long Text.

The Memo data type is now called “Long Text”

In earlier versions of Access, we used the Memo data type to store large amounts of text, and the Text data type to store shorter strings (up to 255 characters). In Access 2013, these two data types have been renamed “Long Text” and “Short Text” respectively, and they have different properties and size limits depending on whether you’re using a desktop database or an Access App. Here are the details:

Text fields in desktop databases (.accdb)

Long Text In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000 characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.

Short Text In .accdb files, the Short Text field works the same as the Text field in earlier versions. It stores up to 255 characters.

4 more replies
Relevance 71.75%

Is there a way in Access to have a report with data like BB900, 10/1/2006 behind a barcode? Then have a form with two columns. The user would scan barcode. The first column would hold the information to the left of the comma, and the second column would hold information to the right of the comma.
 

Answer:Access Database Text Field Seperated By A Comma

6 more replies
Relevance 71.75%

Is it possible to return a field name in a Query so that I can use it in a mail merge field in word.
 

Answer:Return Field Name -Access 2000

9 more replies
Relevance 71.34%

I created a form letter as an Access 2007 report. The only field is [first_name] from a query. The first line reads, "Dear Joe (or whatever [first_name] is). I want a comma after each name. I tried =Trim([first_name] & ","), =Trim([first_name) & "," and every combination I can think of. Every permutation returns Dear #Type!. How can I get Dear followed by the name and a comma? Thanks!
 

Answer:Solved: Access 2007 Trim and field text addition

14 more replies
Relevance 71.34%

Hi,

For a 'Yes/No' data type, my MS Access 2013 does not allow me to change from the default 'check box' to the 'text box' option under lookup field properties - display control. It was originally able to but I think something has happened to it.

The problem is not table or database specific as I have tried other tables and databases. I even reinstalled MS Access to make sure it was not the application's fault. It still exists and I don't know what went wrong.
Could someone please advise?

Thanks a lot.
 

Answer:MS Access 2013 Yes/No Lookup field properties can't select Text box

lycen, welcome to the Forum.
I am not sure how you managed to change it to a text field, as you can't do it in Access 2007, only to other types of "On/Off" type fields
 

3 more replies
Relevance 71.34%

In Access I have a field "Age" which is formatted as text.

I import a txt file from Excel where the Age data contains some ages and some txt such as "Staff".

7
11
Staff
24

etc.

How can I force the ages to have a leading zero so that they appear in sequence in reports?

I know if I format the Age field as Number they appear correctly sorted in reports, but then I can't use text as well in that field.

Thanks for your help,
Ken
 

Answer:Importing txt file into Access text field with leading zeros

It might be simpler to modify the input data from Excel, so they are correct, or perhaps a little bit of vba code might be useful to whip through that field's data to modify those records which have a number to have leading zeros.
 

2 more replies
Relevance 70.93%

Hello,

I'm trying to set up an Access db and am having a small problem.
I have a main form with a subform with "Invoice Number" as a linked field.
When an invoice number is typed into the main 'parent' form, it is automatically entered on the subform. It saves successfully (as a value) to the table behind the subform. Fine.

However, I also have another form (Log) which is opened when a command button is clicked on the main form. I want the same thing to happen with the invoice number as on the subform - i.e. I want the invoice number to appear automatically on this additional Log form, and to save to the Log table when I save the (Log) record.
I can do the first part - by simply referring to the control on the main form, I can display the invoice number on the Log form:
=[Forms]![MainForm]![InvoiceNumber]
, but this doesn't save the invoice number as a value in the Log table.
Can this be done relatively easily?

Obviously the subform works correctly because of the parent-child link, and the Log form doesn't have such a link. Can I create one? Or can I do something else to convert the displayed invoice number into a value that will save?

Cheers
Gram
 

Answer:Access 2000 - save displayed field as value

16 more replies
Relevance 70.93%

I want to remove the house numbers from a street name e.g. 111 Hotspur Road to Hotspur Road. Some of the information will also be like 111a Hotspur Road and other will just have the street name. - Any ideas?Thanks

Answer:Access 2000 - Removing data from a field

Is this an update you want to apply across an entire table in the database or just case-by-case on a form or something?Will there ALWAYS be a number at the start? i.e. what if that fields hasThe Gables, Hotspur Roadin it?Addresses are quite difficult to clean unless you know they are consistent. You can get software/databases to clean against.

3 more replies
Relevance 70.93%

I have a table that has a webpage addy as a hyperlink.
If i want to copy that field and say do a ctrl c
hypelink field
www.mywebsite.com

ctr c:
i get this(textfield)
www.mywebsite.com#http://www.mywebsite.com#

Sometimes a hypelink field won't copy properly or paste properly or import properly, so I just thought i would have both...but can't even manage to get it moved in Access.

thanks
 

Answer:Access 2000 hyperlink field question

I believe this link answers your question:

IDC Files Display Hyperlinks as Text in Web Browser
 

1 more replies
Relevance 70.93%

My employer is kinda likin' my databases so far. Trust me, I'm giving credit where credit is due.

Here we go: I'm creating a database for employee information. (Actually I exported most of the info from an Excel Spreadsheet and that went well.) I'm having trouble conceptualizing the field(s) for an Emergency Contact person(s) of an employee. The problem is, some employees have 2-3 different contacts, sometimes one contact has 2-3 different numbers, numbers can be work, home, cell phone, etc. and I'd like to designate this. We also want to designate the relationship to the employee: spouse, parent, etc.

For example: Jane Doe has (2) emergency contact people. One is her husband, John, who has (3) different numbers (home, work, cell) where he might be reached. She also lists her mother, Everyn Smith, with (2) numbers (home, work) in case we can't reach John. We want all this info available and rather quickly if need be.

I don't want to make this more difficult than it should be. Would another related table for emergency contacts that shows up in a sub-form of the employee listing main form table be appropriate?

Again, I thank you all in advance and appreciate your time helping me solve my many dilemmas.
 

Answer:Access 2000 - Emergency Contact Field

Create another table just for emergency contacts since there is a one-to-many relationship here. In the table just add a filed for the EmployeeID from the employee table and create the relationship. You have the right idea....carry on!!
 

2 more replies
Relevance 70.93%

Hi, I have several Word Docs as OLE items in an Access 2000 table. In the application on a form when you double click the field to start editing the word document for a specific field I would like the AutoExec main subroutine to start. I have created a main subroutine in the Normal.dot file and it does not start. It starts fine when you start word outside of the OLE implementation in the Access form, but not within.

Is there any solution to this?

Thanks in advance for your help.
Scot Maga
magadraw
 

Answer:AutoExec in word from OLE field in Access 2000

7 more replies
Relevance 70.52%

This is for the database:
I am trying to use the tct codes in a combo field on the Form and have a different field backcolor for each one. So I missing something just not sure what. Thanks Alan
 

More replies
Relevance 70.52%

Hey there, long time reader first time poster!

(If you know of a great advanced tutorial on Access, please let me know. I know how to set up the basics, now I'd like to know how the program really runs)

I'm currently working on a form that allows users to search for equipment. The category of the equipment is slectable through a combo box, and the searched text is entered in a text field. The results are displayed in a list box.

What've I've tried is using a 'Find' button to enter this sql query into the RowSource of the list box:

Private Sub Equipment_Find_Click()

Me.Equipment_List.RowSource = "SELECT Equipment.Type, Equipment.Manufacturer, Equipment.Model FROM Equipment WHERE (((Equipment." & strQuote & Me.Equipment_Search_Category.Column(0) & strQuote & ")=" & strQuote & Me.Equipment_Find_Text & strQuote & "))ORDER BY Equipment.Type DESC;"

End Sub

The result i get is a pop up window with a text field. If i re-enter the text in that feild the info pops up nicely. What am I doing wrong, and how do i get rid of that popup?
 

Answer:Access 2003: Search criteria based on combo box and text field

12 more replies
Relevance 70.11%

I'm trying to find out why Access 2000 will auto fill my data entries. I've noticed that when I put a number in a field that the next record will automatically insert the next number in that field. For example, in my Order column, in datasheet view, I enter a 1, the next record in the the Order column will automatically fill with a 2 and so on. Or the pattern will repeat - if I enter a 1 in the Order field, then a 3 in the next Order field, the next Order field will fill with a 5. What is going on? and how do I stop this?
 

Answer:Access 2000 does auto-fill on field data

momish, I can't find how to turn it off either.
If you are using a form in datasheet view then you can convert it to "Continuous" forms mode and that will overcome that problem for you without losing the functionality of the datasheet ease of entry.
 

2 more replies
Relevance 69.7%

I am trying to set up a form with a land map showing sites 1 through to 100, each site is linked to its own record (by means of site number e.g. 001, 002 etc) which has a field for an option box selecting either Available, Pending or Sold. I want to colour code each site on the map by means of an object (either label, graphic etc). Each choice is colour coded, ie OLE001available is green, OLE001pending is yellow and OLE001sold is red. etc for each site. I think I can do this using visible yes or no, i.e. if site 001 is available then OLE001Available is Visible - Yes, while OLE001pending and 0LE001sold are not visible? How do I link each OLE for each colour and each site to the relevant record and field? so that the correct colours are displayed on the form map.
 

Answer:access 2000 linking object to specific record field

14 more replies
Relevance 68.88%

Okay, I've significantly simplified my database that I was working on (see this thread for that). I thought this one would run like a charm but when I try to enter data using frmCompEntry I get the following error when tabbing out of the URL field:

Index or primary key cannot contain a Null value.

I don't know where the Null is coming from though. Could somebody who knows more about Access than me (not hard) have a look at this and tell me what's going on?

Thanks,

chris.
 

Answer:Solved: Access 2000 Null primary/indexed field error

9 more replies
Relevance 68.06%

I support a software program that has a proprietary menu item when you right-click a calculated field. It has been this way for 10-15years and has worked in WinXP through Win10 with never an issue. This past week I had 3 different customers tell me that when they right-click one of these fields to access what is normally the Cut/Copy/Paste/ menu that also includes our menu item, they are now getting the Windows default cut/copy/paste/Right to Left Reading order/Show Unicode control characters/ etc menu. The only thing I can think of that they all have in common besides these are all Window 10 64bit pc's, is that they all have one update to Adobe Acrobat (17.012.20098).
I was able to resolve for a moment on two of these workstations by having the user go into Language/Advanced settings and actually selected "English (Unites States) from the "Override for Windows display language" even though that settings is implied by the "recommended". But after the pc was turned off over night and back to it the next day, the problem is back and that setting is still selected. All language and regional settings on all the pc's are defaulted to English/Unites States. I do not know what other avenue to go in. Could something hae been switched on or off in Windows (by this Adobe update perhaps?) that would make the context text menu switch to Windows text default right-click menu?

Any help is appreciated!
 

More replies
Relevance 68.06%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 63.14%

I had the type as i swipe function enabled on my keyboard and suddenly it stopped entering the words i was trying to type into the field mid text. The line would appear and track my finger on the keyboard and the letters would go from capital to lowercase as they do at the beginning of a sentence if that setting is enabled but when i finished swiping the word did not appear in the space above and the keyboard would change back to uppercase. I disabled the swipe feature and that made it so i could type out one word normally but as soon as i hit space i would have the same issue of no words or characters appearing in the space above. I did a soft reset with the swipe function off and now i can type normally but the swipe functionality doesn't work at all and turning it back on forces me to turn it back off and do a soft reset again to get typing back. this happens in every app i tested it in.

Answer:Characters fail to enter into the field after they are typed

What device are you using?

2 more replies
Relevance 63.14%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.
 

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 63.14%

Hi all, 
I have a matter about placeholder in html. The placeholder will be disappeared when focus
on text filed with IE. But I want to keep hint text of placeholder when do that. Could you give me any suggestion?

More replies
Relevance 62.73%

Hi,
We have an Access2000 database running on Windows XP.
I would like to add a command button to allow users to mark a block of text in a textbox (not the whole contents of the textbox) and paste it into another texbox. During the process I want to be able to add some standard text (hard coded) to the copied text before the paste, so just using CtrlC/CtrlV doesn't do what I want.
Most similar posts I've looked at involve answers which use the clipboard, e.g. Clipboard.SetText...., but when I try using similar commands I always get an error. Any advice gratefully received.
 

Answer:Access 2000 copy selected text

8 more replies
Relevance 62.32%

Hello, I have been using BitLocker for a long time now and in conjunction with Windows 10 for 3 months and today something weird happened. When I tried to insert my password at boot, when I pressed the Shift key in combination with any other key, it inserted tens of characters at once. Valid with any character I press while Shift is also pressed. I tried a different keyboard, same result. I removed Bitlocker and reinstalled it, same result. Reboots, etc. I tried it all.

Now the only way to input the password is to press Insert so I can see the characters, press CapsLock for the capital letters and delete all the additional 30+ characters that appear when shift is pressed.
Has anyone come across such a thing? Is there a fix to it?
Thanks,
tzuik

Answer:Bitlocker inputs multiple characters in the password field

Same here... it started a few days ago after a win 10 update... i bet MS pushed an updated to bitlocker that causes it... no solution found by me so far except the one you have with the insert key... (and to get things more interesting i have connected my HDMI to my TV and the DP cable to the monitor and the Nvidia bios selects the hdmi output on boot so i have to switch the tv on to see the error and remove the extra characters) i have tried with 2 different keyboards and the issue is still there. if you find a solution please share it

6 more replies
Relevance 62.32%

Hello, I have been using BitLocker for a long time now and in conjunction with Windows 10 for 3 months and today something weird happened. When I tried to insert my password at boot, when I pressed the Shift key in combination with any other key, it inserted tens of characters at once. Valid with any character I press while Shift is also pressed. I tried a different keyboard, same result. I removed Bitlocker and reinstalled it, same result. Reboots, etc. I tried it all.

Now the only way to input the password is to press Insert so I can see the characters, press CapsLock for the capital letters and delete all the additional 30+ characters that appear when shift is pressed.
Has anyone come across such a thing? Is there a fix to it?
Thanks,
tzuik

Answer:Bitlocker inputs multiple characters in the password field

Same here... it started a few days ago after a win 10 update... i bet MS pushed an updated to bitlocker that causes it... no solution found by me so far except the one you have with the insert key... (and to get things more interesting i have connected my HDMI to my TV and the DP cable to the monitor and the Nvidia bios selects the hdmi output on boot so i have to switch the tv on to see the error and remove the extra characters) i have tried with 2 different keyboards and the issue is still there. if you find a solution please share it

8 more replies
Relevance 62.32%

I have a text box [Text45] being used in a form as a general number with 2 decimals. I have another text box I am calculating into that is 1 decimal.

the formula I am using is =IIf(([Text45]*0.8)>=20,20,Int([Text45]*0.8)) because there is a 20 max on the calculation.

When 24.5 is put into text box 45 the new text box should say 19.6 but I cannot get it to calculate to the .6 it rounds down to 19 even.

This is extrememly frustrating. Anyone have a suggestion? There should be an easy way to lock in on decimal integrity.
 

Answer:Solved: Access 2000 Decimal Integrity in a Text Box

In your formula you are using Int() which is Whole number, so there is never any decimal values to display.
 

1 more replies
Relevance 62.32%

In Access 2000, how do I set the "Criteria" in "Design View" of a query so that it will exlude certain text from the query results.

For example, lets say I was running a query that pulled data from the 12 months of the year. However, I didn't want "February" to be included in the results.
 

Answer:Access 2000: Exclude Data (Text) From A Query

You can use a Not Like "February" in the criteria and that should work.
 

1 more replies
Relevance 62.32%

I am looking to round down a currency box and dropping the cents to a whole dollar amount that cannot exceed $362.00 Dollars.

The formula in the box titled [DC1] is - =([Q1]*(0.041))+([6]*6)

I need to drop the cents and if the dollar amount is over $362.00 round down to that.

In a similar box I need to round down a percent to the nearest .5 but not to exceed 26.0

The box titile is [WKENTT1] and the formula to get the percent is -
=[SBPW1]/[RDWBA2].

Also, I would like to compare the currency box [SERPW] with [WBA7]
and if [SERPW] is greater than [WBA7] enter the amount from [EMPCHG] into a box titled [SEPEMPCHG1].

Any ideas, tips, or sample formulas to help me out? Thanks.
 

Answer:Solved: Access 2000 Text Box Formula Questions

16 more replies
Relevance 61.91%

Just when you think you've seen it all, recently all the Xerox Phasers we have on the network, are going offline. When looking deeper into it, we found that there are strange characters such as what looks like a cross or weird looking plus sign showing up in the field. Does anyone have any experience with this and why it's happening? We can remove the characters, but they randomly pop up again.

More replies
Relevance 61.91%

So I've recently learned how to use Word templates and want to convert many of my work documents to same. I have also learned how to change the file title in the template's properties in order to keep the naming convention standardized from file to file. The problem is that my file naming system makes use of dashes in order to make names more readable. Unfortunately dashes, as well as periods and brackets (both of which I tried as substitutions) both seem to "cut off" the file name. If I try and use the title "label - 5161 Avery - client addresses", for example, using "save as" doesn't bring it up as "label - 5161 Avery - client addresses.docx" - it just brings it up as "label.docx". Is there any separator mark that works in the Word filename or am I going to have to live with less readable filenames if I want to use templates?
 

Answer:Using special characters in Word title field for save names

14 more replies
Relevance 61.91%

Just when you think you've seen it all, recently all the Xerox Phasers we have on the network, are going offline. When looking deeper into it, we found that there are strange characters such as what looks like a cross or weird looking plus sign showing up in the field. Does anyone have any experience with this and why it's happening? We can remove the characters, but they randomly pop up again.

More replies
Relevance 58.63%

I am working on a database that stores genus, species, and variety I want to sort the data with genus, then species, then variety.

Now the tricky part. Sometimes there is no species. When this is the case, I want the database to sort that record off of variety.

I have though of a way to do this, but need help with the code.

If I make a species2 field, I could create an expression that would look at the species field. If the species field is empty, it could copy the data from variety. If it is not empty, then copy the data in the species field.

Once the species2 field has the updated data, I could then do a sort

genus, species2, variety

The report would have genus, species and variety showing and species2 would be checked off to not show in the report.

I am using Microsoft Access 2000.

Any help would greatly be appreciated.
 

Answer:Access - if field is blank, copy field A, if not copy field B

You should not actually need another field to do this, just another column in your report's Query. Something like this as a Field header :-

dummySpecies: iif(isnull([species]), [genus], [species])

this should provide a column with the species in if it there and the genus if it is not, which you can use in place of your actual species field in the report for sorting.
 

1 more replies
Relevance 56.58%

How do I get Firefox to remember something typed into a specific field? This text box pops up after I select 'Merchant Accept Liability' from the dropdown menu. I have to type 'We accept liability' into the text box at least 200 times a day. If there was some way for Firefox to remember this, it'd be extremely convenient. Attached screenshot.

Answer:Remembering a text field

One of the best rated form fillers is Roboform. It works in Firefox and IE.

Quote:




Quality Artificial Intelligence
RoboForm is really smart in filling in forms; it is the most precise form filler on the market. We use Artificial Intelligence techniques to achieve this kind of precision and we test RoboForm thoroughly.

Selective Form Filling
You can ask RoboForm to fill just a part of your form, rather than the complete form. Simply select (highlight) the fields that you want RoboForm to fill and click any form filling button -- only the selected fields will be filled.




You could also try one of these Firefox addons:

Fireform

iMacros

Quote:




Automate Firefox. Record and replay repetitious work. If you love the Firefox web browser, but are tired of repetitive tasks like visiting the same sites every days, filling out forms, and remembering passwords, then iMacros for Firefox is the solution you?ve been dreaming of! Whatever you do with Firefox, iMacros can automate it.

3 more replies
Relevance 56.58%
Question: Text Field Issues

While the main reason for this help request is to help me fix the text field problem Im having, there are a couple other problems as well.

It has become an ongoing problem, no clue what causes it. In certain games, so far only Mabinogi and Test Drive Unlimited, when I go to type something in a text field, my computer pauses, and people talking in Ventrilo repeat themselves over and over for a couple seconds. The same thing happens when I exit a text field in said games. No one else I have talked to has this issue, and I am fairly certain they have slower computers than me, so no clue what the issue is.

The other problem is my graphics card. I have an ATI Radeon x800 card, and when I am playing games, I get errors when it does not even seem to be taking up much memory. I was playing Test Drive Unlimited which I just got today, and I was getting a report error window for ccc.exe about every minute in game. If I ignored it, I could keep going, but eventually another error window popped up saying the same thing, so I shut the game down. I meet the minimum requirements, but I have no clue why its doing this. My computer has a history of overheating, but I don't know if its due to that.

Also, is there a program I can use to monitor the heat in my computer? I'd like to know if that is truly the problem here, as I have been told that my card could be damaged by now if it is overheating.

Answer:Text Field Issues

First heer is a link to the site that has a monitor for CPU and Heat along with a few other things. It is called MBM and about the 11th item down. It is Freeware.I would also suggest getting any Driver updates needed. I do not know what system you have but you can go to the manufacturers site and retrieve them from there. Do these two things and then try the game again so we know if it is a heat problem which it sounds likehttp://www.freeware-guide.com/dir/util/optdiag2.htmlPost back and let us knowThank you Jitaa

12 more replies
Relevance 56.58%

when I print to Hewlett-Packard 800 series, instead of printing the page number (or other information) I get...
{page} or whatever the instruction is for the field. In print preview, it shows the number, but then when printed, I get the instruction information.
 

Answer:field text in Office 97

Please let us know which program next time.

If it's Word (I suspect), go to Tools-Options-Print tab. Remove "field codes".
 

3 more replies
Relevance 56.17%

Hi all, my wife is Japanese and we are in the market to buy a new desktop PC.
My wife wants a Japanese keyboard, and wants to be able to email her friends back in Japan with Japanese characters text.

How do we do this, do we get a Japanese version of Vista, or Japanese version of Microsoft words.

Anyone be able to offer us some advice ?

Thanks kindly,

Tony
 

More replies
Relevance 56.17%

I subscribe to "Best of PC World" newsletter, which is sent out via e-mail. On virtually every e-mail, I see characters that seem to indicate that my system can't read what's in the text. Example: "Androida€™s next update will reportedly fix Lollipopa€™s memory leak."

This occurs on both my PC and my laptop (the OS in both is Win 7 Home Premium), and on my wife's VERY old XP-SP3 laptop. The 'a€™' appears to be a substitution for a simple apostrophe ('). Good Lord; all that for an apostrophe??

How can I fix this issue?
 

Answer:Strange characters in the text

16 more replies
Relevance 56.17%

Hello.  This question may have already been posted in the past, but having searched for it, I found no results.For years now I've noticed (in emails mainly) that what was originally accurate text (I'm sure), has some characters replaced with a character-sized square.  Is this due to a simple font issue?  Or perhaps some type of encoding difference between computers?  When I tried to paste an example here, the little square was gone and was replaced with a space.I'm using Windows XP Pro SP2.  Thanks in advance for any help.

Answer:Square Characters in Text

What E-mail service are you using?What E-mail client are you using?Are these E-mails in HTML?

8 more replies
Relevance 55.76%

when i open yahoo mail ,nd go for composing , the text area does not appear nd so i could not able to wright mails to my friends.the page displays also done with error. pls help me out of this problem

More replies
Relevance 55.76%

Where is the setting to change the color of text fields? The color options in the options menues just change or force colors on the webpages themselves. Im looking to just change the color of the address/google bar, and any text fields that happen to appear on a webpage. Right now they are all a dark ugly grey, where if I open the same page in IE everything is properly colored to the pages defaults or to my light colored xp theme.
 

More replies
Relevance 55.76%

I have a table consisting of 8 columns by 26 rows. In each cell, I'm adding a Text Form Field. Is there anyway, besides doing it cell by cell, where I can just copy a row, then paste the same Text Form Field with text length maximums in the other 25 rows?
 

Answer:Word - Text Form Field

Sure, Brian.
Create first row.
In Print Layout view, take your mouse pointer to the left of the left-most cell in the row, and it should turn into a 1:00 pointing arrow. Click to select the whole row, then Ctrl+C to copy. Place your cursor in front of the paragraph return just below the table OR in the left-most cell of the row that you want a new row above, and hit Paste.
 

3 more replies
Relevance 55.76%

Hello All.
Public Sub AutoExec()
MsgBox ("The Word Startup Folder is: " _
& vbCrLf & Word.Application.StartupPath)
End Sub
First, I want to again thank everyone who helped me with my first question: Text Form Field in Word 2003.

My next question is: Is there a way to automatically tab to the next form field?

End Time
00:01
I would like to key in the hour (00), skip over the colon, key in the minutes (01) and have Word or VBA tab to the next field.

Can this be done? Any ideas?
TIA
 

More replies
Relevance 55.76%

From a specific text value in one field I need to count that field in multiple other fields. ie: in one column, for each text field marked Trip1, I need to add to a count in a Compartment1 field, a Compartment2 field, and a Compartment3 field.

Answer:How to count text values in another field

Perhaps we could be of some help if we knew what application you are talking about. Even if we know the application, I'm not sure there is enough information in your post for us to answer.Perhaps you could add a few details regarding what it is you are trying to count. Keep in mind that we can't see your computer from where we are sitting, so the more details you provide, the better.Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 55.76%

Ok, first, I'm running Windows XP Pro SP2 on an HP Pavilion 8760c. It originally came with Windows 98, but the previous owner upgraded it to the XP sometime before giving the computer to me. I do NOT have any disks, neither the original system disks nor any restore disks, nor does there seem to be any restore partition on the hard drive.

First problem is -- for some reason when I try to type into any text fields in any windows based programs, the cursor goes into hyperblink mode, won't click into any text field, and won't let me type in any of them. I first noticed the problem when I tried to use internet explorer, I went to Google like normal and while it will let me type in the address bar at the top, it won't type into the Google search field. I have since found out it is NOT IE specific, but it won't let me type into the windows help search field, or the field where you enter a name for a restore point when manually setting it, or in the captcha box on a game program I use or pretty much anything windows based. I downloaded Firefox and I can type in Firefox with no problems, which is fine for searching the web, but does not fix the problem.

Second, with the system restore... this computer used to work fine. I used it occasionally at my old house, then we moved and the computer sat idle for about nine months, and I just hooked it back up last week. When I did I found problems with the sound as well as the problem with the text fields I mentione... Read more

More replies
Relevance 55.76%

When creating, forwarding, or replying an email; the text field does not open automatically. It must be expanded manually. What is my problem? Thank you.
 

Answer:Outlook Express Text field

Have you tried this.

make Windows Mail or Outlook Express open email messages to windows that make use of all the available screen space automatically:

Open any email in its own window by double-clicking it in its folder.
Make sure the window is not maximized.
Move the window so that its top left corner coincides with the top left corner of your screen.
Grab the handle in the window's bottom right corner with the mouse and drag it to the bottom right corner of the screen.
Close the message window
 

1 more replies
Relevance 55.76%

Recently there's been an annoying little animation pop up whenever I click something. I can't really explain it, but it's similar to the blinking | you see when typing in text fields. Everything I click on something it shows up. It's really annoying. It even happens when I click a picture, except it appears as a HUGE blinking bar. Can someone help?

Answer:Not sure.. text field-like highlights when I click anything

A picture...is sometime worth a thousand words, can you post a screenshot?

Louis

7 more replies
Relevance 55.76%

Hello all.I am looking for a text editor that I can throw my users into that I can tell it to wrap all lines to 78 characters during entry.It's doesn't have to be fancy, Notepad is working right now, but when the users exit the document I truncate the lines to 78 characters to store them in the application.Any help would be appreciated.Ken

Answer:Is there a text editor out there that can be restricted to 78 characters?

Not that I'm aware of, but if you are familiar with vb you could always make a text program that limits the user to 78 characters and allows them to save to a txt file.

4 more replies
Relevance 55.76%

I am running XP Pro on a Thinkpad R50 and after being attacked by some kind of malware or virus, which disabled taskmgr, all drives, start menu, etc., essentially closing off all normal avenues for fixing the problem, I have arrived at the following point, where I am now helpless:

I can boot into XP, although not into Safe Mode, and when I do, all text is displayed using a special character set. The only area where normal text is displayed is in the C: Prompt and in TweakUI. So, while I have run Spybot S&D and installed Webroot Spy Sweeper, I cannot perform a scan, since I cannot read the menu selections(not sure this would help anyway).

I have read some posts about copying the Fonts Folder contents from another computer, which I tried using a thumb drive and the C: Prompt, but I received an "Access Denied" message for several of the files. I assume this is because they are in use.

I will say that, I would like to simply wipe the drive and do a complete install, but the IBM Access function which allows me to restore the computer to its original state does not come up when I press my IBM Access button and, of course, I do not have install disks since this machine is supposed to have the original contents partitioned away for these situations.

I think if I can repair this font problem and establish a connection with the Lenovo site, I should be able to restore the machine to original.

Any thoughts?

Answer:All Text Displaying As Special Characters

http://www.mydigitallife.info/2006/01/18/i...ad-recovery-cd/Louis

4 more replies
Relevance 55.76%

I have posted help on this topic before, but I can see that my ability to describe what my problem has been was not very successful.Over the past 20 years I have had this problem almost a dozen times and in between the instances that this problem occurs, I have always forgotten how to solve this problem other than to start a new document.I don't know how at the end of the document that I am currently editing has changed, but for some reason when I am editing text, the document will allow me to add additional text at the cost of loosing one character ahead of where I am editing.This is a problem as I do not want to re type the sentence/paragraph.How can I resolve this and is there a name for this so that if I ever have a problem I might be able to remember what this edit glitch is called?

Answer:Editing text without erasing characters in OO

Possibly Insert Mode vs Overwrite Mode?I don't use OO so can't help much more.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 55.76%

Word shows the number of words in the text on the state bar at the bottom. Can it be adjusted to show the number of characters? Thank you very much in advance.

Answer:Number of characters in Word text.

I don't know if you can change the word count to character count in the Status Bar, but see if this helps.

Select the text you want the character count for (Select All for the entire doc).
Click on the Word Count in the Status Bar.

It pops up this info in Word 2010:

4 more replies
Relevance 55.76%

Text appering in windows 7 as square blocks. It seems to pick a few programs but ususally it happens when I am given multiple choices to choose from when I am trying to work thru any given program. Kinda like the fonts go for a hiatus when a multiple choice quizz comes in biology class. Just did a fresh install of Win7 and would like to salvage this O.S this time around. Thanks guys

Answer:Text appear in W7 as square block characters

Sounds like a missing or corrupted system font problem.First try the System File Checker:Start >> RunType SFC /SCANNOWClick OK.If that doesn't fix it, boot from Win7 DVD and do a repair install:http://tech.gaeatimes.com/index.php...

2 more replies
Relevance 55.76%

I have text that is typed between () to be blue and if text that is typed between {} to be purple and all other text would be black in a range of cells.I'm sure it's done under conditional formatinng but I don't know how.

Answer:How do I change text color between certain characters

A few assumptions were made here:1 - You used the phrase "range of cells". I assumed that the range is Column A. I'm probably wrong, but as written, that is where the code will look for the data.2 - There are mulitple shades of blues and purples that can be chosen. I chose ColorIndex 5 as the Blue and ColorIndex 29 as the Purple. I can show you a quick way to determine the ColorIndex numbers for some other colors if you need me to.3 - I assume that you do not have any instances of a set of parentheses contained within a set of braces or vice-versus. If you do, you may see inconsistant results. Let me know if that is an issue.With that said, I belive that this code will accomplish your goal.
Option Explicit

Sub ColorMyWords()
Dim lastRw, nxtRw, nxtChr, nxtPara, nxtBrac
Dim paraCnt, bracCnt, openPara, closePara, openBrac, closeBrac

'Determine last Row with data in Column A
lastRw = Range("A" & Rows.Count).End(xlUp).Row

'Reset all text to black - Uncomment to use
'Range("A1:A" & lastRw).Font.ColorIndex = xlAutomatic

'Loop through each cell in Column A
For nxtRw = 1 To lastRw

'Determine number of Open Parenthesis and Open Braces in cell
For nxtChr = 1 To Len(Range("A" & nxtRw))
If Mid(Range("A" & nxtRw), nxtChr, 1) = "(" Then paraCnt = paraCnt + 1
If Mid(Range("A" & nxtRw), nxtChr, 1) = "{" Then bracCnt = bracCnt + 1
Next

'Find each set of Parentheses and color contained text Blue (5)
For nxtPara = 1 To paraCnt
openPara = InStr(openPara + ... Read more

10 more replies
Relevance 55.76%

see this threadclick herecan someone post a reply to this thread with about 220 characters in it; I need to be able to judge how much text I am "allowed" for the form sections; and tell me at the end of the reply how many characters are there.....please....I am desparing with this and will have to do it manually

Answer:length of message-how much text characters

220 characters! Aaaaaaaaaaaaa bbbbbbbbbbbbbbbbbb cccccccccccccccc dddddddddddddddd eeeeeeeeeeeeeeeee fffffffffffffffffffff gggggggggggggggggg hhhhhhhhhhhhh iiiiiiiiiiiiiiiiiiiiiiii jjjjjjjjjjjjjjjjjjjjj kkkkkkkkkkkkk llllllllllllllll

5 more replies
Relevance 55.35%

I was wondering if the following is possible:

I am using Microsoft Excel currently (on a Windows XP machine) and I have three columns, one is text (name) and the other two columns are MM/DD format (start date) (finish date).

Can I make something that will move the entire row to a new sheet/tab, after the second date is added?

Ex:
Name Start Date Finish Date
ABC Company 07/11/07 07/15/07
BCF Company 07/15/07 _______

Any guidance with this problem would be greatly appreciated.

Thanks in Advance,
Dom
 

Answer:Solved: Moving text after completing a field

15 more replies
Relevance 55.35%

I am looking to create a MS Word 2003 document for work that has a text field that has a character limit to it and I can't seem to find anything in Word that does that. I know it is possible, as we have various documents corporate HQ has us use that has text fields with character limits on them. Does anyone know where I can find this in Word 2003?

Thanks
 

Answer:Text field w/character limit in MS Word 03

7 more replies
Relevance 55.35%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.
TIA
 

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 55.35%

I create demo files for testing. The way I have it now I have the file laid out with two merge fields. These link back to another docucment where I input a month's worth of dates. The first being Date created and the second column is File Load date.

Once this DateInput doc is updated I go through each record in the merge document and save each one as the DateCreated number as the file name and as a txt file.

Any ideas on how to automate this? I tried using Access to fill in the merge and I was able to have it input today and tomorrow dates using command buttons and these subs

Private Sub cmdToday_Click()
txtFrom = Date
txtTo = DateAdd("d", -1, Date)
End Sub

Private Sub cmdTomorrow_Click()
txtFrom = DateAdd("d", 1, Date)
txtTo = Date
End Sub

But that only gets me two days, I need to see about automating the whole month.

Any help would be appreciated. Thanks
 

Answer:Whole month of text files with merge field

Any ideas on how to do this? I have tried everything that I know. I tried making a macro in Word, but could not get that to work either.
 

1 more replies
Relevance 55.35%

i have a access 2007 database and have to print a lot of reports for the client. however when you have calculated field (i am counting the amount of weeks) on the form - and you then put a textbox on the form - which is a memo field in the table - that pulls information from the database(memo field) some of the data gets cut off.
i have set the 'can grow' and 'can shrink' properties to yes for the field.

once you delete the calculated field from the query - the text stretches and all the memo field text shows correctly.
is there away around this?
 

Answer:calculated field on reports causes text to disappear

Is the calculated field in the Header, Detail or Footer section?
 

3 more replies
Relevance 55.35%

I have completed a 4 page form in LiveCycle, however, I cannot figure out one important thing. I would like to have a text field repeated on everypage. A job number for example that someone filling out the form would enter, I would like that job number to appear at the top of every page.

How do I do this? Is there an easy "click" I am missing?
 

More replies
Relevance 55.35%

Hi

i want to update the text box based on the combo box selection based on the user form in excel. I am using the below code but the problem is combo box value is hidden once i selected but text box value is coming.
'Private Sub ComboBox1_Change()
'ComboBox1.Value = Worksheets("OptionPage").Range("Af28").Value
'TextBox7.Value = Worksheets("OptionPage").Range("Ag28").Value
'End Sub

I am assigning the value of combo box into af28 and from there i am doing a vlookup in ag28 to get a value. In the combo box i have row source of particular range in the sheet.

Please help.....
 

Answer:Solved: Combo box text field updation

Hi, could you just post a sample with dummy data, it makes it easer to 'see' what you need / want.
 

3 more replies
Relevance 55.35%

I am trying to create a worksheet to help me track my business.  In it I need a text field where  I can enter daily information. Is there some type of a text box or table that I can insert and use that will not increase the size of the worksheet when I update?  Thanks, lindee

More replies
Relevance 54.94%

I still can't figure out this Windows 8 search function ...

I have a bunch of text files and I need to search for the following string for example within the files:

now()

Can anyone tell me what I need to do to search for this string?

It seems like Windows 8 ignores just about all non-alphanumeric characters when searching.

If I can't search within files for a simple string like the above I'm screwed!

Answer:How to search within text files for special characters?

7 more replies
Relevance 54.94%

When I am typing I have text characters turn black or whole lines of text turn black. This happens on all sorts of websites and occasionally within programs themselves. I also have issues where text disappears in Browser tabs.  I have been trying to figure exactly the cause of this, but I am not having any luck. I notice this with both Firefox and Chrome. I am attaching a screen grab for reference and any system update have been completed.   Thank youKevin

More replies
Relevance 54.94%

I don't know if this is the right forum, but...
This is for a school assignment. I need to find out the total number of characters plus carriage return (or enter) in a text document. This is easy, if I just copy and paste it into Word and look at the word count. It's number of characters with spaces + number of lines - 1.
Next I need to find number of unique characters including carriage return (or enter) in the text document. It is a very long text, 167,121 characters. I'm not gonna count them.

I was wondering if there was a free computer program that did that. I'm using a mac.
 

Answer:Need to find number of unique characters in a text

I think you need to do your own homework.

Closing thread.
 

1 more replies
Relevance 54.94%

I have forgotten the simple procedure that is used to embed special characters in a text message. It involves using the backslash followed by the three digit representation of the ASCII character. Perhaps the Esc key is also involved, but I don't remember.

Can anyone advise what the procedure is?

------------------
R. J. Emery
 

Answer:Embedding Special Characters in a Text Message

Hold the "alt" key and type the three digit number. The number for each character can be found by going to START, ACCESSORIES, CHARACTER MAP. Click on the character you want and the Alt+XXX shows at the bottom of the window.

In Word you can also go to INSERT, SYMBOL and make your selection.
 

1 more replies
Relevance 54.94%

Please help !! I copied a text file (e.g. sample.txt) to a USB drive and removed it from my laptop hard drive. A couple of days later, I tried to open sample.txt from the USB drive using Notepad. The size of the file and the date is the same, but the file only has spaces! All the text is gone. Is there any hope of recovery? I copied hundreds of files to the USB stick, but this behavior of disappearing txt happened with only about 4 files. I cannot afford to lose the contents, so any help is appreciated.Thanks.- Silver

Answer:Text file characters got replaced with spaces

You know Flash drive will fail after a certain number of writes (Around 10000). They are temporary like floppies. Sounds like yours has reached the end of its life.http://en.wikipedia.org/wiki/USB_fl...To get the file back go into your Recycle Bin and undelete it.

4 more replies
Relevance 54.94%

When typing in any Microsoft program, unwanted characters are being inserted, usually after I've typed a character and then moved the cursor to another position. Mostly what I'm seeing are the two characters b4 or b6. I can't make heads or tails of it. Has anyone seen this, or have a solution?

Answer:Unwanted characters being inserted in typed text

I realize these aren't the characters you are seeing, but does sound like formatting. See if these few quick fixes help:

Getting strange ? characters in MS Word: how to remove them

1 more replies
Relevance 54.94%

friend has got a problem with his pc, he thinks its a virus, but not sure. in windows, all text has changed to strange characters, ie boxes, x's and different shapes, theres no proper text and when you type in internet explorer, in comes up as this strange text as well, any ideas?

Answer:windows prob, boxes instead of text/characters

It sounds very much like a virus, try downloading A Squared and all updates, copy the program to a CD and run a2free.exe.this will run an antivirus program from the CD drive, which may remove the virus (if one (or more) exist).Unfortunatly it may be too late and the damage may be done already.Let us know how you get on.Terry

3 more replies
Relevance 54.94%

Hi

I got an email and that email was composed in English but it appears in some Chinese type of characters in my outlook 2010. Why is it so?
It is only with this email. I cannot ask the sender to resend it.

It's an exchange server email system in our environment. I am not sure about the sender email system.

Thanks
My os is updated with all patches also i am using FEP antivirus.

More replies
Relevance 54.94%

I have this problem which occurred this past few days. I don't recall changing any character encoding settings.

Below are sample pictures of the unknown characters.

When you copy these characters and paste it another field, it will be normal english again.

Answer:[SOLVED] Unknown Characters in Some Text Fields

Hi,

Can you check your character settings to make sure that you are set to Times New Roman. Also are you getting re-directed to different sites if you go to google?

Cheers!

6 more replies
Relevance 54.94%

Help! My laptop is going crazy! Whenever I click on a text box to type something characters automatically are entered, messing up my words and then they just keep typing themselves. Also the scroll, fn button keeps turning itself on without me touching it.

Obviously, I am not typing this post from that computer - or it would look like this

H-el--***p*******************************************!!!!!!******************************************

I have run Norton and updated Norton and it does not detect anything.

Is this a virus? How do I get rid of it??

Thanks in advance to any info anyone can give me.

Answer:Characters Are Typing Themseles Into Every Text Window I Use!

Hello,

Is it just one or two keys that are being repeated? if so, there is possibly something sticking them down.
Do you have a replacement keyboard to test?

4 more replies
Relevance 54.94%

Similar problem to a previous post:
Parsing text log messages that differ on the last character
Hi
I'm sure this is a failing in my grasp of regex but testing with the .NET Regular Expression Tester isn't getting me anywhere.
I want to differentiate text log lines based on the last set of characters. Suppose my log file looks like this -
2016-08-01 06:22:09 SYNC: Set board to 1 second pulse
2016-08-01 06:27:01 SYNC: Sent a time at message with: Mon Aug 01 09:27:05 2016
Based on the OPN Configuration Guide for Text Log Adapter v2, I think my parser should look something like below; I have removed references to other "categories" of messages, leaving only the "SYNC" type.
message SyncEventHdr with
    EntryInfo { Tag = "SYNC:", Regex = @"\sSYNC:\s" } : EventHeader
{
    string Category = "SYNC";
    string Msg = "";
    string DTText = "";
}
message SyncEventNoTime with
    EntryInfo { Regex = @"\sSYNC:\s(?<Msg>.*)",  Priority = 2 } : SyncEventHdr
{
}
message SyncEventWithTime with
    EntryInfo { Regex = @"\sSYNC:\s(?<Msg>.*?)\s(?<DTText>\w{3}\s\w{3}\s\d{2}\s[:\d]{8}\s\w{4})",  Priority = 1 } : SyncEventHdr
{
}

Its ok when I use regex tester to check for both Regex's, but running in MA, only the second inherited message type, SyncEventWithTime i... Read more

More replies
Relevance 54.94%

I thought I read somewhere that it was possible to do a search on a reserved character by putting "" around it. I made the mistake of annotating some appended text fields with "**" (without the quotes) so I would know which records had been added. At some point, I want to remove those two asterisks. . . but, of course, I suddenly realized that Access recognizes an "*" as a wild card meaning something/anything, not the "*" character. So a search using Like "***" or "*'**'" either finds nothing or finds every record with anything in the field.

So the question is, is there a way to search for a literal "**" in Access? OBP. . . are you home today?
 

Answer:Solved: Finding reserved character in text field

16 more replies
Relevance 54.94%

I'm trying to create a word doc with text form fields. I have them in the doc but I want them to remain the in the same location after I type in each box. Currently when I type enough characters in the box the next text form box moves to the next tab location. How can I make each box "freeze" where it is before I start typing in it? Any Suggestions?
 

Answer:Word 2007 - Text Form Field Help Needed

Embed the form field inside a frame. You can then set the frames border so that it is invisible so that it can't be seen.

Regards,
Rollin
 

1 more replies
Relevance 54.94%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?
 

More replies
Relevance 54.94%

I was in settings today and It gave me a message telling me I had to reset my settings because something or another was corrupt. I did so and most stuff works fine (Had to sign back into a bunch of stuff) but I do have one problem. Text fields no longer seem able to remember anything I've put into them. For example when trying to sign in here I usually just click the username box, "Bad-People" comes up and I click it to enter it automatically. But "Bad-People" doesn't come up anymore.
 
I figured resetting things just erased the history. That would have been fine but it also doesn't remember anything I enter new. So if I signed in here, then signed out, and then tried to sign in again "Bad-People" STILL wouldn't show up. This is a feature I use A LOT on a number of sites but it no longer works on any site I've tried. 
 
Vista Home Basic
Chrome Version 43.0.2357.81 dev-m

More replies
Relevance 54.94%

When I try to type in my password in the Windows start up screen spurious characters are automatically generated in the input field preventing me from inputting any password. If I do get into the system this effect happens in all accessed text fields. This has rendered my computer useless any suggestion of what the cause may be and how can it be fixed?

Thanks

Answer:Windows 7 text field spurious character generation

Hello Emmedin and welcome to the Forums,

Could you please provide us with a screenshot from the problem? How to upload screenshots and files at SevenForums.
What anti virus are you currently using? Please run a full scan and report back anything found.
Have you made any recent changes to your system (Installed new software and such)?
Please also fill in your system specs by following this tutorial.
Good luck and keep us posted,
Nommy

1 more replies
Relevance 54.94%

Hi
Can anyone help me with this following issue?
I don't really know how I should write the hole thing (receiving errors).

Here is the link
http://www.vbforums.com/showthread.php?t=559252

Thanks in advance

PS: VBA 6.3 and Outlook 2003
BR
/Groom
 

More replies
Relevance 54.94%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?

Answer:Word 2007 dynamically updated text field

See Word Variables etc. Editor which will allow you to easily map content controls to achieve what you want to do.

1 more replies
Relevance 54.94%

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.
 

Answer:Solved: ACESS: import excel field as text

7 more replies
Relevance 54.94%

As I stated in my previous post, I'm creating a survey to send out in Word 2003 using text form fields and check box form fields. When typing comments in the text form fields, if the comments go above a certain word count, it is impossible to see what you are typing.

As it appears there is no way to make these text form fields scrollable, it is possible to make the text form field expandable when typing in it?
 

More replies
Relevance 54.53%

Don't know if anyone will know how to do this, I know there is a way but can't remember how to do it. I need to be able to type in a phrase, and have another phrase above it (like superscripted) but on that same line right above the main phrase. Any ideas?

I'm using Word 2000 and Window's IME to type my Japanese papers and I need to be able to put the pronunciation for some of the Kanji above the Kanji in case I foget it.

Thanks, hopefully.

stephen
 

Answer:MS WORD 2000: typing text above text in one line??

What you can do is insert a comment.

Outline the word in the document, then click on Insert, Comment.

A comment box will appear at the bottom, type in what you want, then click Close. The outlined word will know have intials after it, and if you hover the mouse over it, a comment box with whatevr you yped will appear above the word. You can double-click the initials to change the comment text.
 

1 more replies
Relevance 54.53%

My husband's desktop icons are jiggling around on the screen and then disappearing. Following the instructions on the closed thread and I ran Panda Active Scan and then HijackThis (under Delbard) but when I attempted to post them (with the extra.txt attached) I received the above error message. What do I do now? Thanks.

Answer:The text that you have entered is too long (241241 characters). Please shorten it to

Attach the Panda log as well. That should cut it down to size.

19 more replies