Search results

Thanks Solo. Yes I found the file in windows\system32. I am using Late Binding on the CDO object so I am not referencing the library. I include cdosys.dll in my installation package and place it in the same folder as the FE just in case the user's machine doesn't have it. I believe XP...

Paul, Thanks for the reply. I read over some books after posting the question and I believe if I include the .DLL file in the same folder as the FE Access will find it. Thanks

Another solution which may not be as efficient but is easy to code and guarantees that you will always get a refreshed combo box is to put the Me.myComboBox.requery on the combo boxes's Got Focus Event.

Hello, I use CDO to send emails in my Access application. I use late binding. Set objCDOMessage = CreateObject("CDO.Message") Set objCDOConfig = CreateObject("CDO.Configuration") I wanted to know if I need to provide a .DLL file with my installation package to ensure this code works on all...

Gemma, When I obfuscate my code with FMS Code tools it does the following. You may find it useful. Renames all Variables including public constants to cryptic names such as V123 Removes all comments, Removes all White space. Removes all Indents. Removes Line Continuation Chars

When I need to run Code before the application closes I open a hidden form using AutoExec Macro when my program starts. I place my code in the close event of the hidden form. It will run every time the users closes the app in any fashion.

Also make sure you don't have a circular Reference. Make sure the text box name is not First Name OR Surname.

As to your second question. I also disable the Shift Key using VBA so they can't modify the queries and tables which are still left exposed in a .mde or .accde. They can still import the queries and tables into another Access container if it's a .mde and Shift disabled. There is nothing you...

I use SageKey and it's pretty good. It's not perfect but it's good. Their customer support is excellent. You have to write your own VBA to relink the Backend when you open the application. I just finished doing that myself. There are many examples on the internet but if you have Connections...

Did you delete a form with a lot of embedded graphics?

I used the Properties in my code and it works excellent. Thanks again RX. Exactly what I was looking. If Not Left(tdf.Properties(4), 5) = "Excel" Then

Very Nice RX. ? CurrentDb.TableDefs("tblOntColSitesImport").Properties(4) Excel 8.0;HDR=YES;IMEX=2;DATABASE=C:\myTest.xls

The Hitechcoach link is good. I can look at the file suffix of the backend source and determine if it's .xls .xlsx vs .mdb .accdb. Thanks RX

Thanks for the Code RX. I am already using the If Len(tdfCurr.Connect) > 0 Then to determine if the table is linked in my code. I need a finer distinction: Is the link to an Access table or Excel spreadsheet? My current workaround is to hardcode the Excel Linked Table names in my code and...

Hello, I am writing code to Refresh table links. I only want to refresh the Access table links and ignore the Excel Table links. Is there a way to determine in VBA if the table link is pointing to an Excel file? Thank you

Hi Gemma, My commercial app is a single user app. It's a reporting and analysis tool. However, for customized ERP systems I use http://www.peterssoftware.com/aps.htm Ideally I would like to implement the same kind of FE Update with Sagekey but I am not certain it's possible. As I think...

Interesting. Even for a commercial application? Thanks Gemma.

Hi Husky, Thanks for your response. I am not too concerned with licensing right now, perhaps down the road. Right now I am only concerned about developing the most effective update FE strategy with SageKey. From my reading most people either email the new FE update to their clients, or...

Access Expert, I am going to use SageKey along with Access Runtime to create a robust installation package. From my reading about SageKey I don't see an efficient solution for automatically updating the FE. I use peterssoftware's free Application Starter for Updating my FEs...

I deleted my question and started a specific SageKey thread.