Over 1 million tech questions and answers.

Solved: Access 2010 New Changing number into two different Text.

Q: Solved: Access 2010 New Changing number into two different Text.

I'm still working on that event.

Here's a variation on the Judging category problem.

I have another report to run with two different categories: Equestrian and Other which now appear in the reports as 2 and 3 respectively. It would be much more useful to the people having to stage these entrants as "Eqtn" and "Othr" (space limitations)

I am wondering if I can use a variation on the expression I used to change the "0"s in the judging categories to "NOT Judged"

That expression was: IIf([judging category] = 0, "not judged", [judging category])

I am wondering if I used something like IIf([Class] = 2, "Eqtn", [Class] = 3, "Othr"])

Would this work?


Preferred Solution: Solved: Access 2010 New Changing number into two different Text.

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

A: Solved: Access 2010 New Changing number into two different Text.

Read other 16 answers

Hi All,

I am working on a special event that happens every year. I have the entrants for this event in a 2010 Access database table.
Some of the entrants are judged and some are not. Those that aren't judged get a "0" entered in there "judging category" field.

In previous years, my boss would take the information from the tables and dump them into Excel. She would then manually change the "0" into the text "Not Judged" and then make an Excel report to give to the judges.

She was so impressed with my other Access reports that she wants to skip the Excel dump and have me make an Access report for the judges, However, she still wants the non-judged entrants to show up on the reports we give the judges as "Not Judged". I have books that tell me how to write all kinds of numerical expressions, but none that tell me how to convert a number to a text message.

Please, if someone knows how to do this, let me know the steps, and if you do it in the query or in the report based on that query.

Thanks in advance,

A:Solved: 2010 Access help changing a number into text

Read other 14 answers

I am creating a report that lists entrant cancellations for an annual event. The cancellations field is currently a Yes/No checkbox called "Cancelled". I would like the report I generate to actually say "CANCELLED" as opposed to "Yes" . Would the Expression for this be:

IIf([Cancelled] = Yes, "CANCELLED", [Cancelled])

or would it be different because the cancellation field is a Yes/No checkbox?



A:Solved: Access 2010 Changing Yes/No Check box to text in Report

Read other 10 answers

Basicly this is what i want to happen.

There is a field it has the text value Test(1)

i want an expression that will rerurn the 1.

The numeric value could be of any length eg: Test(10), Test(999)
The text value can also be of any length eg: Testing(1)

Ive been plaing arround with the Trim function but i could use some help.
Thanks guys

A:Solved: MS Access: Capturing a number out of a text value.

Read other 16 answers

I am using Access 2003 and would like to be able to change the text colour of one field in a sub form according to the content of another field. Does anyone know of any code that would allow me to do this?

A:Solved: Changing Text Colour in An Access Sub Form

Read other 14 answers

Hi all. I am sure this is a fairly basic question which shows a lack of understanding of how Access works, so if its stupid, I apologize in advance...

I used the form builder to create a new input form for data. There is one selection for "Manager", which defaults to a text box that you can navigate with the arrows on the bottom of the sub-form, which has the manager id (primary key), the date, and the return associated with it. It works as intended, but the text box won't work long term.

