Search results for query: *

Is it possible to have a formula ignore the tilde and still give me a result from the formula? ex: Cell A1 contains the value 2 Cell B1 contains the ~4 Cell C1 contains the formula =A1+B1 I am using the ~4 to indicate that it is 'an estimate' or an 'assumption' of what I think the number...

I have a (access 2000) form with several individual hyperlinks to their respective reports (click a link to open a report). how do i get the 'hyperlink form' to close or minimize when a hyperlink to a report is clicked. right now, when a hyperlink is clicked and the report opens, the hyperlink...

I want to re-use a db, (and same queries, reports, relationships, etc.), used for a previous project but field names need to be slightly changed. Is it possible to change field names in all tables, forms, queries, etc., in a db at one time? Also, if it is possible to change field names at one...

Is there a way to force the ampersand (&)to become visible in a Text Box? My company name has an ampersand, but it shows up as an underscore, not as itself. Is there a workaround to get it to show up? TIA

I would like to have the 1st letter of a word(s) in a field to be uppercase. I've found some help out there but I don't know enough about 'codes' to make get it to work. Can someone give me the code and simple instructions on where to put the code to achieve what I need? Form name= employees...

How do I make a button close the active form and open another form? Basically, I have a form with a button, that "on click" will take me to the "main form." I want that same button to also close the active form. So, how do I get a button to have two actions, close the active form and then...

I'm trying to set up filters or Rules for my email. I'm running Outlook XP. I want my 'outside' email going into my Inbox and then from there to go into appropriate folders. When I go to 'email accounts' from the Rule Wizard I only see the folders I created...not my Inbox. Without my Inbox...

I have a long Word doucment containing many pages. On various pages I have hyperlinks to documents that are located outside of the main Word document. The links to the outside Word files work fine but what I do not like what is happening is this. When I want to go back to the main Word doc...

is it possible to have a word file always open with it's custom toolbar, even if the file is opened on different pc's? i want my custom toolbar to be the only toolbar to be used and shown on my file no matter who opens or where my file is opened...is this possible. if so...please let me know...

i'm using word 2000. i have a large doc made up of section breaks; page breaks and tables. when i open the doc the cursor is at the very top of the doc; but i want the cursor to be in the center of the doc so that when i open the doc a reader will see the centered text instead of the top of...

is it possible to put a pw on Outlook. what i'm trying to do is keep others from seeing/knowing my schedual/appointments... any ideas and help is very much appreciated!!! tia c

how do I change the "licensed to" name that comes up when I start Outlook? I had to reformat my HD and after I installed my software I noticed the name comes up as "setup" instead of my name as the licensed user. any ideas as to how to change it to my name? TIA

Is it possible to have a sheet with only a certain number of rows and columns? I can get away with 'hiding' the columns but how do I get rid of the unwanted/unused rows? TIA

I want to add a combo box to a worksheet. I already have a sheet that contains the data needed when a user clicks on the combo box. How do I get the combo box to reference the sheet/cells that contain the data needed? help wasn't much help. I'm running 2000 TIA

i have a wk book that has several wk sheets. the wk sheets are identical except for the name of the months. (it's a time sheet work book/with a wk sheet for every month) the macro is needed to print the same assigned print area for each work sheet. ex: mid month i need it to print the...

How do you keep users from accessing the tables, queries and so forth. I do not want users to be able to go to 'design view', or minimize or whatever to get to the the underlying tables. Is creating a custome tool bar the only way to accomplish this? Or is there some other way? I played...

I have a command button that promts the user to enter a pw to open a form. everything works good except for one thing. when the user enters the pw, the pw is spelled out instead of in ***'s. Below is the code for the command button. What is the code to 'hide' the pw when the user enters it...