Search results

  1. S

    How to add selected items from a combo box to a listbox on a form

    I am hoping to answer everyone's questions @moke123 @arnelgp in this reply: The database contains couple hundred assets of which several assets would be related to it. I have three types of forms, Audits, Incidents and Projects. I want to use this idea on the incident and projects forms. The...
  2. S

    How to add selected items from a combo box to a listbox on a form

    Sorry about that I think my PC had a funny five minutes as I tried to reply to everyone...
  3. S

    How to add selected items from a combo box to a listbox on a form

    I am looking for a solution to an idea I have. I have a form and on it has a combo box. That combo box has a list of items related to that form's record. I want to have the ability to select an item on that combo box list and it adds itself to the Listbox on the same form. This should also...
  4. S

    Requiring help with ironing out some issues with my task management DB

    Pat, Allow me to comment. I have been considering your example, I have considered others too. I am weighing up the pros and cons of all, and will look at the overall weight of it over the weekend. I might not be experienced to your level, however, I do have my own expertise in other areas...
  5. S

    Requiring help with ironing out some issues with my task management DB

    I have been re-creating that what is within the sample DB "Issues Tracking" within Access. It isn't what I had in mind but is the closest example to what I would like to achieve so piece by piece I have been only re-using what is already written. Except, this has flaws because for some reason I...
  6. S

    Solved How to add two fields in my form t

    Fancy a stab at my other thread in the form forum? No one seems to be on point with it.
  7. S

    Solved How to add two fields in my form t

    Perfect. Thanks.
  8. S

    Solved How to add two fields in my form t

    Just a little code correction; I would like to combine two fields in my form to make the subject of my outlook appointment. Here is my code for one field, Title: If Len(Me.Title & vbNullString) > 0 Then .Subject = Me.Title I would like my subject to formulate a...
  9. S

    Question Access date field to add to Outlook Calendar

    Did you by any chance get this question resolved from 11 years ago?
  10. S

    Requiring help with ironing out some issues with my task management DB

    Thank you for the initial help. There are some nice touches made, however, my main focus is on the "View Task Details" form itself. The primary function I am trying to achieve here is to create a relationship (not table relationship) between my chosen main task, and several other tasks on the...
  11. S

    Requiring help with ironing out some issues with my task management DB

    I am stuck on a number of problem(s) of which I would really appreciate some help (I wasn't particularly keen to try this method of adding a task management DB to my project however it seemed to be the only example to fit the bill): Simulation: I use the Form DB Task List to list all the tasks...
  12. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    of course, tiredness really did kick in! Thank you Ranman256
  13. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    Do you know what it is so clear now its been spotted. Its always the minor details! Thank you for the help in achieving this, both of you.
  14. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    Ill convert it to 2007 - scrap that I can't.
  15. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    Thank you for the replies. I have had no success so have build a sample DB for you to see. Either I am really tired and cannot see it or just need another set of fresh eyes on this.
  16. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    I do understand the methodology behind supplying the code, however, it didn't seem necessary to paste that I used directly. So, I have pasted the code I have tested which doesn't seem to be working. Note that I have also tried on the click event Private Sub ChkHideCLOSE_AfterUpdate() If...
  17. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    The code is a direct copy of that supplied, no changes have been made. Information supplied twice is as much use as the chocolate kettle.
  18. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    Thanks for the code. I have just tried this and it isn't updating the records. Do you have any suggestions I can try?
  19. S

    Solved Code required for hiding "[Status]=Closed" records on continuous forms

    Hi all, I am looking to develop a continuous form that contains all "task" records from a task management DB. Note, I have not started creating this DB. On the continuous form, I am thinking about how all the records will show and how to filter those. Thus, I am looking to see if there is a...
  20. S

    Filter data between two dates within a form

    Hi, does this code also work on opening a form under BETWEEN date conditions? I tried the following below to no avail. Dim strWhere As String strWhere = "[TBLRequisitionsDB]![DateREQ] Between " & Format(Me.DateFROM, "\#dd\/mm\/yyyy\#) & " And " & Format(Me.DateTO...
Top Bottom