Creating new forms in Access

[HunterN]

Hi,

I have a whole system where I created Excel Forms and extensive VB modules in Excel. There is a lot functionality that Access has (like multiple users) that I now want to try to move the forms over to Access. Is there a way to import the forms that I created in Excel to Access? Or do I have to recreate the forms over in Access from scratch?

Thanks,
Nancy

 

[boblarson]

You MIGHT be able to, but it is likely that you won't be able to. To test you can go to the VBA window in Excel, right click on your form object in the VBA Object Explorer and select EXPORT FILE. You can export to a .frm file. Then from Access VBA window, you can use IMPORT FILE and select your .frm file you saved. If it won't import it will generate a log file in the same directory as the file and you can try to see what it says and if it is helpful. I just tried importing a simple form which had a text box, a command button and one line of code and it failed with an error of:
Line 2: Property OleObjectBlob in UserForm1 could not be set. so I'm not too optimistic for you.