Search results for query: *

excellent, thank you

xlbo, sorry for the confusion. Here is the code I tried... Sub Button1_Click() Workbooks.Open "C:\My Documents\Projects\" End Sub Here is where I get stuck. Does anyone have any solutions? Thank you.

I want it to open up the dialogue box so I can select the file

I have a command button in Excel. When I click on the button, I want it to do the same command as if I were to click on >File >Open. And I want it to automatically go to a specific folder, C:\My Documents\Projects. Does anyone have the code for this? TIA

I have 4 series of data in a bar chart. If I change the chart type to a bar/line chart, it changes the last two series to line format, and the top two series to bar format. I want the top 3 series to be a bar, and the last series to be a line. Is there an easy way to make a line formatted...

I am using Microsoft Office 2000. In an Access form, I want to email an Excel file. Here is the code I used... DoCmd.SendObject acSendNoObject, "U:\Filepath\EcxelSheet.xls", , , , , "email subject" When it runs, a new Outlook email message pops up, but no object is attached. That is because...

I am using Microsoft Office 2000. In an Access form, I wan to email an Excel file. Here is the code I used... DoCmd.SendObject acSendNoObject, "U:\Filepath\EcxelSheet.xls", , , , , "email subject" When it runs, a new Outlook email message pops up, but no object is attached. That is because...

There is only 1 option under Tools in Windows Explorer, and that is Synchronize. Any other way to accomplish this?

Is there an option in Windows 2000 that will set the default view of all the windows to Details? TIA

I ultimately want to have a scrolling marquee in an Access Form (by using an unbound textbox). I created a Page with the marquee. How can I transfer that marquee to the form? Do I insert the Page, or is there a setting I can place on the textbox to make it scroll. (I am using Access 2000) TIA

If I have 20/2/04 in a cell, and I want Excel to read it as Feb. 2, 2004. Is there a formula or setting for that? TIA

I am trying to write a formula in Excel that includes the 'search' function and the 'or' function, but I keep getting an error. Here is what I wrote... =IF(ISERROR(SEARCH(or(G3="contact", G3="contacting"))) = FALSE, 1, 0) Any suggestions? TIA

In a report, what is the formula for a conditional format. Say if my textbox value is greater than 100, how can I format the font color to be red? Unfortunatley Access 97 doesn't have conditional formatting. TIA

I tried that, and it pulled back no records. Here is what I have as my code... IIf([Forms]![frm_reports]![Text72]="View All","",[Forms]![frm_reports]![Text72]) Am I missing something?

My criteria in my query reads... [Forms]![frm_reports]![Text72] Text72 is a combobox on a form, and within the list of options in the combobox is a "Veiw All" option. How would I rewrite my criteria to say, " If Text72 = 'View All' Then the criteria field should be blank to pull back all...

In my report I want to set up a formula for a field so that if the value is greater than 1, then the font is red. I need help setting up the formula. Any suggestions? Thank you!

Thank you all. I was successful with DoCmd.RunCommand acCmdSaveRecord.

Do you mean have do I have the code DoCmd.Save, or is there another code?

How do I make a graph refresh after an field is updated. I tried in the Textbox AfterUpdate event to requery the graph, but that didnt work. Any suggestions? Thanks

FIELD is a Textbox