Recent content by kryles

Source control was the issue, I was usign the control source name and not the combo box name. hehehe

hi, I've got code to calculate shipping costs in a VB module. This code is now run from a Macro that worked perfectly before. If the user clicks "Calculate Total" on the forum then everything runs fine. If they change a qty or price, recalculate the total it fails where I assign the shipping...

Simple solution, I put the path in the Export but not the name of the file. Interesting that you must also append an '\' to the file name. Seems the dialog box doesn't add '\' after the last directory. Dim shell1 As New Shell32.Shell Dim pathToFolder As String pathToFolder...

Hi Jal, Great the Browse dialog box comes up, thanks! My only issue now it says that the object is locked when I try exporting from a query. Run-time Error '3027': Cannot update. Database or object is read-only This is the code I'm trying to use Dim qrySweep As String qrySweep =...

Hi all, I need a dialog box for Access 2000 that will allow users to choose a folder location. I googled and I read you should be able to choose this object from the Toolbox section. When I click and get the dropdown I don't see this type of object listed. Is there a file that needs to be...