Search results

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.

Thanks for your responses. I managed to achieve what I wanted. Here is an example from one of the reports in the report's On Open Event. If Me.CurrentView = gintCurrentViewPreview Then 'Can't use OpenReport constants here because CurrentView has different constants...

You can set conditional formatting in the Open Event in any view. I tried the below code but it always makes the control red? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Registered = False Then Me.WasteClass.ForeColor = RGB(255, 0, 0)...