I expect to have a decent number of managers, so I'd like to make that a drop down box so the user can select it, not have to scroll through one by one. I changed it to a combo box, and specified the query to populate the box. When I select a different manager than the default, I get an error which says, "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I think its trying to create a new manager with the selected name from the combo box, but it won't allow duplicates (which it shouldn't). What am I missing conceptually here?

A:Solved: Access Forms - Changing Text Box to Drop Down

Read other 16 answers


I'm using the below post from OBG to change my hpyerlinked email addresses to text fields, but keep receiving a data mismatch error for the "correct" expression. I'm not sure why Access thinks the "length" expresion isn't a number since it's displayed as a number when I run the query. Can someone help?



Yes, if you change the Hyperlink field to Text you will see what is wrong with the data, you can then use an Update query to remove the "extra" data that you do not want.
You need 2 queries one select query with the email address and
length: InStr([email Address],"#")
correct: Left([email Address],[length]-1)
and then an Update query based on the first query where you update the email address to the [correct] field.
Take a copy of the database or at least the table before running the update query.​

Read other answers

I am creating a golf club database as part of my studies, I had a few issues previously which were resolved on here, thanks.

But now I have another drama, I have an update query "Category_Update" which updates information into a table "tblWinners". There are 6 possible entries. M - J, M - A, M - S, F - J, F - A, F - S, where M is male, F is female, J is junior, A is adult and S being senior.

I have a macro which deletes the current entries in the "tblWinners" table and a form which uses text boxes to update the table using the query. Prior to adding the macro, if an entry matching the data I try to input is present (e.g. Gender:M and Category: A already in the table) it will attempt to run the query, but fail because "Gender" and "Category" are primary keys in the "tblWinners" table. But if the data I input does not match an existing entry the query will fail, not even attempting (as in 'You are about to append 0 row(s).' as opposed to 'You are about to append 1 row(s).' and then failing due the the primary key issue.

Previously in my study i read that you need an entry to append to, but with the deletion macro there is nothing to append to and so it fails.

Any help would be greatly appreciated.


A:Solved: Access 2010 Update Query from text box parameters in a form

Normally Append Queries append to empty Tables without any problems.
So it would appear that you are not meeting the criteria that the Table needs to do the append with, does the query run on it's own when you run it manually.

Read other 2 answers

I have what I hope to be a relatively simple question..

If I have a drop-down box in word, how can i get it to spit out a line of text depending on what I have selected in the list?

Read other answers

It's my first time posting on techguy but I use it regularly to help solve lots of problems with my access database - but this one has me stumped and I can find a solution out there!

I have an Access 2010 database table and related query and report that contains payment types, i.e. 1 represents credit card, 2 represents cash, 3 represents cheque etc. I am trying to create a report to tell me how many of each type of transaction I have made each month. The report is looking great, but I can't change the 1, 2, 3 etc to be credit card, cash or cheque to make it easier reading! At the moment, the sub footing is just reading Payment Type 1, and I need it to read Payment Type Credit Card.

I am guessing I need to use some sort of conditional formatting or something!? Or am I missing something really obvious!!!
Can anyone help?

Thanks in advance


A:Access convert number to text

spicey80, welcome to the Forum.
Am I correct in assuming that you are using a "Combo Drop down list" to select & display your payment method?
if so where does the Combo get it's list from?
A list you typed in or from a table?

Read other 3 answers

Hi all.
I'm new in on this forum and I hope that you guys can help me with a access problem.

My database are build op on buildings cases and I wan't the database to automatic generate serial numbers.

One road should have the first 4 letters of the road and then a serial number.

Like this:
Roadone - Road001
Roadone - Road002
Roadtwo - Road001
Roadone - Road003
Roadtwo - Road002
Roadtree - Road001

Is this possibly in Access?

Dennis Fischer

A:More then one serial number in Access 2010

Fischer12, welcome to the Forum.

It is possible using VBA code, however you are likely to run in to a problem,
ie Road name woodville, first 4 letters wood, road name woodacre als has first 4 letters of wood.

Read other 2 answers

I've got a field that was imported as a number, 16 digits long, and it is truncated and presented in scientific notation.

If I convert it to text, it gets untruncated, but leaves the "E+15", in the text and omits any trailing zeros.

how can I write a queary or adjust the definition of the field in the table in such a way to recover the whole number.

please help.


A:Access 2003 Text/number converstion question

I don't have Access on my machine anymore so I can't say this conclusively, but I'm not sure it's possible with a query. A string of 16 digits represents a number in the quadrillions, and the highest number Access can handle as an integer is slightly more than 32 billion. So no matter what, you'll never be able to input 16 consecutive digits as an integer (i.e., non-exponential) number.

If it's possible, I'd say just reimport the values but coerce the field type to text. Otherwise, if the exponent always represents zeros not other digits, you could do it with VBA by concatenating zeros to the end of the digit string based on the size of the exponent.


Read other 1 answers

need a record set like this

I have this a table named numbers and have a field name num and it's have this records

And I have in a form an unbounded box that have this number 133 and I want that the computer will check to get this value from the number table so the computer will start from the beginning and when it's be a number that it's larger from 133 (plus all previous records) that is by our case by the 299 record because 2+1+100+299 equal 402 so then the computer will split the 299 to two parts so i will get whole fields that are equal 133
so from the 299 its will be two records record one is 30 and record 2 is 269
so i will have this records in my table

i need this code for a complicated reason so i will make it easy for and for you and just ask this code

A:recordset aim a specific number in access 2010

well, the question may be simple to you but the explanation of what you mean is not quite simple.
I don't understand the question.

Read other 2 answers

I am using Access 2010. I have a main form and a subform. I select a record in the mailform (via ComboBox) and see the corresponding records in the subform (master-details style).

I would like to duplicate the "record number box" on the bottom of the form by displaying the "nn of mm" records in a TextBox. I cab find the current record, but how do i find the number of records in the recordset.

I havve used the command "F_rcTB = Me.Form.CurrentRecord & " of " & Me.Form.Recordset.RecordCount" on the "current" event of the subform. The command works great, once i go to the second record or anywhere after that, but it will not display the corrrect counts on selecting the "master" selection criteria.

If i use the debugger, then the correct numbers show up.
What am i doing wrong or is there a better method of retrieving the data?

I dont see the "RecordCoun" property explaind in the help files for Access 2010. Does it still exsist?

Read other answers

I have created a document in MS Word 2010 that has a textbox with a background color. When I print the document to my printer (have tried multiple printers) or print to PDF, the textbox prints but the text itself does not print. (see attached image)

Upon further investigation of the PDF, I found that the text is actually layered below the textbox. For some reason, Word is printing the textbox on top of the text itself.

When I take the textbox, copy it to a new document, and try to print, it prints correctly.

I have also checked my printing preferences and I believe all the settings are correct.

Does anybody know how to fix this?

A:Solved: Word 2010 not printing text inside text box

Read other 13 answers

I'm "scundered" to only now discover a whole raft of text effects are available within Word 2010 except I can't access them!! That's partly the reason I'm only now realising they exist, as the button's been greyed out and I've continually missed spotting it to investigate until I read about them online and twigged.

Anyone any ideas on how I can get them to show again? I've gone through the options and checked they're all in the menu ok and even tried to set up a new group and put them in there, but same problem. The button shows but as unavailable. I've no issues with any other buttons in the program being like this but given the bulk of my Word usage is text editing, I'm SO upset to have not spotted this a LONG time ago, as no doubt the beta will soon be closing and I've no means to afford the full pkg. So ideally I'd like to be able to utilise the functions and set text into documents that at least then I'll have for future use.

A:Can't access text effects in Word 2010

I could be wrong but I don't remember that feature being enabled in Beta

Read other 2 answers

I use Access to create queries then export them as text files (was using Office 2003). We upgraded to Office 2010 and my most important export query will not export with the spec I request. I am requesting a text file export, fixed width, advanced settings. The field width is set to 5, but when I look at my export file it has ignored the width setting and is populating the field with 20 or more characters. I cannot figure out what I need to change. I went back to an older machine with Office 2003 and tested my export and it worked just as it always has. Please help! I cannot find any solutions for this.

Read other answers

Hello All,

I am having trouble trying to get my button to display the controlTip Text. I have used the function in the past many of times. Where I have the word 'close' in the controlTip Text for the button CmdClose it does not display. I have already made sure the button is positioned to the front so its not behind anything.

Hopefully somebody else has come across the same problem and can tell me how to fix it, if it being a simple control to turn it all on.

I have looked on my colleagues machine and he gets the same problem.

Grateful for any feedback,

Thanks Mike

A:Access 2010 Control Tip Text Not Working

The Control Tip has always been a bit hit & miss and sometimes need the mouse to be on the object for quite a while before it does display.
I am not aware of any settings that you can use to turn iton or off.

You could try VBA code like this
or this

Read other 2 answers


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


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

Read other 1 answers

I have a database developed in Access 2003 that works fine. When I bring it into Access 2010 and try to export a query into a text file with an export specification of fixed field lengths, the exported file is does not use the export specification properly. Does anyone know how to correct this issue?

A:Access 2010 - Text file export issue

Read other 7 answers

I have a form which has many text boxes. My default language has been set to Arabic so each text box accepts Arabic entry to begin with. In some text boxes I need to enter English only, so I have set the language in that text box to be English. When the cursor comes to this text box, it takes little time than usual. After entering the text to move to the next text box also it takes a little more time. To sum up, whenever the cursor reaches the text box that has been set to accept a particular language, it takes more time to enter and exit. How can I overcome this problem.

A:Access 2010 - moving between text boxes takes time

Perhaps it is doing spelling and grammar checks?

Some information about using different languages in Access:
Type or edit text in a different language - Access - Microsoft Office

More info:
Check spelling and grammar in a different language - Access - Microsoft Office

Read other 7 answers

I'm working in Access 2010 in Windows 7. It does not export tables to fixed length text files correctly. I'm using correct specifications for export, and the text file does not line up.

Read other answers


I have currently a form that uses a tab control. The tabs are on top of the form. Some of the pages are too high for the screen, so one must scroll. Is there an easy way to put the tabs on the left of the form instead of on top? Or is there a possibility to "freeze" the tabs so that the tabs continue to be visible when scrolling the page? I've been searching the WWW for an answer, but couldn't find the solution (if there's any).

Read other answers

OS Win 7 64 bit
Office 2007

When I import a data file some of the numbers appear in an unknown format:

1. they do not respond to the format buttons in the number menu.

2. cannot be converted from text to numbers using the procedures recommended by Microsoft

3. When I use the clear and trim operators to look for hidden data, I get a #VALUE! error.

4. The numbers do not appear to be text because there is no little triangle in the upper left corner of the cell

Got any ideas on how to convert this data to numbers?

Many thanks,


A:Solved: text to number

Read other 9 answers

Im running Home XP and want to change my dial in tel number.
I click Start then Control Panel, then Network and Internet Connections, then Network Connections but Network Connection screen does not show any networks. I have Earthlink and Pcpeople installed.

A:Solved: Changing ISP Tel Number

Go to control panel, internet options, connections tab, click on default internet connections, click settings, properties. You can change phone number right there.

Read other 1 answers

Hello friends,

I have a number of data that were pulled out from an oracle database, where it had entered in text format. In fact it contains both numbers and text. Is it possible to convert all numbers that entered as text into number format? It is required for calculation in Excel. When I tried by selecting and changing their format, it is not happening. It works only if re-enter that number in that cell. Any remedy?

A:Solved: Converting Text to number format

Read other 6 answers

I would like to assign a sequential number in Column A if a cell in Column B contains text.

I used the following formula but it did not work:


In essence, I want the following:
Row Column A Column B
1 1 True
6 2 True
8 3 True

Can anyone help?


A:Solved: Sequential Number if Cell Contains Text

there maybe a better way to do this

Assume the data starts in A2 and B2

in A2 put
and copy down

see attached

Read other 3 answers

At work with Excel 2010. I am a spreadsheet newbie so bear with me. I want to have "TOTAL: x" in one cell, where total is text but the x is the sum of the following columns. Is there a way to do this?

A:Solved: Combination text and number in one cell

Not sure about Excel 2010, but in Excel 2003 you would use the CONCATENATE function to combine text and numbers into a single displayed string.

Read other 3 answers

I'm working on a laptop (2 actually, but let's start with the first) that was eaten up with malware. It's an Alienware 51-M. It's a P4 3.2 with RAM. I've not heard of AW machines before, so I don't know if they have a good rep or not. I have so far cleaned 1605 viruses off of it and over 3k spy & ad junk. Yes, it the winner of the alltime-most-highly-infected-machine-I've-ever-worked-on award! (The kid's a gamer and Japanese animated movie download fanatic and music, of course. And with absolutely no protection on either machine - EVER. His parents have more $$$ than sense, I think. But that's neither here nor there, right? So . . . ) Anyway I finally convinced them just to let me wipe them out & start over, but the kid has absolutely no idea where his recovery CDs are. I was able to get XP installed using my CD with a only a couple of little hiccups that I got past. Now, I'm trying to change the serial number to his via the sticker on the bottom per the instructions at MS Q328874. I don't know if the problem is that my CD is an upgrade CD instead of a full install or if it's that the solution only applies to volume licensing. Does anyone know if I need to activate the current serial number before changing it to the correct number? Or will it not work at all since mine is the upgrade version? Any suggestions on how to proceed? Thanks.

A:Solved: Changing XP serial number

Read other 16 answers

Some time last year when I ran a full-system scan on Microsoft Security Essentials, the total number of files scanned was 375,752. I recorded this number, because I was curious about how many files MSE scans.

I don't usually pay much attention to this number, but yesterday when I completed a full-system scan the total came out as 344,937.

Since I haven't really deleted much I was curious about why the number had dropped like this. I figured that MSE must be skipping some files like NIS 2012 does after repeated scans, but when I restart the computer and run the full-system scan again, the total comes out different each time. I've even tried turning-off and then turning-on real-time protection to see if it would make a difference, but the numbers continue to fluctuate each time.

So far I've had the following results:


I'm probably worrying over nothing, but is this normal and what is the cause of this?

Thanks in advanced,

- Unlucky Pete

A:Solved: MSE Number of Files Changing

I will stand corrected but I think MSE reports items scanned, rather than actual files

However the reason for the slight differences are that until a virus definition update MSE remembers the items scanned and will not scan them all again, unless it recognises changes
The exception to that is the virus definition update when it will scan more or less all

In simple terms, MSE remembers some of the files it scanned and will not scan again unless the file has changed.

This is why the first scan takes longer than subsequent scansClick to expand...

and after a virus definition update


and not always realised all the options you may set

Read other 3 answers


I visited a couple of chat and backgammon gaming on-line web-sites and downloaded from them.

Now, whenever I try to connect to the internet using my dial up connection to my internet provider, I find that my user name has disappeared and the telephone number changes to a number in another country (Malaysia).

What I have tried already:

1. Deleted the Network connection and re-created the correct connection but after hanging up and re-dialing later, I find that the info. has disappeared and the number to dial to Malay comes up again.

2. Virus Scanned with McAfee 8.0 but found no virus

3. downloaded AD-WARE, CWSHREDDER, SPY-BOT but found only the Microsoft programs for warning if anti-virus has been disconnected.

Do I have a virus or some type of spyware stuck in my computer???? what to do???
Thanks in advance to anyone who can help me )))

