Search results

What about when I import the excel file with the conditional formatting. It will not bring over the formats will it?

But I would not be able to export a report to excel correct?

Hi All, Is there a way to use conditional formatting within a query in 2007? I found the conditional formatting icon in the settings, but it won't let me use it. Please help. I have to present this to my boss in 2 hrs. Thanks!

Good Morning- Here is a quick and dirty of what I am trying to do. I need the email macro to skip over part # C because there are no records to send.

This is how I wrote it and it brings up the second vendor with a blank query and still goes to the email function. DoCmd.ApplyFilter "", "[Confirmed Email Query]![Vendor Name]=""A B Chance CO""" ' AB CHANCE If DCount("*", "[Confirmed Email Query]") > 0 Then DoCmd.SendObject...

I tried the string above, but it is not skipping the email function of the command. I need to skip those if there are no records within the query.

Below is a piece of my macro that I converted to VB. Can someone tell me what I can add to this information to make the macro "skip" the email if the query that I am trying to send is blank? '------------------------------------------------------------ ' CONFIRMED_EMAIL_MACRO '...

Hi All, I need some serious help. I have an excel file that I update constantly. When I bring a new file into access twice a week, I move the old one to a make table called "Expedite Raw Old". Then when I bring in the new table, I call it "Expedite Raw". What I need to do is lookup a PO # in...

WEWT!!!! That worked!! Thank you soooo much for you help on this. I went to the library and got a book on vba so I can learn about what it is doing. Thanks again for your help.

Hi Byte, I finally got my laptop back and I was working on this code. Public Sub MultiQueryExportToExcel ("C:\Documents and Settings\Windows User\Desktop\Expedite Access.xlsx" ByVal sFilename As String, _ ParamArray arrQueryName() As Variant) This portion of the code is giving me...

Thank you very much for your assistance.

Hello: I have created this code, but I need to change it to multiple sheets and don't know how. Can someone please offer a little assistance? '------------------------------------------------------------ ' Export_To_Excel ' '------------------------------------------------------------...

Did you ever get this fixed? I was having lots of errors with Access 2007 through parallels. I used bootcamp and installed windows on a partition on my mac. Then I installed office 2007 in windows native environment and now it is working perfectly.

I fixed the errors. It is working now.

I moved all my info to Windows native and ran all the updates possible, but still getting the error. I have stopped using the virtual machine because of the other issue. Would it be better to just create an excel spreadsheet, drop all my data into that and then have the pivot table refresh...

Is anyone else having problems with Access 2007 crashing when creating a pivot table? I try to create the pivot, and it creates, but it says the details can't be displayed and then it crashes. Can someone tell me if they have had this problem in the past and how to fix it? Could it...

Ok I finally figured out why it was not working for me. First I was running Windows on Parallels through my mac. I created a partition using bootcamp, installed windows xp on the partition, then reinstalled Office 2007 there. I tried doing the service pack 3 updated, but that didn't work (I...

Looks like I am missing service pack 3. I am going to update and see what happens. I will let you know. :)

Did you use the exact same expression as my original post? I put it where you have it and it is still giving me the same error. Undefined expression 'Year' in function. Could I be missing a reference table in VB?

Thank you so much for your help! I really appreciate it. I have been working on this one issue for many hours.