Coakerb,
I looked at the link you sent. it's interesting, but doesn't mention about not being able to paste at all. If i'm in IE 6 and copy something and then open Word, the Paste option is grayed out.
Flyboytim,
thanks for the links. i'm using my dad's computer and i don't want to start...
Thanks to both of you for writing.
Cheerio,
I don't think it's a firewall problem because, in the Firewall setting for WinXP, i have the following UNchecked: 'protect my computer and network by limiting or preventing access to this computer from the internet'.
I tried enabling the firewall...
Hi Blue,
Thanks for writing. When i bought the computer, it had Word 2002 already loaded. I installed Word 2000 later.
So Word 2000 is the last version on my machine, but it still goes to Word 2002 as the default.
So unfortunately, your method won't work for me.
But thanks again for writing.
I'm using Windows XP and Office 2000.
This works:
-(No applications are open)
-Open Microsoft Word
-Open the Internet and copy a sentence
-Go to Word and paste the sentence
But this does NOT work:
-(No applications are open)
-Open Internet and copy a sentence
-Open Word and try to paste the...
I am using WinXP and i have both Microsoft Word 2002 and Microsoft Word 2000 installed.
How can i make Word 2000 the default application? (Currently Word 2002 is the default)
I went to Windows Explorer, Tools, Folder Options and clicked on the File Types tab. Then i scrolled down to DOC and...
Cathy,
i have just spent 3 hours trying to find the solution to my problem. It is now almost midnight. Finally, i came across this post.
I am using Access97, so i went to Start, Run and typed:
Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
and ALL MY PROBLEMS ARE SOLVED...
Thanks to both of you for writing and for your good advice. you both get stars!
I have a single form displaying data about the project such as the project name, dates, remarks, etc. The form also contains a subform that displays the building info. (Usually a project has 2 or 3 buildings).
So...
Greg and Richard,
Thank both of you so much for writing. Please let me apologize for not writing back sooner. i unexpectally didn't have access to a computer all week. Please forgive me.
Richard,
You made a good point about the set up of my tables and you are right, they are not set up...
hello,
i have 2 tables: one called tblProject and one called tblBuildings.
The tblProject has a primary key called projectID and other fields such as IssuedDate, Status, etc.
The tblBuildings has 2 fields: projectId and BuildName.
There is a one to many relationship with the 2 tables...
Thanks. it works!!
i made a command button on the test2.xls spreadsheet and typed the following code:
Sub Button1_Click()
Windows("test1.xls").Activate
Range("A:Z").Select
Application.CutCopyMode = False
Selection.Copy...
Thanks to both of you for writing.
it will be enough to make the code fire once, like when the spreadsheet first opens. I'm familiar with Access, but does Excel have an OnOpen event?
So the user will update test1.xls.
When he is done, he opens test2.xls and the code fires and all the...
I'm using Excel 2000.
i have 2 spreadsheets that are linked.
so in one spreadsheet, called test2.xls, cell A6 has the formula : =[test1.xls]Sheet1!$A$6
If i go to test1.xls and make cell A6 bold and yellow, i want test2.xls cell A6 to also have the same formatting.
can formatting be linked...
Thanks Daniel!
My parents are from Romania! What a small world. They grew up around Bucharest.
I can understand Romanian and i can speak a little.
(i found your bio on the RentACoder webpage).
Sorry, to clarify:
I get the runtime error if i run the code more than once. i plan on putting the code in the autoexec.bat macro so it runs everytime the user opens the database.
Daniel,
Wow. thanks!! that works.
Should i put 'on error resume next' before
Application.References.AddFromFile "path and filename"?
If not, i get a runtime error: 'name conflicts with exisitng module, project or object library'
Thanks!
Hello,
In Access97, how can i set references using code? I created a folder on the network drive called G:/MyReferences and copied MSOUTL85.OLB and EXCEL8.OLB into it.
Instead of going to each users's computer and clicking Tools, References, Browse and navigating to the G:/MyReferences...
Thanks for writing Bob.
i reallly was trying to find the syntax for *LIKE* with an IF statement since this isn't the first time i wanted to use it and got stuck.
i understand that INSTR can be used, but does anyone know the syntax of *LIKE* in an IF statement?
Thanks,
Thanks to both of you for writing!
Trendsetter:
Here is an example:
txtField="January 21, 2003 -Robert Jones -Results were due today"
stringField="jan"
Gloose,
you are sure about what you wrote above? i see there are two *s at the end and i got an error when i copied and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.