A:Solved: my dial up connection tel number keeps changing

Read other 16 answers

How would a convert a text/string field to a numeric field using a formula?

A:Solved: Excel Formula -> Conver Text/String to Number


so if you have 10 formated as text in cell a1 - and it will be left justified by default then
will change to a number and you will see it goes to right justified

that will take a number that has been formated as text and change to a number

Read other 2 answers

Hi ther guyz............i a have small problem with the exel sheets...........
my problem is e.g. i have alot of cells with a number and some text in it........and they both are in one/single cell (e.g. "878 queen st" in A1)....now what i want is to remove let's say "queen st" from each cell so that there is only number left in it.....................i cannot figure out any formula........if there is any..............need help imediately

A:Solved: EXCEL: How to diffrentiate Text & number from a single cell????

Read other 7 answers

Is it possible to change the size and number of folders displayed, such as in My Documents, or My Pictures? Thanks.

A:[SOLVED] changing size / number of folders displayed?

in Windows Explorer go to the tool bar View and choose List or Details for smaller icons which are more visible

Read other 2 answers

The company I'm with recently updated from Word 2003 to Word 2010. I have a document (created before I started) which we use to print gift certificates. In the lower right hand corner of the footer we have a code which was created to track the number of the gift certificate. GCID#010-#####

