Search results for query: *

I am using Excel to retrieve data from excel files on the internet (This I can do). But I need to check whether a file exists before performing anything. Does anyone know how to check for the existence of an excel file on the Web, i.e. does the file...

Thanks Jeremy, I'll give it a go. And thanks for the advice on the code, I know my style isn't very good - unfortunately, my work needs me to run before I can walk, so I have to skip the fundamentals, but I am trying to find the time to learn from scratch at home. There are never enough...

I have found a kind of solution. I have changed the border style of the second form to 'None' and now it stays in the background - Result!!! Cheers, Mark

Hi Jeremy, Here is my code. First the click event for a button on the first form: Private Sub cmdCheckSecurity_Click() Set rstAgents = CurrentDb.openrecordset("tblAgentDetails") rstAgents.MoveFirst Do While Not rstAgents.EOF 'search down table for match If rstAgents(1) =...

Hi, I have an event called by a control on a form, which calculates a few things, then runs a macro. This macro opens another form and closes the first form. The problem I am experiencing is that the original event procedure doesn't finish (because the onus is on the user choosing another...

Ignore the last remark - I had surpassed all levels of stupidness, but have now come through it to a stable state of confusion. Thanks very much for all your help. Mark

Doh, that was easy!! But now I have a new problem. Nothing works on the second form except the close window button. Help!! Cheers, Mark

Hi, I am trying to move from one form to another, bringing the value in a combobox on the first form, to a textbox on the second form. This is probably a simple task, but I have been trying with no success. Any ideas? Your help is much appreciated, Mark

Hi, Please help!! I am trying to run a crosstab query, using 2 parameters taken from 2 textboxes on a form. I guess I will have to filter the records first using the parameters and then action the crosstab, but I haven't got the first clue how to!?!!?! Any ideas? Your help is much...

OK, this has been annoying me for days.... I have created a form with a calendar control on it. I have created a Macro - action(SetValue), Item: Forms![calendar].visible; expression: Not Forms![calendar].visible I have another form with the toggle button, and set the ONClick event to the Macro...

Excellent! So easy, when you know how?!?! Thank you very much, Mark

Hi, I am trying to create an excel workbook to automatically open with a form (without a worksheet behind it). At the moment I have a button on the worksheet which opens the form for me, but I am not happy with that. I've read about the workbookopen event, but where does the procedure go, and...