Search results for query: *

Hi, In Excel 2003 I was able to move a data point on a chart and it would automatically update the data set. I would click on the data point and the cursor would change to *up and down arrows*. I haven't been able to achieve the same function in Excel 2007. Has it been removed? Altered? Any...

I'm looking to find the VBA code required to save as PDF in Excel 2007 using the Microsoft add-in. I've been able to acheive this in Access like this: DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, Directory Does Excel 2007 have a File format simliar to "acFormatPDF"? I've tried...

Hi, I have a report in Access 2007 which I'd like to sort ascending by field generated within the report for average sales. The report is grouped by Region and then by State. The sort is going A to Z for Region and then by State like this: Midwest Illinois 74 Indiana...

Hi, I have a report 30 page report within Access. I would like to be able to automatically save each page to an individual PDF, MDI or any other commonly known viewer not having to do each one separately. Any help would be greatly appreciated. Dan

Hi, I am trying to copy and pastespecial (values) a range of cells through VBA from one workbook to another. Here is my code thus far: Private Sub copypastedata() storeno = 20 While storeno <= 20 open2007currentstore = DLookup("location", "storelocation", "store=" & storeno)...

I have a database in SQL server with multiple tables and 1 VERY large table with over 1 million records. When I try to run a query in Access it gives me a time out error. This only happens with this table. All the rest of them can open fine. A couple weeks ago I added some indexes to the table...

When I recieve some emails in Outlook the message seems to be corrupt. The same thing happens when I send emails. The receipiant gets strange characters like this...

When I recieve some emails in Outlook the message seems to be corrupt. The same thing happens when I send emails. The receipiant gets strange characters like this...

Hi, I am trying to find a way to evaluate which week of the month a date belongs to. This is for a function in Excel. I know that the weeknum function will return the week of the year but is there a way to find the week of the month? for example: 1/1/2005 is week 1 for January 2/1/2005 is...

Hi, I have a Access database with 2 tables: Supplier: PK Supplier_ID Items: PK Item_ID FK Supplier_ID I am trying to use 2 ADO controls on 1 form. I am showing the Supplier fields on the form and then the items associated with the form in a datagrid control. My problem is that the...

Hi all, I have two Dell 1703FP digital flat panel displays. I'd like to be able to connect both to my PC in order to expand my desktop (Have monitors showing different things rather than the same). What video cards out there permit multiple digital monitor support? OR if this does not exist...

Hi, I have multiple combo boxes at the top of a form which are used to filter records in the details section of the form. I have a procedure called FilterCommand which is called everytime one of the combo boxes is updated (afterupdate event) Here is the procedure:Private Sub FilterCommand()...

Hi, I have a database that keeps track of schedules. A user will select a week and will have his/her schedule for the week. I am thinking of having a tab control and having 1 tab for every day of the week. I have created a subform which has time,location,city, person, etc. I have used a...

Hi all, I'd just like some suggestions on how to go about designing the tables for this database. It is somewhat of a schedule system. I have multiple users. A user will enter a date and a form will display that date and the next 6 days (ex: if user enters 1/1/2004..it will show that and...

Good day, I am in the process of designing a database which will be used for a few user who are somewhat new to computers. I am wondering what the best way to design the tables and forms for a user to input a date. Should I have seperate fields for Day,Month,Year in the table? or have 1...

HI I have 2 subforms on a main form. All the controls on the subforms are locked and disabled by Default. I want to have an "Edit" command button on the main form to unlock and enable the controls on the subform. I have the following code for the cmdEdit: Private Sub cmdEdit_Click() On Error...

Hi, For each record on a form I have multiple prices (NYPrice, MAPrice, ALPrice, NJPrice etc). I would like to have a seperate unbound text box on the form which calculates and displays the average of these prices. Thanks in advance! Dan

Hi, I have a filter on a form. I would like to get rid of the record selector at the bottom and have a text box that displays the number of records that have been filtered and the total records. For example if the filter outputs 25 of the 600 total records I would like the text box to display...

Hi, I would like to have a filter on a text box that will automatically update the filter everytime a character is entered in the box. As well, I would like it to filter not on the whole field but any part of the field. For example..If the Product ID is "123456" and "34" is entered in the text...

Hello, I have a Combo Box which is a lookup field with 2 columns. 1 column is bound (ID) and the other is not (description). The ID is of no use to the users and since the form should be uneditable I would like to display solely the description in a text box. I have tried to create a text box...