Hello,
I set the Application Title by entering text in the following menu: tools --> Startup --> Application Title. How can I retrieve this Application Title via code?
Thanks,
Seth Dromgoole
What is the code to see if Outlook is open or not? I have found that running my Access code when Outlook is closed causes errors.
Thanks,
Seth Dromgoole
Payback,
My code that writes to an error log is very similar. Do trap the function name or sub routine name that errored? I couldn't spot this in your code. Also, will putting the error trap in the IsLoaded() event cascade down to all functions/routines in the form? Currently, I have the on...
Hello,
I am finalizing the error handling of an app I built. When a function or sub routine errors, I call a function that creates a new record on the ErrorLog table. I use the err.*** command to get information about the error; however, I haven't figured out a way to get the function or sub...
The problem with this method is that the controls are all combo boxes, and populating through code causes the form to load very slowly, especially when being used by field agents who have low bandwidth connections to the servers. The bound controls increase the speed of form loading.
-Seth
Hello,
I have created an access form with bound controls to a table. I want the users to be able to change the controls' values, however, I do not want the controls to automatically update the table on the form close. Rather, I want the users to click a 'Save' button to update the tables...
Skip,
Thanks for the help so far. Another question. Now I am building a macro to clear the text and controls I just pasted to the new sheet. I select a range (Rows 11-40) and clear the text. Now, I want to delete all shapes that fall in this range. How do I determine if a shape falls in...
Hello,
I have an Excel worksheet the contains a check box and text. I highlight all the text, and the check box is included in this range. I copy the selection and paste it into a different worksheet, and only the text pastes. The controls do not paste unless I put the workbook into design...
PHV,
That leads me to a question. Is updating the shared workbook basically the same as saving it? If so, I can just call the save method to update the workbook. However, I don't want to do this because as the file size grows, saving will become time consuming. Thanks for the help to this...
Hi,
Does anyone know the VB code that will allow me to specify when a shared workbook is updated? I have built an application in Excel with userforms. The workbook needs to be updated when the user(s) navigate between various forms. I realize I can do this using the ActiveWorkbook.Save...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.