In Word 2003, I used to be able to just select the ##### area, click on Page Number and type in a number (ie 01100) and then subsequent numbers would fall into line.. 01101, 01102, etc.

When I open the document in Word 2010 and attempt to do this, nothing happens. I even attempted to click on the Page Number option, set my starting page number in the footer to 01101 and still nothing happens. I even deleted the footer, recreated it and attmepted to setup the same number scheme as above but was unable to even get the number to show up correctly. It kept starting at a page number of 845, regardless what number I selected.

Edit: As I was looking further into the footer editing, I noticed the 01100 portion of the number is listed as a Frame and consists of the last 4 numbers - 1100. I was able to open an edit option of the frame but it only gave me Text wrapping and size adjustments.

I'm looking for any suggestions/solutions to create an increasing page number in a footer of Word 2010 as I described above.

A:Solved: Footer Page number Word 2010

Hi TKRG, welcome to TSG. Is it possible for you to attach the file? You can replace the actual information with dummy information, since you probably don't want us all printing free gift certificates.

Read other 3 answers

How to indent Footnote text (between the raised number and the body text) automatically?

I have word 2013, and I would like to insert an indentation 1.5 between the raised number and the text in footnotes (see figure 1)

Figure 1

When I go to "Footnote Text" style, and then paragraph to do the indentation, it moves the number and the text to the right (see figure 2). But I do not want this.

