Search results for query: *

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

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

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

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

For an IF Statement, what is the syntax for *like* I've tried so many combinations of: IF txtField like '*" & Me.stringField & "*' IF txtField like " & "'" & "*" & me.stringField & "*" & "'" IF txtField like " & "* &...

For an IF Statement, what is the syntax for *like* I've tried so many combinations of: IF txtField like '*" & Me.stringField & "*' IF txtField like " & "'" & "*" & me.stringField & "*" & "'" IF txtField like " & "* &...

I have a table called Remarks with a field called Remarks_text (data type--memo) which i get from an external source. Remarks_text is a log. Whenever someone writes a remark, the name and time gets stamped automatically. I also have a table called Employees. I would like to have a form or...

I have both Access 97 and 2000 on my computer. Every morning, i open up my database, delete a table and then use ODBC to import a fresh table into the database. When i use Acc97, a field called proj_id imports as a Text field. Good. When i use Acc2000, doing the same import method above, the...

hi, i am using access97. i have code that works fine on my machine and on another machine, but when i try on another users's machine, he gets 'active x component can't create object.' He has the following references checked in this order: visual basic for applications access 8.0 excel 8.0 dao...

Hi, How can i use Access to: -open an existing excel workbook, -create a new worksheet in excel and name it the current date -put all the results of an access query into that new worksheet starting in cell A2 -leave excel open so the user can see the data. Thanks!

HI, I'm using Access 2000. I have 13 columns of data and about 400 rows. We have a big plotter where all the data can fit on one large sheet of paper, but only if the data is divided into 2 separate sets of columns. So i need my data divided into: A1 thru M200 and then O2 thru AA200. In...

I am using Excel 2000. Can I create a button to automatically set some formatting changes to a spreadsheet? I'm trying to set the font size, printer and gridlines. I would also like to change the font color using an IF statement (if cell value like "*closed*" then Cell...

I created a mde database using Access 97. (it's NOT a front end/back end database). Now our department is migrating to Access 2000, but it will take about 1 month for all the users to complete the upgrade. From what i have read in these threads and on help screens, can someone verify if this...

I am using Access 97. On my form, i made a button called 'sort by project#'. But i can't get the code to sort the form. i tried: Form.SortOrderOn=true Form.SortOrder= [project_no] Form.requery But it tells me "the microsoft jet database engine does not recognize '46596' as a valid field...

I am using Access 97 and Outlook 98. I have a command button on a form that opens Outlook and begins an email message. I am trying to put a working hyperlink in the body of that email. I am also trying to turn other text red if it meets a criteria: DoCmd.SendObject , , , , , , , "Go to...

I am using Office 97. I have an Excel template called Example.xlt. From a form in my database, I want my Access database users to open the spreadsheet, but not to open the actual template. (I don't want anyone to accidentally change my template if they forget to do File, SaveAs!) In other...

I am using Access97. In my Access form, i am trying to write code to open an intranet website and go to a specific record in the website. (The intranet website requires a password.) I got this to work: Dim stAppName As String stAppName = “C:\Program Files\Internet Explorer\IEXPLORE.EXE...

i am using outlook 98. i was trying to use the rules wizard to make the following rule: when an email arrives that is addressed to a specific person, have Outlook automatically send a generic message to a third person. ex: mary sends john an email. john's rules wizard causes outlook to...

i am using outlook 98. i was trying to use the rules wizard to make the following rule: when an email arrives that is addressed to a specific person, have Outlook automatically send a generic message to a third person. ex: mary sends john an email. john's rules wizard causes outlook to...