Thread: Run time error 3709 Access 2000 format

In the database, you should STORE the data in the appropriate data type. Then, format it as needed for presentation. This way, ordering, comparisons, etc., work as expected.

I want say beforehand that I don't use this method, however, the best way should be 'thinking to performance': 1) open recordset as ReadOnly and ForwardOnly mode: emp.Open "Select Id_empl From Empleados", cnn, adForwardOnly, adReadOnly, adCmdText 2) if you want a ComboBox use a ComboBox not a TextBox (txtnclave), then Code: Public Sub FillComboEmployed() 'open recordset emp cboEmpl.Clear Do While Not...

Also, if you are inserting into access, you may need to replace the single ticks ' with pound signs # since the values seem to be dates. Good Luck

I tried the ADO (Active X Data objects) blob version using postgres server version 8.4 (postgres ODBC client 8.04.01) with a table in two variants * table (main integer, object oid) * table (main integer, object bytea) but got back the error message: "Type lo does not exist" when executing with Set rs = cmd.Execute So, either this page is outdated or I am doing something wrong: Is there a third binary type in postgresql that...

Go to the relevant forum, in this case it's Database and Reporting: http://www.xtremevbtalk.com/forumdisplay.php?f=16 Look for the "New Thread" buttons above and below the thread list. Click it.

thanks a bunch! I know what I've done wrong now you're the man!

Terrific, Thanks for the "INSERT" insight, It's working!! Thanks for you help and patience. I did determine that if there is a field being inserted that is too large than what the field is set to recieve, truncation does not occur, no records get inserted. But I accomodated for that. Thanks again, Steve

hi i am new for this forum plz advice me how i can create a new thread?

Have you checked the samples and/or contacted their support department?

/solved solution: wrong: If rs(vFieldName).Value = Null Then correct: If IsNull(rs.Fields(vFieldName).Value) Then