Search results for query: *

I got the Switchboard form display. I just don't know how to write the command to pull the second form for each of the button on my switchboard.

First time creating something in Accesss using the Switchboard function. I want to create three command/ button. Button 1 - Resource Question - How do I create a command in this button to pull a form that will display the resource name? Button 2 - Reports Question - How do I create a command...

I don't see anything. I have a page footer and a report footer. Could Report footer the problem?

I have a report that is group by Category. I am not sure why when I preview it, it have a blank page on every other page.

One more about expression (in conditional formatting) I have a field that have null data, and with data. I need an expression in conditional formatting that will only color the field with data. Expression - [Company] is not null?

I will have value in the date field. Example, I have the following date field; John AssignedDate - 7/1/07 Mary AssignedDate - 5/7/07 Kirk AssignedDate - 8/5/07 So my expression for my conditional formatting will highlight Krik because his assignedDate is within today's date minu 5. Would I...

Is it possible in Access to use conditional formatting with expression that used AssignedDate (one of my field) = systemDate minus 5 days. So example would be, today is 8/6, my assignedDate will be today's date minus 5 days. Anyone know the correct formula?

Thanks. It works.

I am trying to do conditional formatting in a report in access. Here are the tables: Product - contain product information (productID, Product name, category) Employee (employeeid, first name, last name, ...) EmployeeAssigned - (employeeid, EProductID, AssignedDate...) In my report, I have...

How do I mark the whole excel file Draft across the worksheet? I thought you can do that in Excel

Thanks. This works..

Sheet 1 and sheet 2 is before.. ResultGapSheet3 is after.

Sheet 1 has "a", "b", "c","y' Sheet 2 has "b", "c","z","0" ResultGapSheet3 should show "a","z", "y","0"

Let me try this again. I need to compare sheet1 and sheet 2. Then get only the difference between the two sheet and put it on ResultGapSheet3. sheet 1 sheet 2 ResultGapsheet3 a b a b c y c z z y...

If I want to identify the gaps between shee1 and sheet2 into sheet3? Is there a simpler way of formula to do this on Sheet3? [sheet 1 sheet 2 Result Gap sheet3 a b a b c y c z z y 0 0] Thanks again.

Got it. Thanks..

How do you append list 2 to list 1?

I have two sheet (Sheet1, sheet2)contain list of title. Sheet 2 have some title that are the same as sheet1. I want to combine sheet1 and sheet2 into sheet 3 deleting duplicate. Any idea how i can do that?

I got it. Thanks so much everyone. This is an awesome forum with awesome people. :)

okay.. so how come it doesn't print?? I really need help to print the gif..