Search results

  1. theKruser

    Record count of all related tables...possible?

    If at all possible, can you please help me build a crosstab query? That would be the best solution to my issue...just not sure how to accomplish it. Thanks.
  2. theKruser

    Record count of all related tables...possible?

    Thank you for your reply. What I am looking for is a "Status Page" for display of information only. I want this to be a dynamic page, so when a new Company is added, it automatically displays. Can you please throw a quick example of how you would go about this? I will tailor it to my...
  3. theKruser

    Question Code works in accdb but not in accde

    I have run into similar instances in the past. In more than one of these instances, it was due to not compiling the code before the accdb->accde conversion. Just thought I would throw that out there.
  4. theKruser

    Record count of all related tables...possible?

    I have a table that has multiple related tables. I am trying to display (in a from) the total record count of all related tables per record in the main table, but I do not know how to build the query...or if I should be using VBA. For example suppose: tblCompany -CompanyID (PK)...
  5. theKruser

    Solved Count lines of code in a VBA project?

    I am running 2007. I was getting a user defined variable type error. I just set the vars as variant and it works fine now. Thanks for the help!!
  6. theKruser

    Solved Count lines of code in a VBA project?

    @the_net_2.0 I just typed that all in and got an error. Then I saw the line that said VBA 5.3 or earlier needed. I am running 6.5. Any other ideas? @vbaInet The standard tool bar gives you the line you are on, not the total number of lines in the project including modules. Unless you know...
  7. theKruser

    Solved Count lines of code in a VBA project?

    Anyone know how to see the total number of lines of code in an Access 2007 database? I have tried CountLines() and ContOfLines() (with and without a leading '?') in the immediate window, but it errors, "Compile error: Expected: =" Any ideas?
  8. theKruser

    Tracking a login

    Bob- I know it has been a while since you posted the db above, but I am hoping you are still subscribed to this thread. I downloaded it, but when I try to open it I get an error, "Unrecognized file format." I am running Access 2007. Any ideas? Also, what is the benefit of storing/using...
  9. theKruser

    Use one form to update another...possible??

    And as usual, you have saved the day! Thank you for all of the help you give us on this forum!!
  10. theKruser

    Use one form to update another...possible??

    I am trying to refresh one form from another. I have a table (tblZ) and two forms, frmA and frmB. frmA has a command button (cmdA), an unbound list box (lstA) and a subform (sbfA). The AfterUpdate property of lstA refreshes sbfA. The OnClick property of cmdA opens frmB. frmB is a modal pop...
  11. theKruser

    Question You do not have exclusive access to the database at this time. If you proceed to make

    Unfortunately no...or I should say not yet.
  12. theKruser

    Question You do not have exclusive access to the database at this time. If you proceed to make

    I checked that. All users are set to full control. I am currently having some issues with then number of connections my computer will allow. The BE is on a external HDD on my computer and others are connecting to it. We are getting errors that say the maximum number of connections has been...
  13. theKruser

    Question You do not have exclusive access to the database at this time. If you proceed to make

    Bob- I am having the same issue. I have split my database. The BE resides on a network drive. I have it linked by the network path, not drive letter. The FE for users is an accde, while I maintain the only accdb FE. I have your Auto Updater installed (an excellent tool, by the way -- I use it...
  14. theKruser

    Copy to Clipboard?

    Of course!
  15. theKruser

    Copy to Clipboard?

    For those who are interested, here is the final fix to this issue: Dim db as DAO.Database Dim rst as DAO.Recordset Dim var as String Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM tblSubReport WHERE tblSubReport.ReportID = " & [Forms]![frmReport].[ReportID] & ";" ...
  16. theKruser

    Copy to Clipboard?

    You, sir, are a genius! Thank you so much for your help!!
  17. theKruser

    Copy to Clipboard?

    You were right. It is an autonumber. It works now. Thank you! Now, any idea how I can get it to show in a text box on the main form?
  18. theKruser

    Copy to Clipboard?

    Also, do you have any insight how I can get the results to show in a text box on the main form? I have the text box and it already fills with info from the main form...all of this is just to get the subreport results to append to what I alrady have.
  19. theKruser

    Copy to Clipboard?

    I tried your suggestion, but I still get the same error, but telling me expected 1.
  20. theKruser

    Too few parameters, Expected 1

    Bob- This thread has kind of bled into another I have open. Can you please have a look at the thread at: http://www.access-programmers.co.uk/forums/showthread.php?t=215091? Thank you, sir.
Back
Top Bottom