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 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: *

  1. dhookom

    Apply Filter

    A simple pivot table results in this:
  2. dhookom

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I think you will need to rely on someone else. I'm packing for a two-week holiday without a laptop.
  3. dhookom

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    That makes more sense now with the image. My method would be brute-force VBA to loop through the values in each column and check values against other columns. Someone might have a much more efficient solution. Being a database developer, I might append the data values to a table that has the...
  4. dhookom

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    There are others who I expect will be able to assist but it would us if you actually highlighted in your screenshot some duplicates.
  5. dhookom

    Please help with my access report

    Since you expect to have a Page of Pages for each committee, you may need to use a solution like the Northwind 2 Developers template Catalog Report. There is a brief discussion on this page that gives a high level overview.
  6. dhookom

    Please help with my access report

    Each answer so far assumes a completely different result/expectation from what I understand from your post. Please provide more direction with enough examples to assure we understand.
  7. dhookom

    Pulling Minimum Lengths

    You never said why you think the expression didn’t seem to work or provide examples. Most of us recommend three separate fields for City, State, and Zip. Maybe you have no control over this.
  8. dhookom

    Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less

    I won't begin to try understand your queries but can suggest you make sure you have the significant fields indexed.
  9. dhookom

    vba hangs

    I would first check if a printer has been designated as the default in Windows and that printer is on line. Next I would try another printer such as the MS print to PDF. Then try temporarily disabling your antivirus software.
  10. dhookom

    Query expression negative to a 0

    This question is cross posted in Access World Forums and the suggestions there are much the same as here The OP has already been informed about the issues we have with cross posting so no need to comment about it. The threads in the other forum are up to 79 posts of advice to use VBA.
  11. dhookom

    Query expression negative to a 0

    Create a small user-defined function that accepts the field values as arguments and returns the appropriate value. You can encapsulate this logic to use anywhere in your application and include comments in the code. It’s easier to debug than a complex expression. When the 25,727 changes, just...
  12. dhookom

    Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.

    I would change the code to the following which will possibly show no value for dSelectDate Dim rs As DAO.Recordset Dim sql As String Dim numberOfBD As Integer Dim sList As String sql = "Select * from qryBirthdayList Where Birthday = " & Format(dSelectDate, "dd") & " and Birthmonth = " &...
  13. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    Great!
  14. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    I would next check to see if an antivirus software is running.
  15. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    What else did you try?
  16. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    I’m just throwing stuff at the wall to see if anything sticks. Did you check out the bugs page?
  17. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    Is there any code running when the application opens? Do you have a default printer identified in Windows? Some developers recommend keeping a table open in the back-end while the application is running. You might want to check the Access Forever page which has the most up-to-date list of...
  18. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    I don’t do anything else until the compile errors are fixed. I hope your application is split so you can make updates to a copy of the front end file. “Find” error would occur if you are attempting this against a linked table. There also could be an issue with the references and DAO vs ADO. Find...
  19. dhookom

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    Does your code compile?
  20. dhookom

    Select X of each variation of a field

    No sample data? No desired output? That's not much to go on. Typically I would create a calculated column that sequentially numbers records within a VERSION and then select all records with the sequence number less than or equal to X.

Part and Inventory Search

Back
Top