Recent content by Little_Anj

  1. L

    html help plz

    Just stumbled upon this thread, if anyone is looking here and is still interested.... I had a play around with html & css and a touch of java a few years back. One of my favorite websites to understand what to do with your html to make it well, look like a website is the css zen garden...
  2. L

    Combo Box filter continuous form- Suburb & Post Code

    Any one else have any other ideas how to select the second occurrence of Suburb column without adding more combo boxes to filter the list?
  3. L

    Combo Box filter continuous form- Suburb & Post Code

    Thanks again John. It's a great example, but a little more complicated than what I am aiming for for the end user. This is what I have, although not working correctly The two boxes are independent. However I want the suburb box to also filter the postcode based on the selection...
  4. L

    Combo Box filter continuous form- Suburb & Post Code

    Thanks John. I had already come across and checked out your example. Good to know, but didn't quite help.
  5. L

    Combo Box filter continuous form- Suburb & Post Code

    Hi, I know there are quite a few threads about combo boxes and continuous forms so I will apologise in advance if this is already solved somewhere else. (I will take a good link to a post as a solution). I have a continuous form (works great), with two combo boxes that navigate (rather than...
  6. L

    User Login, permission level loads different landing forms

    I found a basic login using macros that works a treat and sets the user id as a tempvars! (Credit where credit is due http://www.accessallinone.com/31-log-in-form_/) Each user has a different permission level, and based on that I would like a different form to load. Managers 1 Admin- Users 2...
  7. L

    Calendar as search criteria

    Hi Jake, I am glad I was able to help :)
  8. L

    Calendar as search criteria

    Hi Jake. I will give this a start, it is just an idea rather than a solution (I am a newbie). There are a few good threads on here for creating a calendar... I am going on the assumption you are running your query via a form... this could be very wrong. If you used one of the ideas to make a...
  9. L

    Merging two records- keeping tracability

    Update, I have worked it out and it works!! I have had to modify my table fields and relationships (just a little) Customer Table : New Y/N, Merged Y/N, Inactive Y/N Account Numbers Table: Customer ID, Account No Merged records table: Merge ID, Customer Merged ID, New Primary Customer ID...
  10. L

    Button activate yes no question to continue commands

    I have a button on my form, that runs a series of queries then closes the form. It works great!! How can I get the MsgBox feature to continue with all commands or cancel and close the form? Here is my code without message box action Private Sub AcceptChanges_Click() DoCmd.SetWarnings False...
  11. L

    Filter sub form results by first letter in Main form field

    Thanks heaps Sean!! You are a total lifesaver. I had forgotten about the quotes being there, as I was trying anything. Thanks again, that worked instantly :)
  12. L

    Filter sub form results by first letter in Main form field

    I have a Main form with a sub form. The main form is a customer record (form view), and the sub form is all other customers (same fields) datasheet view. I have a navigation bar to filter (using different queries) the results in the sub form same postcode Same company (different location)...
  13. L

    Join results of Unmatched query with a matched query to include Null

    Thanks heaps Recyan, they were some really helpful tips.
  14. L

    Join results of Unmatched query with a matched query to include Null

    I am trying to do the good 'ol sales report (query) to include customers with no sales. I have a customers table, account number table, sales table & sales (line) detail table. (all linked in that order) If I run a query to show customers (in the customer table) with account numbers, that works...
  15. L

    Another Date formatting question YYYMMDD to dd/mm/yyyy

    Thanks Brian!! It's funny, I am always in Excel making amazing reports with flashy macros & elaborate formulas, one click buttons, and forever going over my VBA code... I never think to apply the same ideas like you mentioned above to replicate my favorite "IF" statement from excel!! You are...
Top Bottom