Over 1 million tech questions and answers.

Solved: Cannot type in fields and can't restore in XP

Q: Solved: Cannot type in fields and can't restore in XP

All of a sudden I cannot type in fields online and cannot restore because the calendar is blank in system restore. Can anyone help? I can click on links, but can't type passwords, etc. I would greatly appreciate any help!!!

Preferred Solution: Solved: Cannot type in fields and can't restore in XP

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: Cannot type in fields and can't restore in XP

Read other 7 answers


I cannot type in any text box fields on this XP system. In addition, System Restore will execute but the calendar window to select the restore date is blank.

I've attempted to boot from the OS disk and do a installation recovery but the "R" option it not available.

I could use some help.


Read other answers

One of our office computers won't allow the user to type into a search or log in field in IE. The mouse is not the issue, we changed it out, because we can click on links and click into the address bar. Ran AVG as well as AdAware both clean. When I tried to run HouseCall it tells me there is already a HouseCall running and shuts down. I can't run Panda because it asks for my e-mail address and I can't type into the field.


A:Can't type in search or log in fields

do a control/alt/delete
the beta version of housecall might have hung it up. [happened here]
stop and remove any references to it and use my link below for the original
post back

Read other 4 answers

Hi there i have a bit of a PC issue that i am looking into.

When using internet explorer and a site for example ebay. It will only let me populate the Username Field, But when i try enter the password the field doesn't allow any data to be entered. This happens for other programs outwith Internet Explorer too.

The OS is Windows XP

What would cause this to happen?


A:Unable to Type in some fields

Press Tab instead of enter when you want to move to a password or other field in a form. Pressing enter pretty much means that all fields are complete (like pressing "Send" or "Submit" yourself).

Read other 1 answers

i have created a form in word, adn i want it to be read only for most of the form. However, i do want certain fields to allow users to type in. Is there any way that i can easily do this. i know that this may seem kind of vague, let me know if you need any other info.

A:MS Word; only type in certain fields

Too bad there's not a strikethrough text format. Anyway, ignore the stuff in red.

This is a common question that has no easy answer. There is no way to permanently lock the text of a document while leaving the fields open. There are some workarounds, such as using a background graphic instead of body text.

I don't know what I was thinking about when I wrote that, but it wasn't forms. It might have been converting a PDF document to a protected Word form. Another of Dreamboat's articles.

If you search the forums for something like Word form protect text, you might get some hits. The question gets worded differently from time to time, so play around with the search criteria until you get a thread that works for you.

Here are a couple of similar threads (searching word form lock text):


And here's a link with some general info. Thanks to Dreamboat for that.



Read other 3 answers

One of our office computers won't allow the user to type in the search fields or log in fields within IE on any website. Can't search on Google, Yahoo, can't log in on hotmail or other online applications that we use at work. In addition to this issue; when I open Control Panel I get a script error, the icons on Add/Remove Programs are very small with no description of what the icons represent and if I try to udate Windows it tells me that it needs to install addiotional files to update the system but it gets locked into a loop where it installs then tells me that it needs to install the same files. I can't run a Panda scan because it asks for my e-mail address and I can't type into the field. When trying to run a Kaspersky online scan it won't update the new virus definitions which is an automatic action. When I try to run HouseCall it tells me that there is another HouseCall running and closes the prgram. There is no indication in Task Manager of two HouseCalls running. Ewido found some problems corrected them but didn't fix my problem. Replaced the mouse and did a restart so those won't work. The computer was running fine one evening and when we came in the next day it was acting this way.

AVG, AdAware run clean. I downloaded a trail Kaspersky Security program and it ran clean as well. Suggestions are welcomed.

Here is my HiJackThis log:

Logfile of HijackThis v1.99.1
Scan saved at 8:20:57 AM, on 8/3/2005
Platform: Windows 2000 SP4 (WinNT 5.00.2195)
MSIE: Intern... Read more

A:Can't type in search or log in fields in IE

Your log looks okay. Have you considered re-installing IE?

Read other 3 answers

