Search results

I am using Access 2003. I have the following code to create a spreadsheet in Excel. Private Sub cmdExportToExcel_Click() On Error GoTo ProcError Dim strFilePath As String strFilePath = CurrentProject.Path & "\Template_rawdata.xls" If Dir(strFilePath) <> vbNullString Then Kill...

Hi, I'm using Access 2003. I have the following code to create an Excel spreadsheet: Private Sub cmdExportToExcel_Click() On Error GoTo ProcError Dim strFilePath As String strFilePath = CurrentProject.Path & "\Template_rawdata.xls" DoCmd.TransferSpreadsheet TransferType:=acExport...

I'm using Access 2003. I have a report that contains a subreport. The subreport contains a line chart. I open the report in View mode, then go to File, Print and choose Adobe PDF to make a pdf file. i have Adobe Acrobat 8 Professional. All works well if the report is about 165 pages (there...

I am using Access 2003. I have a question about charts please: In a report (not a form), I have a line chart with $ in the vertical axis, Date in the horizontal axis, and 3 values plotted as the data: PlannedCost, ActualCost and TotalCost. Access made my TotalCost line light yellow and I...

I'm using Access 2003. I have a feeling I'm not on the right path.. Can someone look at my attached database and let me know what you think? My purpose is to create a database where Measures data is collected monthly. There are Data Owners assigned to different measures. Monthly, when the...

I am using Access 2003. I have a table called [KPI Rating] with the fields: --number field called [Project ID] --date field called [As-Of Date] --number field called [Overall KPI Score]. I have another table called [Project Status Survey] with the fields: --primary key number field called...

Bob Larson helped me greatly with his code to go from Access to Excel. Everything works great and all the data is populated on one Excel tab. Now, I'm trying to add a second Excel tab to that same spreadsheet if a user picks a certain report from a combo box. Here is the code--the bottom...

I am using Access 2003. I think I finally figured out Access security, but I'm not sure if I did it right. Here are my steps: --Opened a blank copy of Access and created a new blank database. Named it SecurityTest.mdb and saved it on the shared drive. --In that new database, went to File...

I have a Access 2003 database called HA_PAD.mdb on a shared drive. My colleague created a workgroup HA_PAD.mdw file. But I'm not sure if the HA_PAD.mdw was created correctly. We are asking new users to join the workgroup manually by following the directions below: Open MS Access. (Via a...

Can I write an expression in a crosstab query to do a calculation for my Crosstab Value? Please see frmEscalationReports in the attached database. Choosing values from the 2 drop down boxes and clicking on the button opens the crosstab query. Currently my Crosstab Value just gives a count...

2 questions if I may: 1). In my Access 2003 database, under Tools, Start Up, Allow Full Menus is unchecked. I have a form that opens a query. When that query opens, I would like to activate the Tools, Office Links menu. Then when the query closes, I would like the Tools menu goes away again...

Can I make a crosstab query that filters from a value in a combo box? When I try, I get a message that "The Microsoft Jet database engine does not recognize 'Forms!MyFormName!My ComboBoxName' as a valid field name or expression." Please look at the attached database, at the form called...

I have a table with 2 fields that looks like this: ReportID CriteriaCode 1 ...........Cost-R3 1 ...........Cost-Y6 2 ...........Sched-Y7 2 ...........Sched-R3 2 ...........Risk-R5 etc. I have a report based on a query. The query contains a field called CriteriaCode. I have a combo box on...

I'm using Access 2003. Can I compare data in a table and look for changes depending on the date? The primary key in my table is a combination of ProjectID and AsOfDate. My AsOfDate is always the last day of the month (ex: 1/31/08, 2/28/08, 3/31/08, etc) Ex: my table looks like: ProjectID...

I am using Access 2003. Is there a global 'search and replace' function in Access? I inherited a database with descriptive field names. If I change the field name in my table, is there a function that will search all the IIF statements in all my queries to change the name there...

Can I use the IN keyword with LIKE? I know I can do: iif([Lifecycle] in ("MS1-BeginPhase", "MS2-DesignPhase") and I know I can do: iif([Lifecycle] like "MS1*" or [Lifecycle] like "MS2*" But can I do something like: iif([Lifecycle] in (like "MS1*", like "MS2*") Thanks,

I'm using Access 2003. In my database, I have over 300 queries. Out of that, I have 150 Append queries that I run each month. Because of the way they are named, they are in position 2 thru 151 in the query window. (They are named AppendCriteriaCostY4; AppendCriteriaScopeR8...

There are 2 types of paths a project can follow: ELC and SDLC. In my database, the user must choose which path they are following for their project. Once they choose a path, they must then fill in one of the two appropriate grid with dates. The two grids have around 40 fields each. I am...

I am trying to write an Append query that has a math formula. Part of the formula is to look at a text field called LastFullMonth (contains values such as January, February, etc) and do a calculation based on how many months have elapsed since the fiscal year. (the fiscal year begins in...