Search results

MySQL The remote database is MySQL. Not sure that matters though as the hangup seems to be with the Access side.

I am trying to update a remote database using the following SQL statement, it all works fine but my computer runs out off memory and I get an error saying I will not be able to rollback this update. Fine but this message must interupt the remote link or something, because the update will then...

Cool That works fine now, thanks loads, can get on with some work now. I would like to know how do I open a recordset using ADO then. Also which is better ADO or DAO (whats the difference).

I am currently running Access 2000 and would lke some help. I don't understand why one pice of code will work one place but not another. The below piece of code will work in the older legacy databases I have, but if I try and use it in a new database I've just created. I get type mismatch, and...

Background I would ideally like the form to run in the background without any interaction from myself. If I use the below bit of code Do While stopper <> 1 PauseTime = 5 ' Set duration. start = Timer ' Set start time. Do While Timer < start + PauseTime DoEvents Loop If...

Hi, Thanks for your previous help, and I'm hoping you might be able to get me out of another tricky situation. I have a table which is updated by an external program every 5 seconds or so. I am currently looking at this table using the below bit of code. Were the refreshcalldata method opens a...

Thanks loads, have been scratching my head all afternoon The second piece of code works brilliantly, the problem with the first piece of code was that it set all my text boxes to red, when I wanted some to be yellow depending on there values. Have just put an if statement in your second piece...

hopefully this makes more sense Sorry again and thanks for all your help so far. I understand looping but my big problem is refering to the text boxes on my form. Say I have text boxes Me.txtname1 Me.txtname2 Me.txtname3 Me.txtname4 ect up to 40. How do I loop through them eg dim int as...

Clarification Sorry I wasn't being very clear. I have written a query which will return about 40 records. I wish to view these records on a form and for certain records where one of the fields has a certain value I wish it to highlight itself in red. So everytime I rerun this query the...

Hi, I'm hoping somebody may be able to help. I have written the bit of code below, but I have about 40 text boxes that need to be populated, is there anyway I can loop through them. Rather than copying the below code 40 times and changing the text box name to Me.txtname2 , me.txtname3 ect...