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!

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

Search results for query: *

  • Users: bradles
  • Content: Threads
  • Order by date
  1. bradles

    Count current database connections?

    Hi all - have a complex app throwing error 3048 (too many databases) and I'm looking to count the database connections but haven't been able to find a way. The connections to count include all form controls (combos, listboxes and forms) and I seem to remember a long distant thread somewhere but...
  2. bradles

    Mitel & Exchange 2012 Calendar integration?

    Having trouble configuring integration in the Unified Communications Server Config > Enterprise > Calendar Integration. Mitel standard linux OS with 3300 box and Exchange 2012. The Exchange server version dropdown in the calendar integration panel only lists Exchange 2007 (should that matter?)...
  3. bradles

    Convert MDB to ACCDB in VBA

    Something I thought would be easy, but I can't find any documentation on how to do it. Anyone with an idea? Background - I'm upgrading a previous backend with multiple changes using another Access app to run update queries and table changes in a development environment. Converting to ACCDB is...
  4. bradles

    Position popup form to cover main application window

    Have tried the clsFormWindow code from http://access.mvps.org/access/forms/frm0042.htm without success: Dim frmWindow As New clsFormWindow With frmWindow .hWnd = me.hWnd .top = .Parent.top .left = .Parent.left .Width = .Parent.Width .Height =...
  5. bradles

    Find out how many connections to backend

    Hi team, I'm keen to test different front-end designs on backend connections, and specifically using a number of continuous forms compared to listviews. Anyone know how I can find out the number of connections made to a backend? Thanks Brad Stevens
  6. bradles

    Rich Text Hyperlink & Event

    Considering using a textbox formatted to rich text to display some complex data not unlike this http://blogs.msdn.com/b/access/archive/2010/07/07/power-tip-take-advantage-of-rich-text-textboxes-in-access.aspx I'd like to insert text formatted as a hyperlink (a phone number) that then calls a...
  7. bradles

    UCA Sharing contacts or uc.mdb

    Thanks for any input here. Can UCA point to the same uc.mdb database? Mitel 3300 system with Unified Communicator Advanced running on a Windows 2003 Terminal Server. All users have the need to access the same contacts while the PIM integration with Outlook fails due to the single server...
  8. bradles

    Detect other application msgbox & dialogs

    Thanks for any help on this one... Trying to find a way to detect the creation or activation of msgbox's and dialog forms created by other applications. If possible I'd prefer to do this without running a timer and checking EnumWindows, somehow raising an event when these windows appear. So...
  9. bradles

    ListView vs Bound DataGridView and memory use

    The subject says it all really, but to expand: - VB 2005 newbie from Access VBA experience - Have used a lot of ListViews in the past for good data display in grids. - Where the intention is to display data in grids without the need for editing, does anyone with experience recommend simply...
  10. bradles

    Export report pages to an image

    Haven't been able to find any info on this at all so I'm not sure it's even possible....want to export each report page to an image file, or a page to the clipboard. Anyone with ideas? Thanks
  11. bradles

    Horizontal text commandbar docked left

    Here's the need: - Commandbar docked left - Horizontal text in each control with image on the left The only options I can find to get the text horizontal is to set each control Style = msoButtonIconAndCaptionBelow or Style = msoButtonIconAndWrapCaptionBelow that forces the text to be centered...
  12. bradles

    ChartSpace ExportPicture method failure

    A tough one: Using the PivotChart view of a few forms to display some nice charts and having difficulty with the ExportPicture method of the ChartSpace object - keep getting an error: 'Run-time error 430 Class does not support Automation or does not support expected interface' This occurs at...
  13. bradles

    CommandBar button FaceIds

    A new FAQ faq705-6091 which is a small thanks to this community. I am amazed how many contribute and help here. Brad
  14. bradles

    TreeView nodes collapse when from minimized

    A VB.NET newbie using VS.NET 2005 beta 2, Developing a small app with a TreeView, minimising the main form to the system tray and finding the treeview collapsed to the top most parent when the form is maximised. Tried setting a variable to the last selected node and setting both...
  15. bradles

    Trying to draw detail box set at tallest control

    Thanks to dhookum I'm trying to implement the following code to draw boxes around the controls in the details section set at the tallest control at the On-Print event: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim lngHeight As Long 'store the height of tallest...
  16. bradles

    Clear report filter

    Must be missing something simple, Using a popup date form to return a date and hoping to filter a report's data accordingly. Now this works when opening the report and using the WhereCondition property of OpenReport, but for the life of me I can't seem to clear the report filter before adding...
  17. bradles

    Multiple print queues for network printer

    A W2KServer newbie question here: Want to provide multiple print queues to the same printer, each with different basic properties (duplex, single-side, letterhead tray). Printer is HP LaserJet 2300dn connected to the server as a network printer. I've tried adding the printer again but it just...
  18. bradles

    New record in multiple instance form's subform

    Here's the scenario: - Opening multiple instances of a form (frmMultiple) - frmMultiple contains a TabControl that controls the selection of a subform. - One of these subforms contains another subform, and it's in that I need to move to a new record. Problem: Finding the 'DoCmd.GoToRecord ...
  19. bradles

    Displaying Outlook Folder List in Access

    Hoping to incorporate parts of Outlook into an Access application, and successfully using the Outlook View Control to dispay single Outlook Folders. Is there any way to display the Folders List without having to build a TreeView?
  20. bradles

    DB Window Appears on close

    Working with a DB that has the 'Display Database Window' option unchecked in the Startup options. Unfortunately the Database Window is displayed when the DB is closing after any forms are maximized. Looks very unprofessional. No special procedures are called or used to close the DB. Any clues?

Part and Inventory Search

Back
Top