Search results

  1. T

    Between Dates Problem

    Thanks for your help boys. I have changed the way in which the Report opens in that the code is no longer used but "Between [Report Start Date] And [Report End Date]" is now in the query Criteria. As a result I get a more robust date entry, ie I can just type 1/4 for 1st April. The problem...
  2. T

    Between Dates Problem

    Cheers Mailman. I thought the American date format was the problem and changed it to (mm/dd/yy). The problem existed before this change. I'll change it back. Is there anything else I can look at? Tyler
  3. T

    Between Dates Problem

    As my report opens, this code runs: Private Sub Report_Open(Cancel As Integer) sdate = InputBox("Please Enter Shift Report Start Date", "Report Start Date") edate = InputBox("Please Enter Shift Report End Date", "Report End Date") If IsDate(sdate) = True And IsDate(edate) Then Me.Filter...
  4. T

    Another WHERE statement problem

    Bloody hell, I've been scratching my head with this all morning! And the odd thing is that the ';' converted to a wink in the post and I still didn't spot it! The report works lovely now. Thanks geezer. Tyler
  5. T

    Another WHERE statement problem

    Afternoon all I'm trying to open a report based on a selection in a Combo drop down on a form. The report lists shifts booked by operatives to various contracts and I want to limit the results to the contract selected. I get the error message: Run Time Error '3075' Syntax error in Query...
  6. T

    Using a table twice

    Because usually, although not always, when a document is revved up the author is a different person from the author of the previous rev. So an Owner is linked to each Version of each Document. The Versions have to be in a seperate table since a document could be revved up as a result of just a...
  7. T

    Using a table twice

    Thanks for your continued interest! The Owner is the owner of the version and needs to be an FK in the Version table. And that is exactly what is causing my dilemma. If I put the Employee table in the relationships twice and omit the Owner table, I then create a join from the second Employee...
  8. T

    Using a table twice

    Great reference site. Tyler
  9. T

    Using a table twice

    Ain't that the truth!!!
  10. T

    Using a table twice

    Yes they are but Employees are not necessarily Owners! Tyler
  11. T

    Using a table twice

    Employees are users of the documents. The owners are the people who write the documents and the new revved up versions of the documents. They are employees too! Hence the duplication of information. The db works ok with two seperate tables but I recently had to update information on an employee...
  12. T

    Using a table twice

    I have put the employee table in the relationships window in an attempt to use it twice but failed to work out how to enter the joins to make the thing work. My frustration at the ambiguous outer joins error led me to start this thread! Could anyone point me to an example of how to do this...
  13. T

    Using a table twice

    Each Employee can have many Documents and each Document can have many versions. And each Owner can have many Versions. The form that displays this information shows the Employee name against the Document details and has a subform that lists each document's version details and the name of the...
  14. T

    Using a table twice

    Ok, I'll look at that. But I still need to display two different names one one form. One name from the Employee table and one from the Owner table. Tyler
  15. T

    Using a table twice

    Ok thanks Tyler
  16. T

    Using a table twice

    TblVersion is there because each document (TblDocument) has many versions (TblVersion) and each version has it's own owner (TblOwner), not always the same person as the Employee. Tyler
  17. T

    Using a table twice

    Just found the paperclip icon! Relationships jpg attached Tyler
  18. T

    Using a table twice

    Thanks for the reply. Will the forum let me post a jpg of the Relationships window? If not I'll email it home and post a link to a Photobucket url tonight. My company firewall will not let me access photo sharing web sites. :mad: Or, the structure is like this: TblEmployee TblDocument...
  19. T

    Using a table twice

    My database has a table listing employee details which links to a table of documents. Another table lists document versions which links to a table of document version owners. Since most of the people in the employees table are also in the document owners table any alterations to their details...
  20. T

    Inserting Thumbnails

    Can anyone please tell me how to insert a thumbnail of a jpg into a Word table? The original jpgs are all about 1.5Mb each and I need to create a document to display 20 of them to email to a client. An Excel file will do if this would be easier. Regards Tyler
Back
Top Bottom