Search results

I tried this code to test but getting compile error:

Deleting a module in remote database using vba is working using this code : Dim objAcc As Access.Application Set objAcc = GetObject("\\grh503\Electronics\database_programs\z_rest_of_em\tools\golive\GoLive.accdb") objAcc.DoCmd.DeleteObject acModule, "tools-for_all_db_123" objAcc.Application.Quit...

Thank you for the help guys! I did use the query method that plog suggested.

Starting with the report wizard I created a quarterly report. I was able to get it to show the groups displayed as the right quarter...so Q1 is april to june. The issue I have now is that the annual total is showing as the sum of would be quarters starting in Jan. I suspect the issue is with...

Can runtime be installed on a machine with office installed sans the access part?

Do I need to install access runtime (ie AccessRuntime_x64_en-us.exe) on all pc's I run "my_access_db_app.accde" on?

You need to add the "Maximum" function in a module. Function Maximum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim i As Integer Dim currentVal As Variant ' Set the variable currentVal equal to the array of values. currentVal = FieldArray(0) ' Cycle through each...

This solution worked beautifully for me. Thank you!

I am a "light" user of ms access, developing tools for tracking repairs and parts for our shop guys that maintain radiation therapy equipment in a cancer centre in Kitchener Ontario. I have benefited greatly from this forum and hopefully will also contribute. Thanks, John.