Search results for query: *

...If the user leaves the 2nd Drop Down blank (Course Name), the query doesn't work. I'm not sure why, but I'm not having luck with the "Like "*"" syntax in the query if the combo box is blank. I've also tried >0 without success. Now, for testing sake, I did specifically define a course...

...INNER JOIN tblEmployees ON tblDivisionList.DivisionID = tblEmployees.DivisionID WHERE (((tblDivisionList.DivisionNm) Like "division 1*")); However, what I really want to do is pull the query parameter from a combo box. I have a table with division names in it (without offices), so 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 thoughts? =IIf([Forms]![Startup]![CurrentUser]=2541,like "*",[Forms]![Startup]![CurrentUser] ) Note: 2541 is a...

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

...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 * from tblClasses where Category = varActiveTabName Any Thoughts?

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

All, I have an extensive amount of data that includes two columns. Time and Amount ($). Each record in the table reflects a detailed transaction that occurs. Transactions can occur throughout a 24 hour period, however, they may not always occur each and every hour. What I'm trying to do is...

I'm graphing data using a Logarithmic scale. I do have negative values, and I realize these aren't allows, and I'm okay with the fact that Excel just skips over them. But, I get prompted with an error message that tells me that negative/zero values aren't allowed. Is there anyway to suppress...

I'm not sure I follow.....how would this appear as negative on the charts? I'm looking at account balances and I need to be able to reflect that an account is in negative territory? Perhaps I'm overlooking something simple. Thanks Skip!

Hi, I'm trying to graphical represent two data series/sets on a graph in Excel (with a primary and secondary y axis). The Data covers a LARGE range of values, so a Logarithmic scale for both the primary and secondary axis works great. However, I have a few negative values (which as we know...

Hi.....I've created an online survey tool that presents several questions at once on a page and allows the user to select a single answer for each question. Once submitted, the field values (q1, q2, q3, etc) are submitted to the next page (what I call the action page) as follows: Q1 = 100 Q2 =...