Search results for query: *

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

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?

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

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.

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 took over this website and the developer before me created this content_print.css. When I go to the website it is only printing the content of the website. How do I modify the code or get rid of this print.css so that when I go to the website, and hit print, it prints exactly like the website...

I have an excel with the following information Name 1, 2, 3, 4 (in row) and Quarter 1,2,3,4 (in Column). I want to create a graph that will show Name 1 with Quarter 1,2,3,4 result on the x axis. Name 2 with Quarter 1,2,3,4 result on the x axis. Name 3 with Quarter 1,2,3,4 result on the x...

Hi, I will be creating a front end access database (which I have no clue yet) but one of the requirement is to keep the historical data of one field. Is it possible? How? Any suggestion?

Anyone know how or why when there is an checkbox on the worksheet it does not show the Object name in the Visual Basic Editor? Bascially, there is several checkboxs on the worksheet but when I look at the VB Editor, there is no object listed? Why?

I have an excel sheet and currently the user can check both the No and Yes Check box. I want to disable one or the other if I check Yes then I should not be able to check no. Any ideas? Thanks

Anyone know the code for to add. I have a form and it display user information and within that form, I have a Seminar subform with display any seminar they have attended. I have an update seminar command button. Once I click on this button, it brings up a form that display all the seminars. So...

I have a form with that display the name of the Attendee and their information. I also created a command button that is call ClassTaken. Not all the attendee have taken a class. So, on the form view, if I click on the Classtaken, i want it to take me to another form that list the class that...

Is it possible to save a Crystal Report as a MS Word document and be editable?

Hi, I am not an expert in Access and I am working on an access database now but got stuck. I have a code for my search command but it does not seem to work. How do I troubleshoot it.. Here is the problem: When I type the partial UserID, it does nothing.It didn't give me my message. But when I...

Anyone know the swl syntax for check a null date field.. I have a begin date that have data and I have an end date that is blank.. What is the syntax to check for the end date field ?

I need help with creating a report to show the list of Request number per Owner with the list of payment that needs to be charge. I have the report created by could not figure out how to get the amount to display correctly... Owner name Request number Date completed Description of work amount...

I still don't get this group footer and group header. It's driving me nuts with my report. I have a report that I want to display the list of amount on my group header and is only displaying my last record.. When I display it on my group footer, it is displaying my first record.. What can I do...