Search results

Hi to all, I have two tables with the same fields: Table1: Name, Date, Value Table2: Name, Date, Value They have some combinations of the fields Name and Date that are the same, example: Table1: Jonh, 2010-05-01, 2 Table2: Jonh, 2010-05-01, 1 I wanted to insert in Table1 the combinations...

Can anyone please shed some light on this issue? Would the following be sufficient to close the recordset? Dim DataSet as DAO.Recordset Do While Not DataSet.EOF Loop DataSet.MovePrevious DataSet.Close Set DataSet = Nothing

Hi, I'm relatively new to Databases and have been working on some projects. I have a doubt of what methods are more appropriate when updating or inserting data in a table. Here are the two methods that i use. 1. Open e snapshot recordset, calculate things and insert or update with sql the...

Thanks DCrake for your suggestion. I was setting it to nothing. I have never realized that it wouldn't be possible to close a recordset that was EOF or BOF. Does it stay in memory ? A curious thing is that this particular recordset is on EOF when i try to close it and it solved my problem. My...

I have found the problem, and it was a simple one, i wasn't closing a recordset and it slowed things down a lot. Thank you for your help.

PNGBill Thank you for your reply. In fact after my code runs i get a 35mb database. If i compact and repair, without deleting anything (temporary created tables etc) it goes to 3mb. I cannot understand what is cluttering the database.

Hi to all, I have a report that is based on some temporary created tables. The report has a subform and a chart along with some textboxes. My problem is that the report is incredible slow on clicking the next page arrow (showing the message "Formatting Page, press Ctrl+Break to stop...") or...

datAdrenaline Thank you very much, the problem is solved, that was it. Regards

First of all, hi to everyone here on the forum and thanks in advance for any help. I'm having troubles with a query that works fine on the Query section of Access but prompts an error when executed in VBA. The error is: Run-time error '3141' The SELECT statement includes a reserved word or an...