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

Good Morning: In Access 2007, Access Options you can choose the Default file format in which to save a new database, e.g., 2002-2003, 2007 etc. Once that has been chosen, how do you save that setting, without having to choose it everytime you open Access? 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...

Thanks much vise, My form was intended to be Unbound. I assigned a query as a recordSource early on and never removed it. This has been very helpful, Joe

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...

What you provided was just what I needed. I have a generic pop-up that will be a model for several other forms, so it was more for my maintenance than users. However, I can use this for other forms I have coming down the pike. I used an XML package on my last contract that let you deal with...

Thanks Duane, That is perfect! Much appreciated! Joe

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...

Hey AceMan1, I am doing very well and hope you are doing the same! Thanks for the Tag and lock notes. I will use and implement. Have a great day! Joe

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

Hello All: I wanted to add a post just to get it on record. I found the following on msdn regarding the AutoCenter and AutoResize properties Charlie and AceMan referenced. The point is, position the form in Form View and save it. Here is the link...

Thanks MajP, I will follow your links, 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...

Thanks to both of you, Gents: I will incorporate your input! Joe

Sure can provide the code (see below). I will see if I can make it work in the AfterUpdate event. many thanks, joe Private Sub cbProjNameSelect_Change() On Error GoTo ErrorHandle Dim vDispData As Variant Application.Echo False vDispData = Me.Recordset.MoveFirst With...

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...

Thanks Charlie and AceMan, I will put these changes in place and keep you posted. VERY MUCH appreciated! Thanks to both of you, Joe

Hey AceMan1, I'm doing great, thanks! I hope you are well? It would seem that AutoCenter isnt' working. I have it set to "Yes", yet the form opens full screen anchored to the top and left borders. Are there other properties I should be checking? Thanks for your time!

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...