Figure 2
1xxxxxxxxxxxxxxx 2xxxxxxxxxxxxxxx3xxxxxxxxxxxxxxx
If I use the hanging option, it only indents the texts below the first line (see figure 3)

Figure 3

I have gone to "Footnote Reference" style, but the "paragraph" tab is locked. I cannot enter. Can anybody help me how to unlock it? Alternatively, how can I get the results I want (figure 1)

Thanks, M.

A:Indent Footnote text (between the raised number and the body text)?

Create your own style, based on Footnote.

Read other 2 answers

I am looking for an excel solution or a text database query tool, that I can post as a snippet tool, for visitors to check their lottery winning number's.
The format is
I PRIZE 40,00,00$ WJ - 274036
WG- 274036,
WH - 274036,
WK - 274036,
WL - 274036

II PRIZE 10,000$ WK - 336373
III PRIZE 5,000$
20517, 33196, 67148, 56956, 54872 TICKET ENDING NUMBERS
VIII PRIZE 20 93, 76, 53, 81, , 69, 19 TICKET ENDING NUMBERS

So if one enters a ticket number, the software checks accordingly and prints the result.

Thanks for a solution.

A:Solved: Lottery winning number checker in excel or text database

Read other 7 answers

Hello guys, I just can't work this one out. A simple formula somewhere on the worksheet "=B1-B11" will give us the answer to the contents of B1 minus the contents of B11.

