Search results

  1. E

    Can not open any more databases

    I have been developing a database that is now in the implementation stage. Everything is functioning very well except that after working in the database for a couple of hours, I get this message: "Can not open any more databases." I think this may be from improperly calling and closing...
  2. E

    No more databases

    I'm getting the 'can not open any more databases' error with Access 2010. This happens whenever I have about 6 forms open. I know some of my forms are pretty big, so I'd like to find some way of measuring how much each form eats up. Then perhaps, I can rework a single problem form. Is there a...
  3. E

    Deploying / installing a new database

    Single biggest thing you can do to improve form loading speed: Change your database to read-only or MDE. Takes the load time from up to several minutes down to seconds.
  4. E

    I keep getting #error when I try to use a total from a sub form on my main form

    I'm having this exact same problem with Access 2007. I want the total to appear on my main form. I know I have done this many times before, but I can't get past the #Error this time. I tried everything that Bob listed above - different names for data source and text box, nz to deal with null...
  5. E

    Steve Lebens Scroll Bar Position

    Wow! It works perfectly now! Thanks so much, because this stuff is WAY over my head. I'm just copying and pasting... :)
  6. E

    Steve Lebens Scroll Bar Position

    I used Steven Lebens code a few years ago to get and set the scroll bar position on a subform in Access 2003. Now that I've upgraded to 2007 I noticed that the code no longer does anything. There are no errors, but no results either. Looking on his site I don't see anything that talks about...
  7. E

    Switching to mac??? !!!

    Hello, My boss just switched our entire company to Mac. For now, he is allowing people to use Parallels to run non-mac software (such as CorelDraw), but he has set a timetable for eliminating Parallels as well. Of course, this will kill the Access database that runs a large portion of our...
  8. E

    Allforms collection

    AllForms is a collection that contains all forms - loaded or unloaded. Caption is only available when a form is loaded. Try the Forms collection instead - it contains only loaded forms, and the Caption property is available to it. An added benefit is that you no longer need to test your forms...
  9. E

    Form.Variables Collection?

    Thank you, Lagbolt! Exactly what I needed - works perfectly. :)
  10. E

    Form.Variables Collection?

    Is there any way to refer to a variable in a Form without literally spelling out its name - through a collection perhaps? For example: I am using a class module to handle multiple instances of a subform in the same form. Public basIF As New basItemFind '1st Instance for...
  11. E

    strange behavior

    I wonder if it could be having trouble with the space in your field name. Spaces are generally a no-no, although technically, they should work. If you renamed your field would the problem persist?
  12. E

    security

    dim blnUnlock as boolean blnUnlock = dlookup("[UnlockTrueOrFalse]","YourTable","[EmployeeName] = '" & strSystemUserName & "'") myField1.Enabled = blnUnlock myfield2.Enabled = blnUnlock The dLookup command will retrieve a value from your table. UnlockTrueOrFalse is the checkbox field in...
  13. E

    security

    I would create a table with all of your users and a checkbox for whether or not to allow acces for each user. Then on form load, check the current user against the database to determine the state of the form - locked or unlocked.
  14. E

    VBA editor won't open in 2007

    Compact didn't work but decompile did! Got everything back! Thank you, Evan
  15. E

    VBA editor won't open in 2007

    Thanks - I'll try all you say. The DB is split, but it hasn't been deployed yet - I'm the only user. Back end and front end are sitting in the same folder on my home computer.
  16. E

    VBA editor won't open in 2007

    I'm running 2007 on Win 7. So far, I'd never had a problem with database corruption with this setup. But now, I can load the DB, open all forms with code that runs in the background - but I can't goto the VBA editor. If I press F11 then Access freezes. Something must have gone corrupt - Does...
  17. E

    Slow Conditional Formatting (Datasheet)

    The dLookup function is notoriously slow when used this way. Instead, try to achieve the same results by adding fields/criteria or even a sub-query to your subform's underlying criteria. Then in your conditional formatting your expression could be something like: [NewField] = True --- rather...
  18. E

    Edit existing query by vb

    I don't think you need to create a saved query. Instead, build and then execute an SQL statement.
  19. E

    Can I Conditional Sum on a Form?

    Unbound control should work. I need to make sure I understand what you want. Is the Principal Less RefinanceAmount for a single record or for all records that match your criteria? Are BSP and ANZ the only possible entries for APLbank? I think you may want to use a ComboBox instead of a...
  20. E

    Problem using Form_BeforeInsert()

    Should you be using a Long instead of a Variant?
Top Bottom