Search results

  1. R

    Project Management

    database I think most of us would appreciate your kind offer. Which version of Access is it?
  2. R

    Open Outlook from Access

    Outlook Did you do a SEARCH on this forum? I thought there were several examples.
  3. R

    Problem with Report

    forms When you open the report from that form make sure the form stays open. If so, then you named the textbox data source on the report incorrectly.
  4. R

    Filter a report from a pop-up form

    report The Select Filter code was looking for 5 combo boxes and the form only had four. Same with the code behind the Clear button. Also changed the Tag of each combo box to it's data source field name. Then added the code mentioned above.
  5. R

    Problem with Report

    report If your parameter is being chosen on a form then at the top of your report place a textbox with it's source=Forms![myparameterform].[parameter]
  6. R

    Filter a report from a pop-up form

    report I made some changes. See if this does the trick
  7. R

    Filter a report from a pop-up form

    Report I downloaded your db and clicked on the Select Filter button and got no errors. However, once I used one of the filters, run the report (which looks fine), and then click on Clear and again click on Select Filter, the data does not refelect All data it just keeps the old filter. I...
  8. R

    Listbox Right Alignment

    listbox See if the following link helps you. http://www.lebans.com/justicombo.htm
  9. R

    Simple Inventory Update from Form

    inventory Take a look at the Inventory Database that comes with Access. Maybe that will help with some ideas.
  10. R

    What is the group of my currentuser

    group Check out this link posted by ghudson http://www.e-tech.ca/001-AccessSecFaq.asp#_Toc493299691
  11. R

    Button To Run Word File

    Word I tried this code in the OnClick Event of a command button in Access 2000 and it worked just fine.... Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc = "c:\Doc1.doc" If Dir(LWordDoc) = "" Then MsgBox "Document not found." Else...
  12. R

    Drag ans drop ?

    what a drag Do a search for Drag And Drop on this forum and you will find some examples
  13. R

    ListBox

    order This was posted the other day and will do what you need.: http://www.access-programmers.co.uk/...d.php?t=103456
  14. R

    Selecting multiple items on Combobox

    listbox Set the multiselect property to None to pass a value to a field in a table.
  15. R

    multiple items selected from list box through a from not passes to the table

    listbox Set your listboxes multiselect property to None to pass a value to those two fields.
  16. R

    Relationships

    source The Data Source for the Age field on the form MUST be the Age field of your table otherwise nothing will get saved.
  17. R

    Relationships

    age I am assuming that the data source of your form is the table that contains the DOB and age fields. If you enter an age in your age field on that form does it save that info? If that textbox's data source is Age then it should save the info. Are you able to post your db or is it contain...
  18. R

    Relationships

    age In the After Update Event of the DOB textbox place your code such that me.age=DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) where age is the name of the textbox on your form whose data source is age in your table.
  19. R

    Help with Check boxes

    check boxes In the OnPrint event of your report place this. If [checkbox1]=-1 then [textbox1]=1 else [textbox1]="" end if Place a texbox for each checkbox in your report and use the above code. There are several ways to do this, this is just a simple case. The -1 means that the checkbox was...
  20. R

    Relationships

    query In the criteria field of the query that contains the questionaire data set the criteria of the ID to whatever you want the search on. For instance, if you want to see the questionaire data for the person that has ID=3, the criteria field using the value of 3 will pull up just that person...
Back
Top Bottom