Search results for query: *

I have the following query: ID Competency StartDate EndDate FTE 1 PM 10/1/2009 9/30/2010 1 2 PM 10/1/2009 9/30/2010 1 3 PM 10/1/2009 9/30/2010 1 1 PM 10/1/2010 9/30/2011 1 2 PM 10/1/2010 9/30/2011 1 3 PM 10/1/2010 9/30/2011 1 1 PM 10/1/2011 9/30/2012 1 2 PM 10/1/2011 9/30/2012 1 3 PM...

Hello, In my form I created a label that just says "Report." I want to tie this label when I click on it to open a Crystal Report. Of course the Crystal Report would be opened in the Crystal Report Application itself. It almost like tying it to a file path somehow. Any info. would be much...

Hello, I have 2 fields one by the name of FirstDay and the other by the name of LastDay and I want to calculate the number of days between the 2 fields using the following expression: NumberOfDays: DateDiff("d",[FirstDay],[LastDay]) I get the Undefined function "DateDiff" in expression error...

Hello, I have couple list boxes on a form that depend on each other . In list box 1 I have the following VBA code in the Before Update Event: Private Sub ListBox1_BeforeUpdate(Cancel As Integer) Me!ListBox2.Requery End Sub When I select an item in list box 1 then list box 2 shows the relevant...

This maybe very simple but how can I add a message box to the following command button on the click event in which if the answer to the question is Yes then open the Report and if the answer to the question is No then do not open the Report. I guess it's more like a statement followed by a...

All I want to do is to exclude [S8] AS SFTE and [S9] AS SFTE from the Union query SELECT qry_Smoother2.Location, 'Y0' AS YEAR, [Y0] AS FTE, 'S0' AS S, [S0] AS SFTE FROM qry_Smoother2; UNION ALL SELECT qry_Smoother2.Location, 'Y1' AS YEAR, [Y1] AS FTE, 'S1' AS S, [S1] AS SFTE FROM...

The goal is to import excel data from the various columns in the worksheet knowingly that the first row is generally the column names in the worksheet. I created a table in Access with the columns that should match up with excel column names. This is the part of the code that I'm having issues...

The goal is to import excel data from the various columns in the worksheet knowingly that the first row is generally the column names in the worksheet. I created a table in Access with the columns that should match up with excel column names. This is the part of the code that I'm having...

Hello, I just need a little help with VBA of how to get all the data from excel that pertains to each columns to the columns I have in an Access table. Currently its bringing only data in specific cells. First here the part of the code I need help in and after this is the all of the code...

MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am trying to export to Excel using a command in an Access Form. RowID strFY AccountID CostElementWBS...

I have a command button on a form that when I click on it, it executes a function that exports data from a query to an new excel file. That parts works fine but what I want is to click on the button again and hope that it executes the same function but gives the new excel workbook a different...

I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am trying to export to Excel using a command in an Access Form. RowID strFY AccountID CostElementWBS CostElementTitle 1 2008...

I want to export this Access table into Excel in the following way I describe below. Below you will find the simple table I am trying to export to Excel. strFY AccountID CostElementWBS CostElementTitle 2008 1 7 Integrated Logistics Support 2008 1 7...

I'm trying to export a view I created in SQL Server 2000 into specific cells within two worksheets within a workbook.

I am trying to create the a View with the following SQL code but I get an error message that says "The Query Designer does not support the CASE SQL construct." It also states that I have an incorrect syntax error on '2008'. CREATE VIEW dbo.tblFinancialsSummedbyFY_FY08 AS SELECT...

In my main report I put a subreport on the a group footer. On the subreport I suppressed everything but the group header which contains my columns names, the detail section, and the group footer of the subreport. In my main report I have the group header that pertains to this information on...

I want to hide the main form whenever I click on command button on my form and then restore the main form when the user closes the form opened by the command button. I have the following code on the On Click Event of my command button of my main form: Private Sub Command148_Click() Me.Visible...

I was wondering if anybody knows how to capture the Database User's Name in a text box on a Form. I have my table with my Users along with their username and password. I have a logon form that I created with a combo box and a text box that capture my Users name and password.

I a report grouped by month and in a text box, I have the following: =Sum(IIf([Contributions/Disbursements]>0,([Contributions/Disbursements]*-1),[Deposits/Receipts])) in a text box and have also set the Running Sum Option to overall in the Data Tab. Within this expression I would like to see if...

Hello, I have a label in where I am placing my report title. My title reads: Deposits and Contributions I want to change the "and," to "&". I know this might seem fairly simple but I do appreciate it very much.