Hello Group,

Suddenly I am unable to type into form fields.

I have to trick it by writing the text in an e-mail, copying that, then right-click and paste into the form field - even to login here I had to do that - nothing happens when I try to type into the field.

Environment: Windows 7 Home Premium
Asus PC

Hope someone can help. Thanks for looking in.


A:Suddenly can't type into form fields

Problem partially solved. Still have no clue as to why I could not type into form fields, even logons, google ... but a simple re-boot and now I can enter text into form fields. However, sporadically I lose control of positioning - sometimes the arrows stop working, and sometimes I cannot change position in the form by moving the cursor. What is going on?
Thanks for looking in. seekinganswers

Read other 3 answers

Using Windows 7 I suddenly can't type in fields of secure documents (opened with https). I have tried documents such as for paying bills and making reports, using IE, Firefox, and Chrome. Applies to data entry fields or radio buttons. Data fields accept the click to select the field, but do not respond to data typed on the keyboard.

I have searched the web for "can't type in fields of secure documents". I get lots of hits, but none are appropriate and few have solutions anyway.

A:Can't type in fields of secure document

Read other 6 answers

I'm not sure what to do here...

After downloading Explorer 8 (and updating Windows) I am unable to type in any field below the top pane. (I can type text just fine in my google search field and the url field)

I un-installed Explorer 8 (which re-installed Explorer 7) with no improvement.

I noticed that after completing the Windows update (I have Service Pack 3) my Anti Virus (Zone Alarm) had been blown away. I had to re-install it. I've since learned that I should disable anti-virus software prior to doing Windows updates.

Is this a virus?


Read other answers

I am running Vista Premium SP1 on a Dell Inspiron E1505. I have a new problem where I can not enter any text in any browser field, IE or FireFox. The text field appears but I can not click on the field and enter text. I have tracked the problem to a corrupt or imcompatible dll called mshtmled.dll located in c:\windows\system32 folder.

How do I extract and install this dll with any of it's related dll's in Vista?

Read other answers

I upgraded my laptop to Win 8.1 a few days ago and everything seemed to be working fine. I ran into an issue today using the desktop version of IE 11 where I can type text into the address bar but if I select a field on a web page, I am not able to type text into it. I normally use FireFox as my browser and it works fine (as does Chrome). If I bring up the Metro version of IE 11, I can enter text fine.

Anybody got any ideas how to fix this? It's not a big deal since I rarely use IE but it bugs me now that I know about it. I just checked on a netbook I upgraded and don't see the issue there.

A:Can't type into input fields in desktop version of IE 11

No suggestions?

Read other 1 answers

Hello, I use online accounting software (KashFlow) and part of entering invoices involves clicking into a date input field.  It is one of those where a little calendar shows when you click into the field.  You can also manually type a date into this field too. However. On my brand new Yoga 920 using Chrome and Firefox the date input fields are greyed out and a red 'no access' icon shows when you hover over them.  But you can still click it and the calendar pops up as normal.  The only difference is you can NOT type into them anymore. When the source for the page is viewed it looks like the fields have been designated 'readonly'. There is no such problem on any other computer I own, even when using Chrome or Firefox.  The date fields work perfectly well on these other computers - even on a Sony Xperia tablet I own. The only browser that works properly on my Yoga is Edge.  The date fields work as they should.  It's just Chrome (my main browser) and Firefox where they don't work. This seems like a Lenovo-based problem.  A little Google has revealed a couple of similar problems with other Lenovo users. Does anyone have any clue on how to fix this?  This is utterly bizarre behaviour and it's preventing me from working properly. I have attached a photo showing the problem when using Chrome.  These fields should never be greyed out. Thanks,Matt

... Read more

Read other answers

