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

Search results for query: *

  • Users: Vyurr
  • Order by date
  1. Vyurr

    Meeting Several Conditions in a Single Field

    Thank you everyone for your thoughts...my problem has been solved. For those who are interested, I used a double-negation method to return the results I was looking for: The "double-negation" method use the logic of 2 negations: 1. First negation: Find the Employees that do not meet the...
  2. Vyurr

    Meeting Several Conditions in a Single Field

    I think, (and I could be wrong) that the LevelReq field is ok in just the tblJobLevelReq because there are relationships between tblJobLevelReq and the other tables you mentioned. I'm pretty sure, to keep the data normalized, I need to keep those seperate...again, I could be wrong. Thanks for...
  3. Vyurr

    Meeting Several Conditions in a Single Field

    Yes and no :) The tblJobLevelReq already contains all of the levels for each job, by competency. ([LevelReq], [JobID], [CompID]) What I need is the number of employees that meet ALL of the competency levels for a given job. I can pull the # of employees that meet each individual competency...
  4. Vyurr

    Meeting Several Conditions in a Single Field

    Yes, each job has several competencies required at varying levels. I can make the comparison [Level]>=[LevelReq] for each competency and can count the number of [EmpID]s that meet that criteria, by competency. What I need are only the results where [Level]>=[LevelReq] for ALL of the...
  5. Vyurr

    Meeting Several Conditions in a Single Field

    Good morning all, The query I am trying to create is a doozy and I could really use some assistance. Background Jobs in my office have a list of competency levels that an employee must achieve through testing in order to apply for a position. The goal of this query is to provide a count of...
  6. Vyurr

    Making Access multiuser

    Have you used the Database Splitter to split the database? If not, that's probably your answer. Each user can then have a front end on their own machine and you can store the backend (data part) in the shared drive.
  7. Vyurr

    modifying table relationships and adding data

    I'm not 100% sure on this as I'm fairly new to Access, but couldn't you just adjust the join properties in your query between the two tables to include all records form t_issue and records from Department where both are equal? (Not sure if that would be called a Right or Left Join, but...
  8. Vyurr

    Comparing data in continuous subforms

    I can't seem to solve this issue...so I'll let it be. Thanks for the time. V
  9. Vyurr

    Comparing data in continuous subforms

    You are correct....again (haha) subfrmJobLevelReq is linked by JobID V
  10. Vyurr

    Comparing data in continuous subforms

    So much for clarification, I apologize...I made and error in the table structure. The tables look like this: tblEmployees EmployeeID(PK) FirstName LastName JobID (FK to tblJobs) UnitID (FK to tblUnits) tblEmployeeLevel EmployeeID (Dual PK) CompID (PK with EmployeeID and FK to...
  11. Vyurr

    Comparing data in continuous subforms

    Thanks again for the response, I'll try to clarify. The main form is the employee form. It is bound to tblEmployees which contains the following data: tblEmployees EmployeeID (PK) FirstName LastName This main form contains a number of subforms, one for their current unit, manager and...
  12. Vyurr

    Comparing data in continuous subforms

    Hi Duane, Thanks for the response. I must be missing something. The Record Source of the subform that I want formatted is currently set to tblEELevel (so that the values can be editted on the form). How would I add tblJobLevelReq to the record source while still maintaining the ability to...
  13. Vyurr

    Comparing data in continuous subforms

    Good morning all, I think I'm close to solving this puzzle but there's just one piece missing. I have a main form with a two continuous subforms on it. The subforms refer to required levels that an employee must have in different "competencies" in order to fill a certain job. So jobs have...
  14. Vyurr

    Syntax Error in Form Filter

    Many thanks to you both. I think I've learned more in this single thread than I did in the last Access course I took :) V
  15. Vyurr

    Syntax Error in Form Filter

    Hi PHV, Thanks for the tip. I had to modify it a little: Your Filter property (set in the AfterUpdate event procedure of cboFiscal): Me.Filter = "[yourDateField] Between #" & Me!cboFiscal.Column(2) & "# And #" & Me!cboFiscal.Column(3) & # ...but it works well. Just as an aside, if I wanted...
  16. Vyurr

    Syntax Error in Form Filter

    Hello again, I've got it working now... Sometimes its the simplest little things. When I added Between DLookUp("[endDate]","tblfiscalyrs","fiscalID=" & Forms!frmStartup!cboFiscal) And DLookUp("[startDate]","tblfiscalyrs","fiscalID=" & Forms!frmStartup!cboFiscal) to the filter, I forgot to...
  17. Vyurr

    Syntax Error in Form Filter

    Hi Duane, Thanks for the prompt reply. While testing this, I have simply been clicking the apply filter button on the toolbar to attempt to apply the filter. The plan was to add a: Me.FilterOn = True later. You are correct that the filter is looking up values from a combo box on the main...
  18. Vyurr

    Syntax Error in Form Filter

    Good morning all, I can't seem to find the error in this, I'm hoping someone can shed some light. I am trying to filter a form to only show entries from this fiscal year. I have a fiscal year table that I am doing a DLookUp on. When I try to apply the filter, I get the following error...
  19. Vyurr

    Running Sum for a "Session" of hours entry.

    Well done sir. Thank you much...works like a charm. :) D
  20. Vyurr

    Running Sum for a "Session" of hours entry.

    Hey kvj1611, Thanks for the quick response. I recognize the inefficiency of rekeying data, but (without going into too much detail), in this case there is some analysis required as the data is keyed, so I'd have to look at each entry whether I keyed it myself or not. As for the text box...

Part and Inventory Search

Back
Top