Search results

Hello all, I'm using Access 2010. I'm passing a string into the OpenArgs of my report - works fine. In the report there are 3 rich text fields which may contain the text I passed in, and if so I want to change the color of that text to red so it stands out. The value passed to the report...

Good morning! I am struggling with this - so I hope someone can help! Mycode works great when I use the DCount function, but fails when I change it to DSum which errors with: Error 94 - invalid use of null. dblCntr = DSum("[intEventCount]", "tblResourceEvents", "[ResourceEventTypeID] = " &...

I have a combo box on a form where I allow the user to pick an office. The primary key is the bound column which I then want to use in a stored query to limit the query results to the specific office selected. I can easily do this with the docmd.runSQL in the module, but I'd like to use a stored...

Hello all, I have report header and footer pages in my report that I don't want to include in my page count. How do I exclude these pages? Thanks! Magster:confused:

Hello all, I have a form with several list boxes. After the users makes their selections, I want to pass each listbox to a subroutine to extract the user's selections. All of this work is being done in one form. This is the subroutine: Sub AllListBoxes(lstTemp As ListBox) This is the calling...

Hello all, Finally moved to 2010 from 2007 and I have one big problem - how can I turn off all security for my simple, quick-and-dirty application that is used strictly in house. The front-end on the PC, back-end on server. When users open the database, they get two security warnings. 1)...

I have one combo box that I allow a user to select a value and I create a report based on this value. I don't like to have a form displayed with just a combo box, so I was wondering, does Access 2007 limited ribbon capability support a combo box in the ribbon? Thanks to anyone who answers...

Hi all, I am calling a report from a form using the following VBA code: docmd.OpenReport "rpt-05",acViewPreview,,,, "DownloadProcess" In my report, I set Pop Up to No, and Modal to Yes. The report is created and displayed, but my code keeps on truckin... I thought that the modal would...

Hi all, Is is possible to create a hyperlink on a custom ribbon to open a pdf document? I want to link to some documentation for the database. I know that I can create a hyperlink in a table and I could have the users open a form that would allow them to select different hyperlinks and read...

Hello all, On my ribbon when I hover over a button, the supertip that I entered is displayed, and then the message "Press F1 for more help" is displayed below it. I would like to eliminate that message AND even disable the F1 key entirely. Is there an easy way to do either of these things...

Hello all, I would like to change the path of a stored import (Excel) via VBA rather than displaying the Manage Data Tasks window to my end-users. I'd like to display a popup allowing them to search for the correct folder, and then I would insert the selected string. So far I found...

Hi all, I have an Access 2007 database, FE on desktop, BE on a local server. I'd like to have a simple data entry form (with a few look-up lists from the database) in Sharepoint that would allow a user (who doesn't use the actual database) to insert a record- something like a help desk ticket...

Hi all, I totally give up on this one - but I guess not totally. I could do this with a recordset in VBA, but I'd really like to accomplish this via stored query. I have one table that consists of one column which is a Long Int field and I store a key value in it - call it tblTemp. This...

Hi all, I have a continuous form where my users filter the data by any combination of fields and they can print the form which lists all of the rows. This works OK, but what I’d really like to do is capture the recordset clone and use the data in a report. I tried to set the recordsource of...

Hi all, I'd like to retrieve a value from an open form so I can limit the rows in my query. Here is the query: SELECT tblProjects.intProjectID FROM tblProjects WHERE (((tblProjects.ClosedDate)=LimitProjects())) ORDER BY tblProjects.intFiscalYear, tblProjects.IntProjectNo; Below is my VBA...

Hello all, I have a modal dialog form that I use for filtering data for reports. On the form I have text fields where the user can enter a search value. I use ribbons in this application which uses the logic behind a button which I hide on the form to call the report (I followed an example in...

Hi all, I have a group header in my report and I have set the alternate back color to alternate rows. This works fine. My detail area is next which provide more information pertaining to the header and I'd like them to keep the same alternating color pattern as the header. In my group header I...

Hi all - I hope that I explained this so it could understood... I am trying to retrieve a column's value from a combo box. I have a 4 tiered relationship and I put the first tier on the frmProjects, the 2nd level goes on the frmProjectAssignments and the 3rd tab is a child of Assignments, and...

Hi all, How can I change the RecordSource of a report being called in VBA using the doCmd.OutputTo creating a pdf file? As others have mentioned, there isn't a way to create a where clause or filter on the following: DoCmd.OutputTo acOutputReport, "ProjectSheet-Delay", acFormatPDF...

Hi all, I'm using Access 2007 and I would like include "All" as the first selection in my combo box then populate the remainder of the combo box from an existing table. There are two fields, the first is the Primary key of the table, and the second is a description. I believe that I can create...