Search results for query: *

I have created a Crystal Reports Cross-Tab that calculates number of accounts per account class as rows and months per column along with other calculations. A total of 6 summarized columns per month. This is a very general overview of the cross-tab January February March Difference Mar...

I am trying to get the following code to use the sheet name that I choose on a list box in a DoCMD. TransferSpreadsheet path. The code works if I place the actual name in the path. But when I try to get it to read the cboText choice I get an error that it cannot find the object.Can someone...

I have found a solution to open Excel, Choose an specific excel sheet based on input on a listbox form from a user and import the data from the selected Sheet to an Access db table. The data in the Excel sheet is based on months - Jan thru Dec. I can create the table with the months as column...

I am using MS Access version 2010. I have a Main Form, frm_ClientPriceDetails with three(3)subforms: fsub_ClientDetail, fsub_ClientOrderCodePrice_Data and fsub_ClientSpecialPrices. I have a text box control on the Main form: txtClientID with Control Source set to...

I have been given a SQL statement to adapt for use in MS ACCESS 2010. The SQL statement was written in SQL Server so I understand that there will be differences in syntax. I have tried to adapt the query for MS Access but am getting the following error: Syntax error(missing operator)in query...

I have a Query that SELECTS records based on a Percent. If the percent is Greater Than 40% then SELECT the record. Now this criteria is changing to SELECT Records after 08/31/2012 that are Greater Than 30%. I need to continue to SELECT Records with Greater Than 40% prior to 08/31/2012 and then...

I have a form frm02a_Track_Log. The record source of the table is tbl01. I want to add text to a field for a specific record on the table from the form and when I move out of the text field I want tbl01 to update immediately and also update a table called tbl02_Main. I have started a VBA...

I have inherited an old DB at work and need to make changes to our Audit Pass.Fail rate - FROM 40% to 30%.... I have a select query called, "Q09d2_percent", that calculates a percent and then flags a field called "Follow-up" either "Yes" or "No" based on the "percent" field calculation.The...

I have a make table query that applies a pass fail percent of 40% (0.395) to audits. One of the tables used in the query creates the percent to apply based on various criteria. I now need to apply the 40% (0.395) rate to audits less than or equal to =< 08/31/2012 and a 30% (0.295) greater than...

I have the following code that I want to use to automate sending reports to various clinic managers. The CODE will currently: 1. Add the Subject Line 2. Add the Body Text 3. Add the “Dear” + “Contact_First” and “To:Email” 4. Loop through all “Contact_First” and “email” 5. And Saves all email in...

I am trying to automate a report distribution process using Access and Outlook 2007 and VBA. I have created a form for the user to enter a range of dates. I also have Query which points to the form as criteria. I would like to open the form, choose a range of dates and have the form open a...

I am trying to automate a report distribution process using Access and Outlook 2007 and VBA. I have created a form for the user to enter a range of dates. I also have Query which points to the form as criteria. I would like to open the form, choose a range of dates and have the form open a...

I have created a website that includes a form that submits into an Access database. When I test form it submits information correctly into the database. When my employee who works from a home office submits data the information does not appear in the database. The information appears to submit...

I have created a form with several spry tabbed panels. each tab is a series of quesitons. I would like my users to be able to click a "next" button to advance to the next panel when they have complete the questions on each panel.Each time i add code to the form I lose the tab feature. How can...

Hello, I have a website that includes a form that asks several questions. This information is submitted to a Database. I have two questions that I want to validate against each other so that I do not have to "clean up" the data submitted. "Were you placed on Hold?" Yes or NO options in a...

I am using the code below to convert multiple reports from Access into Word Doc and then send to various recipients via Outlook email.The code works great but the rtf format loses graphics and colors. I would like to convert to PDF instead. How can I change this code to convert to PDF and then...

I have a 1 page report. When I run the report it creates 344 pages. The Page Header section is repeating over and over and over. How can I make this stop.

Hello tek folks, I have a report that includes 10 questions each question is scored as follows: =Count([Question]) to give the [Total Responses] =SUM(IIf([Question]="yes,1,0)) to give the [Total correct] =[Total Responses]/[Total correct] to give the percent I need an overall score for the 10...

Hello, I have created an Access Report that contains 2 subreports. One subreport uses a query as its data source (qryclinic_level_report) and provides data from the main results table on a clinic level. The other subreport uses the main results table as its source to provide overall results for...

Hello, I have created an Access Report that contains 2 subreports. One subreport uses a query as its data source (qryclinic_level_report) and provides data from the main results table on a clinic level. The other subreport uses the main results table as its source to provide overall results for...