Search results

I am working to automate an import. I have defined the import specification and it works if I run it manually but it fails when called by VBA. Public Function SelectFile(Optional ByVal sFilter As String) As String 'Microsoft Office Object Library - Reference Dim fDialog As...

I need to get a sum of columnar data from an excel spreadsheet. I can get some data but not all because I won't know which column I'm working in until run time. I have an idea of converting the numerical column reference to an letter but I'd rather just use R1C1 formatting if possible to...

This is more of a note to self / posted to assist other that may have the same problem. Setup: I have a form named "Support_Master". "Support_Master" has sub-form "subOrderSub" based on the form "Support_OrderSub". "Support_OrderSub" has a sub-form "subItemDetails" based on the form named...

I needed this but couldn't find it so I created it. I am open to suggestions to improve the code. Option Compare Database Option Explicit Public Declare Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As Long) 'Developed and tested under Access 2000 ' 'Author: Insane_ai, member Access World...

I inherited this and need to understand it. Can someone point me to a reference that explains what is being done here and why this method would be preferable over the normal object designer? I understand this creates a calender object. I don't understand being able to view the form design in...

I have a form with a subform. The subform is presented in DataSheet view so the user can edit a subset of data based on the selection of the filters employed. I have a field in the header of the subform [txtMyTotal]and a field in the footer of the Main form [txtClassTotal] to keep a total of...

:banghead: I have inherited an Access 2000 database that has a routine to change the ODBC connection from the live tables to development copies. When triggering this, the user is prompted to save the changes to the module. I have not been able to find a solution to save this change through...

I have to join multiple values into a string for summarizing data on reports and exports. This process in vba is taking up to 10 minutes to process and will get worse as the size of these reports grow. My method so far is to query the individual items into a recordset, loop through the...

This isn't related to Access but I like to share code when I come up with it. Feel free to use this. I have been downloading music from the internet but the albums come packed with the artist name and track number built into the filename. This annoys me and manually renaming files gets old...

I am gettign Error 3061 Too Few parameters, Expected=1 Dim RSH_W As DAO.Recordset strSQL_WH = "SELECT DISTINCT RPTBASE_BROKER_PRICING.CONTAINER_SIZE FROM RPTBASE_BROKER_PRICING" _ & " WHERE ((RPTBASE_BROKER_PRICING.Product_Type) = 'W')" _ & " ORDER BY...

The following code works when employed on Windows XP clients. I am upgrading to Windows 7 Professional 64 bit. I have verified the ODBC connection is working properly through the ODBC management. I get Error 3151 Private Sub Form_Load() Dim DB As DAO.Database Dim TDF As DAO.TableDef...

I have been looking for a way to build a dynamic menu item on a ribbon that shows whatever happens to be open a the time to make it easier for the users to switch between open forms and reports. I found the following that gets the job done with a few additions / considerations: The majority of...

I am glad to see this sorry POS has been killed. I am even happier that it happened right as the Taliban stated they would start their spring offensive. Way to Go US Navy SEALS team 6!

I am curious about what you (the reader) would do if you had a chance to get your hands on a hacker or virus writer. Assume you get all the time in the world to do what you want, you would not be prosecuted or suffer any negative consequence otherwise and any tool or accomodation is available...

I need clarification on how transactions work. I have read: How to use Transactions http://msdn.microsoft.com/en-us/library/bb243806(v=office.12).aspx. I understand the steps involved but I would like clarification if possible. I have a routine that updates a master price book entry that...

I have found a need for Keyword Filters to customize the Intelligent Message Filter as used with MS Exchange 2003 / IMF V2. The answer is the Custom Weighting Feature built into the V2 update. After reading the following article I designed a utility to assist in implementing this easily as...

I have had some issues triggering events as needed. I found this page on Microsoft's Office Website. http://office.microsoft.com/en-us/access/HP051867611033.aspx Knowing when events happen and what happens during these events helped me. I hope it helps you.

I have a database designed in Access 2007 with extensive VBA coding. When I compact and Repair this databse, the database crashes repeatedly without fail until I recompile the VBA code. Is anyone else having this issue? Has anyone found a MS KB article dealing with this or a patch? I have...

I have a report with two grouping levels, Customer and Trade Class. The Data source is a query called CIA_RPT_BASE. The purpose of the report is to show Current Invoice Aging by Customer then Trade Class. The Customer group has a header and footer that summarizes the totals. The Trade Class...

Here is the sample I created in respons to the above named thread for SikhSioux.