Search results

  1. C

    Yet another Print Preview Ribbon problem

    Running full-version Office 365, I hide the default ribbon with ChangeProperty "AllowFullMenus", DB_Boolean, False and I'm left with just the Home and File commands in the ribbon. That's good except when the user opens a report (all reports are set to open in Print Preview mode via code). In the...
  2. C

    A long time ago, in a galaxy far away

    Someone used a table-level lookup so multiple records could be selected for a single record in the main table. In this case, the main table is composed of tasks and the related table contains users. I put an active/inactive boolean in the user table and it's easy enough to prevent the selection...
  3. C

    Puzzle Challenge - How to collapse records

    This is an oddball. I have to import 255 fields (1 record) from an Excel spreadsheet. So, naturally, I used the docmd.TransferSpreadsheet command. I've used it many times in the past, but never for more than 20 fields or so. With this many fields, it failed, usually around column 117 and/or...
  4. C

    Application Slows down during user sessions

    Running a split FE/BE application where the BE is on a storage server and each user has a local copy of the FE. It's a complicated app for estimating jobs with large tables. I've done what I can to minimize bloat and turned off transactions in all action queries as well as moving most SQL in...
  5. C

    Is the Me. syntax required in form vba when referring to controls?

    I just inherited another developer's database and noticed tons of code behind forms where he doesn't use me. to refer to the control, just its name. So, for example: He uses statements such as txtAgentID= rather than me.txtAgentID when referring to a control called txtAgentID on the form with...
  6. C

    Desperate: Need replacement for Sagekey installation wizard

    I deploy my access-based application using Sagekey's wizard (2013 edition). Now, they're leaving the business. I distribute both 32-bit and 64-bit versions of my "application", compiled on different machines having Office 32-bit and 64-bit, respectively. The problem is that Sagekey is leaving...
  7. C

    After 25 years, just noticed something: DSum will multiply fields

    Posting this just in case others haven't noticed this. On a lark, I tried it and it worked! Me.txtConsumeCost = DSum("[cost]*[AmountUsed]", "qryfrmProposalWiz05Sub0400Parent")
  8. C

    Determine highlighted (not selected) row (listindex) in a listbox or contents

    Ok, I thought I was a pretty good coder, but this one has me stumped and wondering if anyone can help with an obscure/arcane thing. I have a listbox on a form. When I select an item in the list, I understand how to retrieve anything needed. But I found that if I select and item, and then hold...
  9. C

    Database Number of Objects Limit Problem

    Hi, this one has me stumped. I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new...
  10. C

    Passing "*" (all) to a query or optionally a value - from code

    Hi again, I read somewhere that it's difficult to pass "null" to a parameterized query when basing the parameter on a form control. I'd like to do that if possible, but I have a different, almost opposite, question. I have a query I'd like to reuse as much as possible based on multiple "where"...
  11. C

    Mastering complexity - this one is escaping me

    Hi all, I'm hoping one you CodingMeisters can help me out. I've got a very complex form going that updates MS charts based on user selections of a frame control (3) options, a treeview control (free download from http://www.jkp-ads.com/ and very nice all-code control solution) having 5 nodes (5...
  12. C

    Mastering complex queries including transform

    Hi all, I'm hoping one you SQLMeisters can help me out. I've got a very complex form going that updates MS charts based on user selections of a frame control (3) options, a treeview control (free download from http://www.jkp-ads.com/ and very nice all-code control solution) having 5 nodes (5...
  13. C

    This one stumps me, not sure how to classify the question

    Hi all, I have a very large Access application and use a hidden "main switchboard" to store data such as the current customer ID. Prior to the advent of tempvars, I embedded a key control into many query's underlying combo boxes, list boxes and forms criteria: "Forms![main...
  14. C

    Win 8 and Shell Command issues

    I hate Windows 8, but have to deal with it. Please let me know if you have any solution to this problem. I have a mobile inspections App (Access 2010) that allows users to perform inspections and then synchronize the records to a remote data file when they have a network connection. The app...
  15. C

    Excel Automation - output a formatted spreadsheet from Access 2010

    This sample database shows how to output a multi-sheet, formatted Excel workbook. It also shows how to read in new data and update existing data via the spreadsheet. It's too big to upload so you can download from our developer's page here...
  16. C

    Move multiple attachments from one table to another

    This sample database allows one to move attachments from one table to another and will handle multiple attachments. I could not upload the database, so I posted it here: http://www.informedcorp.com/Access-Development-developers-page.html It's the second sample down, called "Data Mover".
  17. C

    Code to "append" data from one table to another with attachment fields.

    I've seen many postings on the issue of Access not allowing an append query from one table to another when the query contains an attachment field. I distribute a back-end/front-end solution and this made it impossible to enable this "feature" for our users since it makes it a mess when it comes...
  18. C

    Greetings from New Hampshire, USA

    Hi All, Thanks to all of you who take the time to post answers and sample databases! I've been developing and selling and application for environmental services departments for 20 years now. Up to two years ago I had a "day job" as a mechanical engineer and finally made the move to full-time...
Top Bottom