Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jdspinelli

  1. jdspinelli

    Open Internet Browser File Picker

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

    Best Choice: Event Viewer or Write your Own Event Logs

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

    VBA Project is corrupt

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

    BeginTrans / CommitTrans not working

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

    Possible Linked Table Problem

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

    Possible Linked Table Problem

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

    Use Find/Replace to Change Property Value

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

    Use Find/Replace to Change Property Value

    Thanks Duane, That is perfect! Much appreciated! Joe
  9. jdspinelli

    Use Find/Replace to Change Property Value

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

    Lock / Disable form Bound to a table

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

    Lock / Disable form Bound to a table

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

    MS Access 2007 Form positioning

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

    VBA Project is corrupt

    Thanks MajP, I will follow your links, Joe
  14. jdspinelli

    VBA Project is corrupt

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

    Preventing deletions from a combo box

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

Part and Inventory Search

Back
Top