My 8 year old son decided to download some Malware onto my computer while I was deployed the last few months.  Anyway Im running Windows 7 Home Premium 64-bit and am having issues entering text into IE 11.  I believe the issue stems from PUP.Optional.MindSpark.
Im pretty sure I removed MindSpark completely by using MalwareBytes, SuperAntiSpyware, and CCleaner to get rid of it.  I also have McAfee AntiVirus which didnt catch Mindspark.
So the problem now and when the PUP was on my computer is that I cannot enter text into text fields on IE 11.  Right now Im using Google Chrome and am having no issues with it, but I would like to get the IE 11 problem fixed.  Also as a note if I run IE 11 as an administrator it acts normal, but as soon as I close the browser and reopen it, it stops working again.  A couple of things I have done that wound up with no results include:  Restoring Internet options to default, turning off protected mode, and ran a Windows system performance scan.  Also Ive made sure everything on my computer has the latest and greatest updates.
So hopefully somebody here can help me out.

Read other answers

Hi, I have been quite playing with some file with an unknown extensions like .ctp for a cakePhp file. Then I accidentally choose to open it using shell32.dll, so after that whenever i try to open the file it giving me an error. how can i restore the default association type of the file which is the windows shell common dll?

A:Windows Shell Common Dll Restore file type association restore.

Hello Marie, and welcome to Seven Forums.

If you like, you could do a system restore using a restore point (if available) dated before this happened to undo and fix it.

Hope this helps,

Read other 1 answers

I am trying to create links to specific locations with each document between two documents. The document names will change. I can update the current name of the other document by creating a custom property called "otherDoc". I have solved most problems, however, I am unable to insert a field into the address of the link (to make the link dynamic) without utilizing the showfieldcodes command (which is very memory and time consuming since the documents I am working on are very large). Below is my code. I was wondering if there is any way to set the address as a field? Or somehow input an address and it would be understood by word to be field.
Sub link_to_other()

'pastes hyperlink to the other document
Selection.PasteSpecial Link:=True, DataType:=wdPasteHyperlink, Placement:= _
wdInLine, DisplayAsIcon:=False

'selects the hyperlink that was just inserted
Set myField = Selection.PreviousField

'creates variables
Dim temp_address As String
Dim temp_subaddress As String

'sets variables
temp_address = ActiveDocument.CustomDocumentProperties("otherDoc").Value & ".doc"
temp_subaddress = Selection.Range.Hyperlinks(1).SubAddress

'changes the hyperlink the the dynamic value
Set SCut = ActiveDocument.Hyperlinks.Add( _
Anchor:=Selection.Range, _
Address:=temp_address, SubAddress:=temp_subaddress)
End Sub


Read other answers

Hi all,

I?m really in need of some help from some Access experts! I?m a newbie to Access, but I got myself busy with quite a big project... I?m trying to map out the product supply to shops in the whole country. I?ve come quite far for a starter, but I keep having 3 questions, it would be great if you could help me with this!

I have, amongst other tables, two tables called Stock_counted and Reported_quantity.

The table Stock_counted has the following fields:
- Shop_number
- Product_code
- Quantity_counted

The table Reported_quantity has the following fields:
- Shop_number
- Product_code
- Quantity_in
- Quantity_lost_or_returned
- Quantity_out

1. What I would like to do is to make it one table based on Shop_number AND Product_code. So in one record I would like to have Shop_number, Product_code, Quantity_in, Quantity_lost_or_returned, Quantity_out and Quantity_counted. How do I do this, making sure that the quantities end up behind the right product and shop? It is possible that some shops don?t have all items, while other shops might not have all products reported, or both. On top of that, I have another table with a price for each product, which needs to be related to it as well.

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

3.... Read more

A:How to combine fields in Access 2010 based on 2 equal fields?

Quote: Originally Posted by Josephine87

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

select shop, product, sum(quantityfield1), sum(quantityfield2)
from sometable
group by shop, product

Read other 1 answers

DNSunlocker was put on my computer and I can't uninstall it; the message is, "this file does not exist." I would like to create a restore point BEFORE this was installed.  How do I do this??

A:How to type in my own restore point

