Search results

Thanks very much the following syntax seems to work: SetValue Item = [Forms]![Frm-Geology].[AllowEdits] Expression= True

Hi, I have a macro which duplicates a DB record. I need to be able to unlock the DB for editing as part of the macro before duplicating. Elsewhere I have used the VB code "Me.AllowEdits = True " in a VB code event. I don't particularly want to rewrite the macro in VB so what's the equivalent...

I have just created a table from a query using "Maketable". However, when I try to open the new table, access runs a query before opening the table. I thought Maketable broke the link between the query and the new table. It is particularly frustrating since I then want to run a VBA module on...

perfect. thanks very much. John H

Hi Everyone, I'm new to VBA programming and am having difficulty writing data to a memo field in Access using VBA. I have a very simple DB with a fieldname/ fieldtype list: [ID] = autocount; [descriptor] = memo; [data ] = memo; [recordnum] = integer; [desc-number] = integer. I want to add some...