Search results

  1. C

    Dcount within SQL Select statement

    OK, I managed to get this figured out, though I had to do something a bit different than I had first set out. I created a query that identified the articles which were only screened 1 time (modified the Access provided duplicate query) then used that as the record source for a second query to...
  2. C

    Dcount within SQL Select statement

    OK, so I can't figure out that many selects and keep it straight so I took a new course. I separated out some of the decisions, but now am stuck on this statement: SELECT tblScreening.ArticleID, Count(tblScreening.ReviewerID) AS NumberofDups, First(tblScreening.ReviewerID) AS [ReviewerID...
  3. C

    Dcount within SQL Select statement

    I wish that would have fixed it Bob. I've uploaded the db in case you had time to look, the code is within the Form_frmScreeningTool in Private Sub Form_Load()
  4. C

    Dcount within SQL Select statement

    I thought I had programmed as you indicated, but I am getting a syntax error (missing operator) in my query expression...any idea? Me.cboTitle.RowSource = "SELECT ID, StudyTitle, Abstract, ArticleID, ReviewerID FROM qryReferences " & _ "WHERE 1 = (SELECT Count(*) FROM (SELECT...
  5. C

    Dcount within SQL Select statement

    Bob - Thanks, that indeed does work, but unfortunately doesn't solve my problem. It seems I have a flaw in my logic. In this equation, tblStudyReferences.ID will always equal tblScreening.Article ID which means nothing will show up once two references are screened. :banghead: What I need to...
  6. C

    Dcount within SQL Select statement

    I have a reference database, where the references need to be screened by two independent reviewers. I need the references to load as the rowsource of a combobox only when the user has not already reviewed the reference or the reference has not been reviewed twice already. I thought I could...
  7. C

    SQL SELECT not recognizing table

    I updated the SELECT statment and replaced tblReferences with p and tblScreening with i and now I get a "You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function." I have no idea what that eve means:banghead:
  8. C

    SQL SELECT not recognizing table

    I am working on a project where two independent reviews screen literature (study) within a form. I created a combobox to allow the user to select the study, but can only select a study which they have not already reviewed and where the study was not already reviewed by two other people. For some...
  9. C

    Access to Word Automation

    The easiest method is to create bookmarks in your Word document, then using some modified code (like below) open your Word Doc, select the bookmark, fill and save when done. Set wrdApp = CreateObject("Word.Application") wrdApp.Documents.Open ("PATHWAY\DOCUMENT.DOC") wrdApp.Visible = True...
  10. C

    Date in recordset leading to Update Edit error

    I figured out another way. since there is only one record per employee, I just used a dlookup with an error catch when there is no data. This thread can be deleted.
  11. C

    Populate controls on form via query

    strsql = "SELECT * FROM dbo_MemberAddress WHERE dbo_MemberAddress.MemberNo = " & Forms!Form1.memnum &" AND dbo_MemberAddress.AddressType = 'HOME'" Try that
  12. C

    Date in recordset leading to Update Edit error

    The form is bound to a table which contains employeeID, background clearance level and date of clearance. On the form the user has the choice of adding a new user which opens a new record or editing an existing record. When the user selects the employee to update, the form is populated with the...
  13. C

    Date in recordset leading to Update Edit error

    I have the following code to retrieve a recordset, which works perfectly. The issue comes form trying to assign the DateofClear data. It is retrieved correctly with the stored Short Date format, but when I run this where I assign the data to the text box on the form I get an 'Update or...
  14. C

    Passing Data to Acrobat Form

    I don't know of a way to do that in Word, but it is easily created in an Access report and you can capture the comment back into the database easily. Open the Property Sheet, Format tab, Scroll Bars change to Vertical. That should give you want you want. Using an Access report will save you...
  15. C

    Public Variable losing value

    perfect and thanks for making it abundantly clear. Will help whoever comes after as well.
  16. C

    Passing Data to Acrobat Form

    I have yet to do this, but doesn't work in the same exact way? You have to of course set-up the pdf as a fillable form first, but don't you still need to create bookmarks and everything the same way? Since you already know how to do all of this in Word and if you have the Word form set-up...
  17. C

    Public Variable losing value

    I think I figured it out with a little more reading, the issue is that because I am switching from one form to another, the public variable is only available within the subs on that form and not across the datbase. Is that correct? So to make across the entire dB I would need to make it a...
  18. C

    Public Variable losing value

    When the user logins in, I have a value in the profile to determine their access to the database. I edited out the code that doesn't apply Option Compare Database Public strUserID As String Public strUserAccess As String '------------------------------------------------------------ '...
  19. C

    Update SQL Date Issue

    Thanks Bob, that did it. Still learning all of this syntax stuff, gotten better with my quotation marks though lol.
  20. C

    Update SQL Date Issue

    Yeah I did that...I should have updated code to show. The date is entered into the table correctly, but the date is incorrect. Still being entered as 12/30/1899 for some reason. db.Execute "UPDATE tbl_EmployeePasswords " _ & "SET Password = '" & strNewPassword & "'," _ &...
Back
Top Bottom