Recent content by ChrisLayfield

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...

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...

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()

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...

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...

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...

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:

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...

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...

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.

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

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...

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...

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...

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