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 derfloh 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. planetdrouin

    Using an array and looking for a substring

    I am trying to write an array formula which also looks for a substring. Essentially one of my data fields could contain "john 2003-4" I want to be able to say look for "2003-4" in that column. My other parts were fine such as matching the date and using the first 5 letters...
  2. planetdrouin

    Trying to filter a list with subdirectories

    Thanks for the quick reply. Currently I don't have any direct method of determining a difference between a directory and a sub directory. However, by definition, if a category is a directory, then no category with the same numerical prefix but with more numbers will exist. For instance...
  3. planetdrouin

    Can my code be speeded up?

    Have you deselected all the 'Name AutoCorrect' check boxes which is found under 'Options' then the 'General' tab. By doing this, you will greatly improve the speed of your app. Lawrence
  4. planetdrouin

    Trying to filter a list with subdirectories

    I have a table which contains a list of categories which looks like: Category ID Category Name 11 Cash 111 Petty Cash 12 Bank Account 121 Citibank 122 Wells Fargo 21 Utilities 211 Telephone 2111 SBC 2111...
  5. planetdrouin

    Trying to populate an unbound continious form

    On more thing, my form is in datasheet and not continuous (I wish I would check my spelling a little more often) view.
  6. planetdrouin

    Trying to populate an unbound continious form

    My code correctly populates each of the unbound controls on the first record, but each subsequent record has the same data as the first. I am rather new to programming, so I am must be missing something rather simple (I hope). My code looks like: Private Sub Form_Load() Dim intX As Integer...
  7. planetdrouin

    Getting no read permission error despite...

    Hello, I am trying to implement code from here to check FE version and to update it if necessary. The two threads for the code are faq705-2010 and faq705-1971 . My problem is arising when I try to set the recordsets. I get a run time error 3112, which is 'records cannot be read; no read...
  8. planetdrouin

    I am trying to sum but duplicates are a problem

    Hello, I have a query which essentially brings in two tables. They are TblInvoices and TblReceipts. Both tables look like (with some other fields): Date InvoiceID ClientID Amount However, the InvoiceID is unique in TblInvoices but not in TblReceipts as some customers pay in multiple...
  9. planetdrouin

    Sum by fiscal quarter

    Jeff, Sorry I haven't gotten back to you sooner, but have been out on the road. Your reply was extremely helpful and works like a charm. I agree about the date, my field was actually named [InvoiceDate], just being lazy in my question. Lawrence
  10. planetdrouin

    Sum by fiscal quarter

    Hello, I am relatively new to Access, so... I have a transaction table, that has a date, description, transaction category and amount. I want to sum the transactions by fiscal quarter and year, where fiscal quaters are Nov-Jan, Feb-Apr, May-Jul, Aug-Oct. The resulting output would look like...
  11. planetdrouin

    Update Front End Tables with Back End Data

    Hello, I am rather new to Access, so... I have a split database, with some seldom changed tables remaining in the front end. I would like to be able to add code to my front end app, such that everytime a person logs on, these front end tables are updated with data from back end tables. These...
  12. planetdrouin

    Simple question about Compacting and using Front/Back end.

    If I am not mistaken, to allow users the ability to compact they need to open Access in "open exclusive" mode. If my DB is split between a front and back end, can all users be given "open exclusive" permission on the front end so I can automatically have the DB compact on...
  13. planetdrouin

    Need help with tabs and Me.Dirty

    I have a form which has a tab control with 5 pages. On one of the pages is a subform. I am attempting to add Me.Dirty then Me.Undo logic to an exit button. Is this possible with tab pages and especially with a subform on one of them? Thanks Lawrence
  14. planetdrouin

    Code to change a property on all forms

    About a month ago I saw some code either here or "The Access Web" which allowed you to change a particular property on all forms. For the life of me I can't seem to find it again. For instance, it was very useful for changing the menu bar property on all forms. Does anyone happen to...
  15. planetdrouin

    Code to change a property on all forms

    About a month ago I saw some code either here or "The Access Web" which allowed you to change a particular property on all forms. For the life of me I can't seem to find it again. For instance, it was very useful for changing the menu bar property on all forms. Does anyone happen to...
  16. planetdrouin

    Checking for password = null

    For an answer check out thread705-195900. Lawrence
  17. planetdrouin

    Code to check that users Access password is not null?

    Rick, Your accolades as a top tipmaster are well deserved. The code worked like a charm. Thanks for your help. Lawrence
  18. planetdrouin

    How do you reference Users Access built-in security password?

    I have a form that allows users to change their own Access built-in security passwords using the code: Set wsp = DBEngine.Workspaces(0) wsp.Users(CurrentUser).NewPassword Nz(TxtOldPassword), Nz(TxtNewPassword) However, I would like to add code upon startup which checks to make sure the users...
  19. planetdrouin

    Code to check that users Access password is not null?

    I have a form that allows users to change their own passwords. However, I would like to add code upon startup which checks to make sure the users password (Access built-n security) is not null and if so open the change password form. Does anybody know how to do this? Thanks Lawrence
  20. planetdrouin

    Checking for password = null

    The built in Access security. Lawrence

Part and Inventory Search

Back
Top