Here's where I am stuck. I want the answer to be B1 minus what is in the cell that is 10 cells down, in this case B11. But I want the be able to change how many cells it will go down to find the cell to subtract from cell B1.

In my example, if I put 10 in cell A1 how do I make so if I change it to 5, the above formula will effectively be "=B1-TheCellThatIsA5CellsDown", in this example the same answer as the formula will effectively be "=B1-B6" if even makes sense?

Thank you in advance.

A:Solved: Excel - Changing the range to include a certain number of cells

Read other 8 answers

I have the following data:

Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?


A:Solved: Excel and VB: Changing cell value to text with macro

Read other 16 answers

Solved!, my final code for getting my version from a java class file is complete!


Private Funtion GetVersion()
If IO.File.Exists(".\Game.class") Then
Using reader = New IO.StreamReader(".\Game.class")
Dim line = reader.ReadToEnd
Do While line = "" = false
If line.IndexOf("XXyxxY YxxyXX") = true Then
result = line.Substring(line.IndexOf("XXyxxY YxxyXX"))
Debug.WriteLine("could not find string")
End If
End Using
If result = "" = False Then
Dim o As Integer = 0
Dim i As Integer = 20
Do While i > 0
If IsAlphaNum(result.Substring(i, 1)) = False Then
o = i + 1
i = 0
i = i + 1

End If

version = result.Substring(20, o - 20)
Debug.WriteLine("version:" & version)
Return version
... Read more

A:Solved: [VisualStudio 2010] - Reading a file for text.

Read other 8 answers

We use Outlook 2007 in our office. About two weeks ago, all of the emails I have been sending to the boss have been arriving in her Inbox as Plain Text. This morning she didn't receive the new staff member's email contact info I attached to a group message...everyone else in the office received my message in HTML, with the attachment, no problem.
I did some surfing this afternoon...found suggestions to check Email Settings under Trust Centre in Outlook...not the problem. Also found some allusions to AVG being the problem, checked those settings, again...not the problem.We need to get this sorted ASAP.
Thanks very much for your help!

A:Solved: Outlook suddenly changing HTML to plain text

More surfing last night found this...

Open the Contacts folder in Outlook. Double-click the contact you want to change.
Double-click the contact's email address.
Uncheck "Send plain text only" in the "Internet Format" box. Press "OK."

