Recent content by jmgibson

Hi....I have a Form that I've designed which includes 2 Drop Down Boxes and a Button that will generate an Access Report based on the criteria submitted in the drop downs. The purpose of the 2 Combo Boxes (cboDivAllOFFICES, cboCourse_wDiv) is to filter the Report by Division Name (this is a...

Hi....I'm scratching my head on what I thought would be an easy query. I have a table that has employee names and their specific department. For example. Mark Smith | Division 1 - Atlanta Joe Bob | Division 1 - Boston Henry B | Division 3 - New York What I would like to do is to have a...

Hi...I have a query that when executed, it asks the user for an ID (number). If the user enters a admin ID, the query will return ALL records, and if the user enters a non-admin ID, the query returns only those records tied to that ID entered. I'm not sure why this logic isn't working. Any...

Hi, I suspect this is easy for many, but I can't figure out the necessary vba code to execute a requery and determine how many rows were returned in the query. Here's the basic gist of what I'm doing. Do I need to declare anything to use the RecordCount feature? Private Sub Form_Current()...

Hi, I suspect this is easy for many, but I can't figure out the necessary vba code to execute a requery and determine how many rows were returned in the query. Here's the basic gist of what I'm doing. Do I need to declare anything to use the RecordCount feature? Private Sub Form_Current()...

Hi everyone, I've placed a combo box on a form and asked Access to Find a record based on the selection within the form. Since I leveraged the Access Wizard to do this when adding the combo box, it drops in the following code. Private Sub Combo31_AfterUpdate() ' Find the record that...

Overall, I'm attempting to accomplish two functions related to the courses ; (1) assign specific courses to a specific job title (i.e. all project mgrs may be required to take basic 101, 102, 103); and (2) assign courses by employee (i.e. bob a project manager, must take Basic 101, 102. 103...

Majp, Thanks for the suggestion. I've incorporated the line of code above in both change events, but it seemed to make the problem worse. After adding courses to two different roles, the data presented in the sub-form (based on the combo on the main page) seems random in what it presents. It...

Hi everyone. I'm in the process of creating a way where a user can go in and select (via combo box) a Job title and then assign that Job Title a educational course or courses. Since there are multiple categories of classes (Basics, Supervisory, etc), I created a tabcontrol on my Main Form, and...

Hi everyone. I'm in the process of creating a way where a user can go in and select (via combo box) a Job title and then assign that Job Title a educational course or courses. Since there are multiple categories of classes (Basics, Supervisory, etc), I created a tabcontrol on my Main Form, and...

Is there a way to capture the Active Tab Name on a Tab Control. My VB is rusty, but I want to do something like. varActiveTabName = me.TabControlName.Name Ultimately, I want to use the variable in a query so that when a Tab is Clicked, the query will re-run based on the new tab name. Select...

Hi everyone. I've been away from Access for a bit, some I'm trying to get back up to speed. Anyway, I'm trying to determine how best to handle the function I'm trying to develop. I'm inclined to go down the path of a form/subform implementation, but I figured I'd bounce it off the group...

I'm plotting data in a time series (hour by hour) for every day of the year. I'm using a logarithmic scale to show the varying detail from a value of 10 to a value of 1 billion. In each hour, there are multiple data series. Since I need to show data for each hour in the data, my x-axis...

Pivot Tables may do the trick. I'm not sure I understand what the formula is doing in your second post. Can you ellaborate?

I recently posted a question about this and I think I was pointed in the right direction, but I can't seem to get it to work. Here's the question. I have a large quantity of transactional data and I need to eventually produce a graph that reflects the activity that occurred per hour. If the...