Search results

Looking for a bit of short cut code if anyone has it. I have to do some tricky automatic form building stuff. I need to duplicate a number of controls on a form. They are all acCommandButton types, but they have different images, sizes etc. Anyway, my thought process was if I have a...

I have found some code that works. I thought I would post it so that if anyone has the same problem this workaround could work for you... This is not my code...:) Function SaveBinaryDataTextStream(FileName, ByteArray) 'Create FileSystemObject object Dim FS: Set FS =...

I have an issue, I think I have a work around, but I am struggling... Firstly, I have a SQL 2012 database which has a table holding some images. These images have to be stored in the database (as we are using them in Android devices as well as Access) and so I cannot use paths to the images...

I like this! I will give this a go tonight... Thanks for the lateral thinking!:D

The issue is the number of columns really could be n. For example, I have a cross tab query that converts contents in to table column headings. Using my earlier function it means that regardless of how many items are in this column the form is generated and it works. Normally it is running at...

I like your database, however it does put a limitation on the number of fields. I have come up with a work around that does work in Runtime, but the form created cannot be renamed. It is not the end of the world for me, but for anyone else who create a form at runtime and wants the user to be...

If your database is form driven (and most are) then just put some code on the Form_Unload event. This will prevent anyone closing the main database screen or the form. Private Sub Form_Unload(Cancel As Integer) If MsgBox("Are you sure you want to quit this application?", vbYesNo +...

I thought that initially to, but when I tested it the Application.CreateForm works. The Docmd.DeleteObject works. The Application.CreateControl works. All of which are database objects that are being created or destroyed within the RunTime environment. Why the Docmd.Rename command does not...

Hi Not sure if anyone can shed any light on why I have this problem. I have a function that creates a form dynamically to enable the end use to edit the table (or query) contents. For example, if I have a table called Activities. By calling this function it will create a form with the fields...