Hello and welcome onboard ! Thank you for posting in the HP Support forum. I'm afraid what you like is not possible - you cannot create a System Restore point now for a time in the past. That's because now is now and past has gone simply You cannot return it. You can create a restore point NOW which you can use in the FUTURE to get back system files to state NOW. But this is not recommended at the moment as your computer is infected. DNSunlocker is known adware/malware/virus. It is a nasty one. You can find more information about it here >> https://malwaretips.com/blogs/ads-by-dnsunlocker-removal/ Please, follow the instructions in MalwareTips website (skip Step 2 for AdwCleaner) - run the rest of the programs and steps to get rid of this pest. Please, let me know how it goes after that and if this helped.  For future protection, check how you protect yourself, what sites you visit and what you install. Use reputable security products (hopefully not free AV software). We could discuss this eventually once your machine is clean. You may also want to change your most important passwords for bank accounts, emails, social networks once you are clean.    

Read other 1 answers

As some know, I will soon have a new Toshiba laptop. I will be making the recommended restore DVD. What type of DVD should I use?

Also, will this type work well for backing up programs and data files? I will not be burning any music or videos. If not, what type is recommended.

Thanks, {redoak}

A:What type of DVD to use for Toshiba restore

Read other 13 answers

Needed to system restore a few times to get all back to working. C drive went from 19 gigabytes to 29. Is this a concern I need or I can forget it. Still have more than sufficient space.

A:XP sp 3 system restore doubled system fields

Hello and welcome to Bleepingcomputer.

You did a system restore and chances are you have more space taken up then you did before the roll-back.

You can go to My Computer right click your hard drive, choose Properties, click the disk clean up tab, then delete any temporary files, this will retrieve your disk space.


Read other 1 answers

I have 2 router one is a thompsons speed touch (wire) and the other a linksys(wireless) and i cant get the ps3 to connect to the internet properly everytime i try i get nat type 3 (that is limited connectivity) so if anyone know how to configure the router so i wont have that problem please help

A:Solved: How to get from nat type 3 to nat type 2 using two routers one wired other n

Read other 8 answers


I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!

A:Link Child Fields and Link Master Fields in MS Access 2003

climbingrose said:


I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!Click to expand...

It really sounds like form A and subform B are both using the same table, and are not a Master/Child field link situation. But rather, form B (the subform) will have code in the "On Current" event that will find the current record on the form B within the form A, therefore allowing that record to be edited. Review your original post, I think you used the "B" one place where you meant to say "A". No matter what, you need to clear up with us out here if both form A and form B are using the same table.


Read other 1 answers

In my database, I intend on making mailing labels, but the problem is that with the layout, I can't get the First Name and Last Name fields to stick together so then there are gaps between both of the fields.

Anyone know how to merge two fields into one? I've looked the net for how to do it, but haven't been successful at finding anything.

Thanks in advance!

A:Solved: Merge two fields into one

Read other 16 answers


I have a form with two fields that needed to talk to each other. One field is "Required Date" and the other field is "Opinion."

When the Opinion field has the text from a combo box " Unacceptable" I want the system to force the requirement to enter the Required date.

Any help?

A:Solved: Two fields if condition

Read other 10 answers

I have a form whose ALLOWEDITS is set to NO.
I want to be able to allow edits only on certain data presented in the form. In the On Got Focus event for a field whcih I want to be able to allow edits on I inserted the VBA code Allowedits=True. That allows me to edit data in that field. Then in the On Lost Focus event for that field I inserted the VBA code Allowedits=False.

So when I move to the next field on the form I would expect not to be able to edit it. However I can. The On Lost Focus event did not set the Allowedits=False command somehow.

Any thoughts on why?

A:Solved: Allow edits certain fields only

Read other 6 answers

I like to modify my file types Context menus for something like attached.

Is there a way to Save n Restore these settings for each file type modified ????

Read other answers

Hello, not sure how to explain this but hopefully this will work.

I need to combine the contents of all the cell Bís when cell A has the same contents (in this example 2222 etc.).
line 1 2222 object
line 2 2222 box
line 3 2222 something
line 4 2223 circle
line 5 2223 square
line 6 2224 stuff
line 7 2225 glass

