Search results

1. This is kind of Mark's whole point of this and the utility of his code and the reason for not using the OnAction. The on Action is a global call and can only find a public method in a standard module. It would be similar to going to the immediate window and typing that method in. It will...

I did look at this template to see if there was something worth using. https://www.microsoftaccessexpert.com/Microsoft-Access-Veterinarian-Appointment-Tracking-Database.aspx and although it is not super expensive I could build something better than that in 20 minutes. That looked pretty bad, at...

See example Set myBar = CommandBars("Custom") Set myControl = myBar.Controls _ .Add(Type:=msocontrolButton) With myControl .FaceId = 2 .OnAction = "MySub" End With myBar.Visible = True .OnAction = "MySub" not .OnAction = "=MySub()"

The OnAction command should be the name of a function that is public. = "dalskiHandle" not "=Me.dalskiHandle()"

Access is different than other VBA forms. When you open a form that is modal in Access it does not stop code execution in the calling form. The code keeps on running. Other VBA forms and languages modal usually stops code execution from where it was called. So that requery happens as soon as...

FYI. One form demos saving some data to text fields and the seond form is for the attachment fields. Make sure to open the attachment demo.

As for drag and drop, Chatty says it is possible using the attachment control. I did not find that to work. So I extended the code from the linked thread that uses an Active X control (that supports drag and drop). I used a listview, but there are others...

You should be able to simply do that by pulling down the file name. Not sure how you want to have the form look but it shows all file names for every record.

By in the same position does that mean all three forms appear on the main form in their own position or you display one of the three forms in the same (one position). If it is the former do as in post #7. If the Latter it is a matter of making on single subform control and then the buttons...

So maybe I was not clear. Delete the existing ones that you can see in nav pane but not relink utility. Then re-import and you should see in both places..

I guess try and relink them as if they do not exist. Chatty says the same

I am thinking the same thing, that you might have mistakenly imported the tables not linked them.

Probably one of the most important features when debugging code especially if building your own classes is here. Probably most people have break on unhandled errors set. 1. But if you have an error handler and you get the error message you may not know exactly where that code is failing...

maybe to help debug add some print out On Error GoTo 0 Exit Sub Test_Error: Dim strMsg As String strMsg = "Error " & Err.Number & " (" & Err.Description & ") in procedure Test, line " & Erl & "." strMsg = strMsg & vbCrLf & " Topo Path File: " & strTopoPathFile strMsg =...

The JKP Treeview builds a tree dynamically from a Userform and MSForms controls. This is the best example of what you could do with a UserForm and cannot do in an Access form. See discussion...

In Access you can actually use two types of forms. The Access form and the VBA UserForm. If you make Excel applications you may be familiar with UserForms. 1. Need to add the toolbar 2. Now you should see it in the insert menu 3. There are some different things you can do with a Userform...

Not me, but here. https://www.access-programmers.co.uk/forums/threads/scramble-text.308060/

I am with Pat, this is such an overly engineered approach to do a trivial task in Access. If you did it using Access and not working around it. If you want to go this route and you are experienced in .net then you are much better off building it in .net as the front end and using either your...

Chatty is never wrong.;)

Wish I would have seen this earlier. I have a few pretty large command bars. Here is one example https://www.access-programmers.co.uk/forums/threads/access-item-genie-demo-for-organizing-tracking-your-items.333517/ It started small but I kept adding buttons. The code really became a pain to...