When I got to work this morning and looked, sure enough...Send Plain Text only had somehow gotten checked. I unchecked it, sent a test message and all is good again.


Read other 1 answers

I'm trying to create a macro in Word 2010 that will allow me to insert text from file but pauses when it takes me to the specific folder so that I can select which file to insert. I have a folder containing over 50 files from which I want to choose.

I created this macro once from directions I found on line but my macros were recently lost and I'm having to start all over. I can't for the life of me remember the code for the macro and I can't even remember what question I asked to get to the code previously!

A:Solved: Word 2010 Macro Insert Text from File

Read other 12 answers

Hi all,

I'm looking for a way in either Excel or Word 2010 to add text to a line before the text. So, for example I have something like this:


And then I want to add "1 " before each line in a way that is copy pastable, so it looks like so:

1 Name1
1 Name2
1 Name3

Is there anyway to do this. it's mostly just to help with copying text from Word/Excel documents onto forums so it formats correctly. Any help at all is much appreciated


A:Solved: Word/Excel 2010 Adding text before each line in a Document

Hi Matt,
It's probably a little cleaner to do it in Excel than in Word, but also a few extra steps. In Word:

You can run a find a replace. Without including the quotes, find "^p" (the paragraph symbol) and replace with "^p1 " (there's a space after the 1). This replaces the paragraph break at the end of each line with another paragraph break and then "1 " at the beginning of the next line. The problem with this method is that the first line won't have a 1 in front of it (because there's no paragraph break before that line) and the last line will have a stray 1 after it. But this should be relatively minor cleanup.

Alternatively, in Excel:

Insert a column to the left of your names. Without including the quotes, enter "1" in the first cell and copy it down your spreadsheet. Insert a column to the right of your names and enter this formula (assuming your names are now in column B):

=A1&" "&B1

This should give you the result you're looking for in column C. Hope that helps.

Read other 3 answers

I've developed a database in Access 2010 and am using the Navigation Form for users to access the different forms and it's working very well. The problem is we still have some workers who are on Windows XP boxes with Office 2007 and the Navigation Form won't work for them. I've been asked to develop an Access 2007 Switchboard which will mimic the Navigation form so there is some continuity between them and so that once all the systems have been upgraded the users willbe familiar with the interface. I easily designed a form with the look or the Navigation Form but haven't been able to figure out how to handle opening the different subforms on the one main form. Is it possible to place an Unbound Frame on the form and with a click of a button open a subform in the Frame or have a button just open a subform? How would that be coded?

Thanks for your assistance

A:Solved: Access 2007 Switchboard & Access 2010 Navigation Form

I am a bit confused because Subforms normally open when a mainform opens.
I am not familiar with the Access 2010 navigation form so I am not sure what you are trying to do.

Read other 2 answers

Hey guys long time no hear! Anyhoo, The office has recently upgraded all the computers to Microsoft Office 2010 except for mine because of my Access 2007 database. Hey they're more network/server oriented then software oriented so understandably they're a little gun-shy. Well, just wondering what consequences lie out there if I upgrade? Don't like what I'm reading out there right now, but I have always liked TSG's input on matters.

A:Solved: Access 2007 versus Access 2010

Read other 6 answers

My company was using Office 2003 until 4 months ago when they moved to Office 2010. When they install Office 2010 Office 2003 was left on the machines so that we currently have both versions installed. I have developed and deployed several databases since Go Live, all in Access 2010, and all was going fine until Office 2003 was uninstalled from several machines and when they tried to open the database they got:

"Execution of this application has stopped due to a run-time error.
The application canít continue and will be shut down."

I went all thought the code and couldn't find anything so on a whim our IT guy, the one that had removed Office 2003 reinstalled it and BAM, working again.

I have no clue as to what is going on here, Shared DLL, a Reference that's 2003, nothing. i need any thoughts as to where to look and what it might possibly be.


A:Solved: Access 2010 / Access 2003 Issue

When you uninstalled Access 2003 did you re-install or repair Access 2010, Office overwrites certain dll files so that the one in current use has control, if you then uninstall it the dll files do not necessarily return control to 2010, hence re-installing 2003 also re-installed the dll files.
Normally you can't run both versions of Access at the same time due to this problem.

Read other 2 answers