When Iím done, my spreadsheet will look like this.
line 1 2222 Object, box, Something
line 2 2222
line 3 2222
line 4 2223 Circle, square
line 5 2223
line 6 2224 stuff
line 7 2225 glass

or this. It doesn't matter if the the original contents of the B cells stay as they originally were.
line 1 2222 Object, box, Something
line 2 2222 box
line 3 2222 Somthting
line 4 2223 Circle, square
line 5 2223 square
line 6 2224 stuff
line 7 2225 glass

I've been manually cut and pasting but there must be a better way. Microsoft Office Excel 2007

Thanks in advance!

A:Solved: Excel help combining fields

Read other 9 answers

I have an Access database where the data is being input in Access and displayed by Lotus Notes. Originally I had a number of Yes/No fields e.g. "Outside Storage" in the table. The person doing the Notes interface requested that I change these to Text fields which I did. The table values remained as Yes or No when I did this. The input forms kept their check boxes when I did this but as one enters data via the checkboxes the values are 0 and -1. If I delete the field from the form and add it again it comes as a text box which then displays Yes or -1, etc depending what is in the table.
The Notes person says data tables should not contain Yes/No fields or Combo Boxes like solid/liquid. My question is what is the best way to handle this assuming the Notes developer wants text fields in the table? Should I delete all the checkboxes from the forms and replace with text boxes showing Yes or No? Right now I have the validation of the table set to accept yes, no, 0 or -1. Finally, is the field on the form able to be changed back to a checkbox without changing the table field back to a Yes/No field? It seems as if the type of field placed on the form is inherited from the table.

A:Solved: MS Access Yes/No or Text Fields?

Read other 7 answers

I have a database, and I already have several fields "locked" so that chances cannot be made to these particular fields.

I have some command buttons that I currently have enabled, but would like to disable them when a certain checkbox has a "true" value (is checked).

How can this be done (if at all) on a "per button" basis, as I have some other buttons that I want to leave enabled all the time.

Thanks in advance!

A:Solved: Locking fields in Access

Read other 9 answers

I have 4 number fields that is formatted to currency with 2 decimal places. When I key in a dollar amount it is rounding the numbers. How do I get it to not round up or down?

A:Solved: Number fields within a FORM

Read other 6 answers

Friends, I have a subform with two fields yes / no. How do you select only one field to yes?
That is, if the "A" is set to yes, you can not mark the field "B" to yes, this example is only possible
mark the field "B" to yes, after clearing the field "A".

And the reverse, ie, if the "B" is marked
and yes, you can not mark the field "A" to yes, this example is only possible
mark the field "A" after clearing the field "B".

I tried this two codes:

Private Sub Form_Current()

If Me.FieldA = -1 Then
Me.FieldB.Locked = True
End If

If Me.FieldB = -1 Then
Me.FieldA.Locked = True
End If

End Sub

Private Sub Form_Current()

If Me.FieldA = -1 Then
Me.FieldB = 0
End If

If Me.FieldB = -1 Then
Me.FieldA = 0
End If

End Sub
In the first works only with the first two records, the third record from the two fields are locked.

In the second code has no effect.

Thanks for helping.

A:Solved: fields switch yes / no automatically

Read other 15 answers

Please help. I am trying to calculate a percentage of my yes's. I have several yes/no fields in which I'll need to calculate a rate. I would prefer to create a report that will calculate this for me. However, right now, I am really just looking for the easiest/quickest way to do this. So if I need to run a query first and base the report off the query, I'll do it. Please help ASAP if you can.


A:Solved: Calculating Yes/No Fields in Access

Read other 16 answers

I have a fully functioning dbase with the last Calculation that I cannot work out.

I am attaching a sample Dbase to help w the explanation.

I would like the Bonus Total to reflect all Totals. After totaling rate and standby total, I then want to choose my services and total out the Services total and refresh the Bonus Total with all of the updated info. I have stared merciless at this and tried several ways to make this happen.

I am slowly going mad. This is the last calculation then I am finished with this but have gone blank.

