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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DaveSH

  1. DaveSH

    how do I get a calendar in a dropdown box to select the date?

    Have you tried the active X calander control that comes with access ? Depending on your installation, you may have to go back and add it. Dave gallagherd1@rcn.com
  2. DaveSH

    Using multiple fields to validate data

    John makes a good point about the overlap. And I defer to his wisdom regarding the daily entries. :-) Dave gallagherd1@rcn.com
  3. DaveSH

    Forms - Finding Existing Records??

    Sherry, First I must say that reading your description made me kind of sad as I know there are probably tragic stories behind the data here. Anyway ... You have a many to many relationship between victims and offenders which in database design is represented by (2) 1 to many relationships. I...
  4. DaveSH

    Rerunning a script within Access

    thirty4d, Could you clarify a couple of points? Are you just trying to establish a link to the files in the various subdirrectories ? Or are you actually trying to extract data from the word files ? Do you want to open the files in word from access ? Do you want to view the document on your...
  5. DaveSH

    how to bind two forms?

    1- What is the record source of the order form ? 2- What is the record source of the form that displays the scanned invoice? (are they the same) If not how are the underlying tables related ? Dave gallagherd@earthlink.net
  6. DaveSH

    Using multiple fields to validate data

    Oh BTW, your comment regarding not being able to use the NO Duplicates index is true with your current structure. However if you had a record for each reserved day ... Table Reservations: ID PropertyID Date you could set up a composite index using PropertyID and date with no duplicates...
  7. DaveSH

    Using multiple fields to validate data

    If you have a form with fields: PropertyID Checkindate CheckOutdate And a reservations table with fields PripertyID Checkindate CheckOutdate You can put the following code in the click event of a command button. Private Sub Command8_Click() Dim sql As String Dim rst As Recordset...
  8. DaveSH

    Setting Backcolor property

    John, Verry cool ! Im just curious... did you stumble on this by accident ? Dave gallagherd@earthlink.net
  9. DaveSH

    Outputting Access data to MS Word...ouch...I'm hurtin'

    Perhaps I dont fully understand what you need to do, but... Can you make use of the Office Links button on the toolbar of the report preview screen ? This will output your report dirrectly to MS Word. In Word, if you want the text in tables you can select the text and choose "convert...
  10. DaveSH

    Overlaying data from one form to another

    You can certainly do it the way you describe, but I think you may want to consider the following. Its just asuggestion based on the description of your database. Im assuming you have a table named Classes that contains the fields ClassID and ClassName. Use a combo box. You can use the combo...
  11. DaveSH

    Multi Site database considerations - suggestions please

    I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...
  12. DaveSH

    Should I utilize citrix for this application ?

    I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...
  13. DaveSH

    Preparing to combine databases and acess remotely - suggestions please

    I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...
  14. DaveSH

    i opened a form using DoCmd.OpenForm "Name",,,,,acDialog

    Ah ... I got ya. Thanks Dave gallagherd@earthlink.net
  15. DaveSH

    i opened a form using DoCmd.OpenForm "Name",,,,,acDialog

    By definition a dialog box does not have scroll bars. Just curious (Im sure you have good reason), but why not open in another mode ? Could you accomplish your goal using the using the popup or modal properties ? Dave gallagherd@earthlink.net
See more

Part and Inventory Search

Back
Top