Yes, I would actually prefer to use VBA as well.
I am a little more familiar with Ruby and Python. I want to learn VBA but I seem to have no clue how to make a script play.
Here is what I am doing:
I go to Access 2010, in the "database tools" area I select the "visual Basic" icon...
I actually took a look at this about a week ago and copied the code to the best of my ability. this is the code I used:
----code below--------
Public Sub KillProperly(Killfile As String)
If Len(Dir$(Killfile)) > 0 Then
SetAttr KillFile, vbNormal
Kill KillFile
End If
End Sub
----code...
Hi everyone,
I have set up a temporary macro named "AutoExec" that outputs a predefined query to an HTML file and an excel file. These files need to be updated often so our website is as current as possible. The issue has become the annoyance of these two prompts that pop up that ask the...