Search results for query: *

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

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

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

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

Hi Everyone. I've created a tool that users run to update an existing database they've stored on their server. This tool prevents us from having to redeploy new databases. Basically, the user opens the update tool (an mdb file) and it fires off several TransferDatabase functions (updating...

To maintain the objects in a production database, I currently have a second database that opens the prod file, deletes the unwanted objects, and replaces them with the desired objects. The dilema I'm currently faced with, is that I need to delete the Switchboard object that currently launches...

I have a very simple query that allows a user to pull up an employee's information by their empID. SELECT tblEmployee.empID, tblEmployee.Name FROM tblEmployee WHERE (((tblEmployee.empID)=[Enter empID to list Specific Employee])); I also would like the ability to pull all employees if the ID is...

I have a column that I need to sum and present on a page. Unfortunately, the values within the column are stored as text data. I figured I could utilize the "isNumeric" function here, but it doesn't seem to work. Is there a better way to handle summing text data (that are all numbers)within a...