If anyone can help me, I would appreciate it.

As you tab through the dbase you will see that the Base rate is divided by 2 to get the standby rate and this reflects automatically in the Bonus Total in the top half of the dbase. Then you progress to service selections and the total is reflected upon pressing enter in the Services Total. This Total is what I want added to the existing Bonus Total that is calculated in the top of the dbase.

Sorry if I am repeating myself.


A:Solved: Access, Calculated Fields, OBP?? Anyone?

Bonus total has the calculation =[cboRateTotal]+[cboStbyRateTotal]+[cboServicesTotal] as it's control source.
Once you do that you can no longer change the value using VBA.
So the answer is to replace the =[cboRateTotal]+[cboStbyRateTotal]+[cboServicesTotal] with the VBA version.
So either set the control source to nothing or make it a field in the table.

Read other 2 answers

I have a table that displays a date split out in 3 different fields Month Day Year and I want to use a query to concatenate those fields. Could someone help with the expression that I would need to build in order to accomplish this.


A:Solved: Concatenating Fields in a Query

I answered this one myself. For those that are reading this post, I used the DateSerial Function and it worked perfectly.

Date : DateSerial ( "year","month","day" )


Read other 1 answers

hi guys,

i have a form with fields for two kind of users.One type of users required some fields and the rest (n/a). How can i have a selection of fields for each user and grey the rest. The code for the type of users is in a combo box. for example: "AW" users needed to fill in only field1, field2, but not field3 , field4. As also for user"OPS" requires the opposite.


A:Solved: greying some fields with condition

Read other 9 answers

hey guys i have a strange problem
the program that i need to code needs to have a value from the next record in the current record.

Pls see the attached pics to get a rough idea of what i need

i have tried to export the current table into temp table using
SELECT * INTO temp FROM table1

then delete first row of the temp table
then trying to append back
UPDATE table1, temp SET table1.nextn = temp.num;

what i get is just the last record value(see attached pic actualresult.jpg)

What can be done is to use manual coding to read betwwen records but the db i have is HUGE and going back and forth to get next records is going to kill my app.
pls help

A:Solved: Add Selected Fields from different table using sql

Read other 16 answers

I am trying to fill in a weekly dates using a form field start date.
It is setup as such:

Start Date: ________ (user enters date here in format ddMMMYY)
This is setup as a Text form field, set to date, with calculate on exit checked and bookmark as DateField.

Later in the document, I have a weekly calendar that I want to fill in the dates for Mon - Fri based on Monday as the start date from above.
I have been using the insert>Quick Parts>Field but cannot figure out the calculations even after multiple guides and searches.
I am able to reference the bookmark and repeat the date for Monday, but cannot figure out how to set Tue-Fri dates.

Please give me the exact code to put in if possible.
I could figure it out using VBA but want to do this without macros if possible.


A:Solved: Form Fields in MS Word

Read other 6 answers

I have a form with three combos and a subform with the following fields:
Step, dataprogramada, and datareprogramada datarealizada. The field step has a list box with 15 steps. I'm trying to include a new record 7 of these 15 steps to populate. Can anyone help me?

A:Solved: automatic filling of fields

Read other 16 answers

I have to concatenate the following by item number: I have attached a file with a sample table.

item number / memo subject / memo text
15056 / x/ e
15056 / t / r
15056 / s / q

there is also the issue where I have ~;~ in the memo text field. This is coming from some type of code in our ERP software. I would like to have this removed and not added in the final result which would be something like this:

15056/ x t s / e r q
I do not need comma's in between the data but if the field is blank i don't need that either.

I have researched and I have tried to do some VBA with Modules but I really don't know what I am doing.... Help!

A:Solved: Access - Concatenate fields

Read other 16 answers

Hi guys,

In a previous thread I have asked how to conditional format fields within a certain time frame and have been given the answer =TODAY()-[No of days].

This works sucessfully, so that if I want to mark every date more than a year old in red the command is =TODAY()-365.

Is there a way that I can then count these fields?

Basically.. after they have been marked red I want to know how many reds i have in each column..

