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 bkrike 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: Du2good
  • Content: Threads
  • Order by date
  1. Du2good

    Subquery One Table Multiple Fields

    Still learning about subquery design. I've been researching this, and have gotten to this point, unfortunately still have much to learn about this subject Trying to get count of Acc grouped by Stats that have a balance > 0 and count of Acc grouped by Stats that have a balance <= 0 in the same...
  2. Du2good

    Determine Max Age of Unresolved Items For Last 30 Dys

    Can I get this? MyTable has items [ItemID] added to it daily [ReceivedDt]. ItemID's may be resolved [ResolvedDt], on or after the [ReceivedDT]. Looking at the unresolved items, can I find out what the oldest item was, that was not yet been resolved, for each day there was an item that was...
  3. Du2good

    If Then Fails Comparing String Variable With Text (Access 03 to 2010)

    I've assembled many Access 2003 db's on Windows XP. They all perform a multitude of If Thens that are used to compare string variables such as strRptNm with "ChargeOffs". If strRptNm = "ChargeOffs" Then End if Converting the db to 2010 is causing the If Then to fail. I can rewrite the code, and...
  4. Du2good

    A fix for truncating memo field to 255 ?

    Hi everyone, I'm using Access 2003, Excel 2003, and Word 2003. Trying to export a table or query or transfer a spreadsheet to Excel that has a memo field with greater than 255 characters. The plan is to use the spreadsheet as a merge data source. Searched for past 3 days, found multiple posts...
  5. Du2good

    Capture Name of Sub From Within the Sub

    I want to track some(not all) of the buttons the users are using. For instance if a user clicks Private Sub cmdAffidavit_Click(), I'd like to be able to call a function that will return the name of the event. Currently I've added a line of code to each event, that is the name of the event...
  6. Du2good

    Best practice to overcome recordset locking?

    Backend table has 100K plus records. Five instances of the FE will be editing 50K of the records, 10K for each instance, one record at a time. The problem is that record locking is preventing editing of some of the records. Some how I want to be able to update any record with out running into...
  7. Du2good

    Close db but don’t quit Access

    Is there code that can be used with a button that will close the db but leave Access open, something that maybe will close the database window, instead of hiding it? I have user level security applied to several db using same workgroup with Access 2003. Problem is that I'm frequently exiting...
  8. Du2good

    Shell Multiple 2003.mdbs With Password

    Need suggestions on best method to open and logon to multiple db's automatically, at any time of day, that have user level security applied which requires a name and password be supplied at open. Five different mdbs open at different times automatically. The dbs are started between 3:00 AM to...
  9. Du2good

    Export Cutom ToolBar To Multiple mdb

    I've created a new custom toolbar named dbwCustom1. I would like to export/import or recreate this toolbar in multiple (30) other mdb's. After creating this toolbar once, I'd like to not have to recreate it step by step in each db. Is there a fairly simple method of doing this? For now I'm...
  10. Du2good

    Variable for defining rst field

    I’ve a table with 90 different fields named grp00, grp01, grp02, grp03, etc. The table has one field for the report date (RptDt) and one field for operator ID’s. Each day I need to update the count of records for each group for each operator ID. I was hoping to update the table by using a...
  11. Du2good

    Control Linked Workbooks Using Combo Box

    Have several workbooks and want to link all of them to a master. The master would have a combo box that is linked to a different workbook to select which OpID (individual’s) data to view. When a change is made to the combo box OpId, the master would show data from the linked workbooks for that...
  12. Du2good

    Using variable in Dcount

    I'd like to be able to replace [4d] with the variable DeclineCd in this DCount but havent got it yet. Maybe its not possible? What should I do different. Thanks!! This works: Closed = DCount("[Account #]", "tblEOMRpt", " [4D] = -1 AND [Rep] = '" & REP & "' ") This doesnt work and it returns...
  13. Du2good

    Pass query result DateMax to variable

    I have the SQL below that will provide the MaxOfRptDt for a Report. SELECT tblReportDates.Report, tblReportDates.Action, Max(tblReportDates.RptDt) AS MaxOfRptDt FROM tblReportDates GROUP BY tblReportDates.Report, tblReportDates.Action HAVING (((tblReportDates.Report) Like "*CSH06") AND...
  14. Du2good

    SendKeys To Copy Pivot Table View and Paste Into Excel

    Boss wants two reports on same Excel tab. 1st report works great and is saved to Excel using: DoCmd.OutputTo acOutputQuery, "qryIncoming", "MicrosoftExcelBiff8(*.xls)", "X:\Incoming Daily.xls", False, "", 0 2nd report is a query in PIVOT TABLE VIEW. Since pivot tables wont export without...
  15. Du2good

    Another Passing Variable To SQL Question

    I’ve read many of the posts from gurus PHV, RoyVidar, REmou and many others but have yet to understand a few basics in passing variables in SQL. Where is some straightforward and simple info for how to pass the var and the why of the method(s) that are required. So, how do I get the code to...

Part and Inventory Search

Back
Top