Recent content by ChrisLomax

If you think that using this method will cut out the code and time it takes to occupy then you are wrong, it would be quicker to run a query on the form. Try using this Create your SQL query like you did before FrmName.RecordSource = SQL Query Easy You can assign the SQL dynamically if...

No, what i mean is will this method of populating an unbound form work, from what i can gather you want it to create more fields to accomodate the amount of rows in the table? Just like when you make a bound form and it creates more field depending on the amount of rows in the select query or...

Just a thought, have you got "Continuous Form" property set on the form you are trying to put the information into?

From what i can gather you have managed to put your columns of your tables into a table so that you can analyse them? Thats what i understand you have done?

Sorry, just thinking, do you only have two fields on a form? You want to replicate what access does when you put a recordset into the access properties? Im just trying to figure out how you have this laid out, i dont know if you can operate a form the same way access can manipulate a form. I...

strSQL = "Select N_APagamento, Data_APagamento, ID_Programa, ID_Medida FROM AUT_PAGAMENTO WHERE ID_Programa = '26'" That is your problem right there You are selecting only one record Change the query to strSQL = "Select N_APagamento, Data_APagamento, ID_Programa, ID_Medida FROM AUT_PAGAMENTO"

Can you not a breakpoint at the beginning of the code and step through the code until it reaches the point in which the error occurs? That way we know where the error may be happening?

To be honest i wouldnt use that command on a MySQL database, i would use a temporary table in Access and simply append all the info from the MySQL database to the temporary table? That way you are only running a query and you know queries work on MySQL databases! It is basically doing the same...

You could take a look at the DCount Function, you pass in what table and field you want to count and the WHERE query, so the WHERE query would be the table id and it would count the amount of rows in the table that correspond to that table id. Another way would be to do a DAO recordset query...

Private Sub Form_Load() Dim rst As DAO.Recordset Dim strSQL As String Dim dbs As Database Set dbs = CurrentDb strSQL = "Select N_APagamento, Data_APagamento, ID_Programa, ID_Medida FROM AUT_PAGAMENTO WHERE ID_Programa = '26'" Set rst = dbs.OpenRecordset(strSQL) rst.MoveFirst Do While Not...