Recent content by MontyBurns

i'd probably add a macro to the xls file which ran on opening the file, which gets the data from the Access DB and updates the spreadsheet, rather than pushing data into the spreadsheet from the Access DB. Saying that, I have found documentation on the Excel object model etc very hard to find...

Hi, I haven't been using Access for a few months so I imagine what i'm asking is really basic, but I can't seem to figure it out all the same. I have a main form with a subform, and also a separate filter form. The filter form opens the main form with a filter based on the subform (maybe the...

ta muchly, Jemminger. Monty

thanks for the tips. I've never really known how to debug JS apart from using alert etc. It tends tp p!ss me off when I choose to debug, enter Interdev and then not know what i'm doing! It also p!sses me off that when you close that instance of Interdev it closes the browser window that you...

i've managed to figure it out myself - it doesn't look too pretty, but it works! combos(counter).options[combos(counter).selectedIndex].text Thanks for putting me on the right road Max. Monty

Max - i'm getting the following error: 'options' is null or not an object Any ideas? Thanks for the reply, Monty

Hi, I have some combos which are being dynamically added to the page (i.e. multiple dependent combos) and I never know how many might be on the page. All is working fine, except I need to get the actual text of each selected option, for each combo that exists on the page. I'm almost there - I...

thanks. Finally found a good article on managing multiple instances of forms. Haven't applied any of it as yet, but it looks like it should help. http://users.bigpond.net.au/abrowne1/ser-35.html Burns

Hi, I have a subform (frmSubFiles) with some code which does a recordcount and updates a txtbox on the parent form (frmIFLR). Private Sub Form_Current() Dim intIFLRid As Long If Not IsNull(Forms!frmIFLR.IFLRid) Then intIFLRid = Forms!frmIFLR.IFLRid Else...

how embarrassing. I have answered my own question... It was due to me declaring the form instance variable as Private (Dim-ing it) rather than Public, in a Module. Doh. I do have a problem which is pretty much spot on to what my initial question was, but i'll do another post. Burns

I seem to be (almost) answering my own question here - apologies. I seem to have narrowed the problem down to Access 2k. Even this simple code on a fresh form with one command button works in 97, and yet doesn't work with 2k. Private Sub Command0_Click() Dim frmTest As New Form_frmTest Set...

sorry, that was actually the Form_Current event which is firing on the subform, not OnOpen. Burns

Hi, I know how easy it is to open another instance of the current form, but... I have a subform on my form, which in it's OnOpen event fires some code to update a textbox on the parent form (recordcount). How do I code so the OnOpen code in the subform knows which instance of the parent form...

Hi, I need to return only those records where the contents of field1 is contained in field2. Eg. Field1 1234 Field2 \\svr\share\folder\1234.pdf It'll be something like: SELECT * FROM tblMyTable WHERE Field2 Like *Field1* But this doesn't work. Any ideas anyone? Thanks, Burns

Hi, A bit of an urgent one unfortunately... 10 days ago I released a new version of a frontend DB, and forgot to update the linked-table links. The copy of the backend DB I was using for development was very much out of date. This means that an out of date copy of the DB has been receiving...