Sorry... im an excel newbie .


A:Solved: Excel, Counting certain fields

Use the CountIf function.

Select the range of cells that you want to have counted and then enter a condition like >365

That should do what you want to do.

Read other 1 answers


I would like to delete these fields from Excel. Clicking on them I have error. How can I delete them ?


A:Solved: How to delete these fields in Excel ?

These are not fields, these are either buttons or objects to which a macro is attached.
Normally you should be able to click on this and choose (right mouse) to delete.
Or the sheet is protectd or the item is protected

Read other 3 answers

Hi, I have pop up error message Unable to cast object of type 'System.Boolean' to type 'System.String'" comes up every time windows 7 started...
So I check the msconfig if some start up software has error but I couldn't find anything.
I unchecked all start up application and reboot it but still have error message.
So I go event viewer then I found the error happened in the same time I start up the windows 7 so this might be the one.
This is info for error I got.

Log Name:Application
Source WMI
Event ID 10
Level : error
Event filter with query "SELECT * FROM __InstanceModificationEvent WITHIN 60 WHERE TargetInstance ISA "Win32_Processor" AND TargetInstance.LoadPercentage > 99" could not be reactivated in namespace "//./root/CIMV2" because of error 0x80041003. Events cannot be delivered through this filter until the problem is corrected.

Is there any way to fix this error so that pop up error might stop??
Thank you!

A:Solved: Unable to cast object of type 'System.Boolean' to type 'System.String'"

Read other 16 answers

MS Access:
I have several fields in a form that uses two tables. I would like to set up a command button so that when you are on a current record, it will copy the field information from the record you are on to other fields in the same record. I do not know the SQL commands to set this up.

For example, there are name fields, address fields, and phone to be copied. Reason: One is contact information; one is survey information. In most cases the information is the same but on rare instances, the information needs to be entered (when different).
This is not an update for all records in the database. This is based individually on each record.
Not sure if you need to do On current, on click, or after update.
Not sure if default value in form can be used.
Please help.

A:Copy data fields in same table to other fields in same table MS Access

Read other 16 answers

Finally after 3 weeks I find this solve for this error message

{ Unable to cast object of type system.boolean to type system.string }

by this tool " CCleaner" and It's works! 100%

Enjoy ​

Read other answers

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Professional , Service Pack 1, 32 bit
Processor: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz, x64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2993 Mb
Graphics Card: Intel(R) HD Graphics, 1272 Mb
Hard Drives: C: Total - 234274 MB, Free - 193142 MB; E: Total - 2048 MB, Free - 2010 MB;
Motherboard: Hewlett-Packard, 1722, KBC Version 29.36, CND037022T
Antivirus: McAfee VirusScan Enterprise, Updated and Enabled

I would like to add a formula that would automatically calculate a date field from one cell and add three years. See example attached, Thanks in advanced

A:Solved: Calculating Date Fields in Excel

Read other 7 answers

Hello all,
I have a db where I have a list of projects. The projects are separated into two tables with the first containing information about the client and a related table with information pertaining to the individual projects done for each client. This is a one to many relationship.

I am currently trying to establish a resume creator for my db where I would have an employee table which would be related to individual client's projects. My goal is to create a form that I can select what projects each employee worked on and give a report on all the information given in the client and project tables for the projects any particular employee worked on.

What I cannot figure out is how to relate the employee table. I can't do it to just the client table because the employee is not on every project the client has and I cannot relate it just to the project table because I need the client information in my report as well.

Any help would be greatly appreciated,

A:Solved: Access: Bind to multiple fields

Read other 6 answers

I have a table called Billing input
In this table is two fields
one field is Last Month reading
second field is This months reading
i want to run an update query that will copy data from This Months reading to Last Months reading and then Make This months reading cells all equal 0
These are both Number type Fields.

what should the query look like?????

I am using Access 2000 by the way
Thanks for allowing me to sound so stupid with such a simple questiopn but this really has me going

A:Solved: copying fields with update query

Read other 6 answers