Search results

OK, thank you very much.

Hiyas I'm new to Access, but had to make one new table (inside 1 mdb) for the company. Now my question is: There are Queries for the old table. There is a new Form for my new Table. How can i make the queries to get their information from my new table, instead from the old one? May i just...

Thank you very much. Since this is only for a one-time-use performance doesnt matter. But thanks for this info too, i'll get into it for next time!

Where could i read about that append query? MOST important, would that append query, let me CHANGE the values of some fields while reading out the old table? remember, its not just copy data without changes, the data that has to be copied AND changed is: a) boolean b)listfield (previously...

I had to rewrite the mGetValue for Int and Datefields, to solve the data-conversion. to 1) its some kind of migration, some fields of the old table were Textfields, and are now Boolean fields, as example to 2) i'm actualy new to access vba, and i could not think of another way. is there a...

Thank you namliam i now changed it now to: If IsNull(rs(vFieldName).Value) Then var = "" Else var = rs(vFieldName).Value End If var = Nz(var) var = CStr(var) mGetValue = varbut now it raises a data-conversion...

'On Error GoTo myError Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim i As Integer, varSrc As Integer Dim tmp As Variant Dim chkBox As CheckBox Set db = CurrentDb ' Datenbank definieren strSQL = "SELECT * FROM " & srcDB ' Source öffnen Set rs =...

Dim db As DAO.Database Dim rs As DAO.Recordset Dim var As String var = "" I changed it to this, but problem persists. Intersting is, the error now raises at "var = rs(vFieldName).Value", previously it raised at: "mGetValue = var".

Problem with returning NULL (solved) Hi Situation: Trying to read out of a Table(Old) to set each Fields value in another Table(New) i had to write some routines to change the values. In this situation, after reading out 15 other fields, for this one it (below variable: tmp) returns NULL...

Hiyas I'm trying to save a boolean to a recordsets boolean field. But it doesnt work as i'm used to from 'normal' VB. Situation: VBA-Modul reads from one table a string value and convert this string into a boolean, now this new value should be stored in a new table. However, the line...