Search results for query: *

Hello All, I am aware of the Application.FileDialog(msoFileDialogFilePicker) for opening Windows Explorer and choosing a file name to be passed back to the application. Is there a similar object/method for opening an Internet Browser with the intention of selecting the URL to be passed back to...

Good Morning: Can anyone share their experience on whether it is better to use Windows Event Viewer utility or write your own event log? I need to choose one or the other in maintaining an Access 2007 database. Thanks in advance, Joe

Hello All, I have BeginTrans and CommitTrans wrapped around inserts to several tables - five to be exact. These tables are linked through Linked Table Manager. However, I cannot get the inserts to work even though I see thru debugging that the CommitTrans statement proceses (it doesn't error...

Good Morning: Can anyone point me in the right direction? I have a linked table that had two columns (both booleans) that I no longer needed. I deleted the columns from the table and, upon opening a form that used that table, Access asked me for a parameter in the format...

Good Afternoon Everyone: Can anyone out there tell me if there is a way to change Property Values using Find/Replace? For instance, I have about 10 text boxes named, "txt01", "txt02", "txt03", etc. I want to change them to "txtTest01", "txtTest02", "txtTest03". Is there a way to search...

Good Morning: I have a form bound to a table. A combo box is used to select a record. If a record is not selected, I want to lock/disable the controls on the form until a record is selected. What is the best Event Property to base the Disable/Enable logic on? Thanks Joe

Good morning: Let me start by saying this website has been most helpful - I appreciate the moderators and contributors. When opening my most recent .accdb file this morning, I was informed that the code was corrupt with the following message: < The database cannot be opened because the VBA...

Good Morning: I have a bound form for editing data. An unbound combo box is available for the user to choose a record. The intent is for the user to select from the combo box values and immediately move to the record in the underlying table. I have accomplished this using the Change event...

Hello: I am searching for a way to center forms in MS Access 2007. The VB6 way of setting the same property was "Startup Position" = 1 'Center Owner. I am aware of the AutoCenter, AutoResize and FitToScreen properties in Access 2007. I have AutoCenter set to "Yes", AutoResize set to "Yes" and...