Search results for query: *

All charts are on the same worksheet. They use different data sources. They are all the same time of line graph. Thank you!

I have multiple charts in excel and I would like to make them all of the same size. Is there an easy way of doing this without manually changing all of them?

I checked all of this. Once I set the data entry property back to No, the data re-appeared. however, it will not allow me to save any new records.

It was set to no, so i reset it to yes, and lost all of my data.

I am entering data in a subform that is based on a table, and the data does not appear in the subform after I enter it, but it appears in the associated table. Please help.

I'm sure this has a simple answer. I want to set one value in my form equal to another value in a table. I want to use VBA for this, because the data will not always come from the same table, and I want the user to be able to specify the table it should come from.

I have a field on my form called txtEnterFile. I want the user to enter the filename they wish to import to excel here. This works with the code below, however, it will only accept a file name from one area on my computer, namely, My Documents. It will not recognize a file from any other...

I have never used the TransferSpreadsheet method in any of my code, I am reviewing the syntax now from the msdn site. I think this may give me what I need. Thank you.

I have tried this. The problem is, for each record, the data will be coming from a different excel file. In addition, not all of the data that needs to be entered in the form, is in the excel spreadhseet.

I have a portion of the data that I want to enter in my access form already in an excel spreadsheet. Is there a way to have the fields on the access form automatically populates by the data in excel?

In my database, I have a field which stores a hyperlink. Is there a way, using VBA, that you can specify a specific worksheet in an excel workbook? Or is only possible to create the link to the entire workbook?

PHV- Thanks for your help. I used your suggestion, however, it now keeps what I select for each record. For exampe, if I choose option a and option b from my selection box for record 1, it remains selected for record 2. Similarly, if I change the selection in record 2 to c and b, it changes it...

I have a list box which I have set the multi-select property to simple for. I am wondering if there is any way to store the multi-selected data in a table using VBA?

I am working on this further. I will Post on Monday if I'm still stuck!

I did have the requery command in the entire time, but it still keeps the same options in cboxcourse(2nd combo box), no matter what I select in the cboxprogram (1st combo box). Thanks for trying!

When I set the rowsource for the course combo box as one of the tables, the choices stay the same no matter what is selected in the program combo box. It seems to be ignorning the after_update procedure and just using the row source for the table I chose to set it to.

All of your assumptions were correct. Sorry, if it wasn't clear... Private Sub Program_AfterUpdate() Select Case cboxProgram Case Program1 cboxCourse.RowSource = "tblProg1Courses" Case Program2 cboxCourse.RowSource = "tblProg2Courses"...

In response to Randy, yes, each set of courses are in a different table. So, that SQL statement from JJman won't work unless all of the courses are in one table, right? Thanks for all the help!

I tried your advice and i'm getting a compile error which says "data member not found" for rowsourcetype and rowsource. This is the code I used... Private Sub Program_Click() Select Case Program Case Program1 Course.RowSourceType = "Table" Course.RowSource = "Prog1Courses" Case Program2...

It is driven directly through a table.