Recent content by Tracyice

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!