Search results for query: *

MS Access 2003 Report VBA coding that looped through the report and assigned a number based on a single field to add a table of content page numbers to first page (report header) doesn't fully load/activate unless the user switches to design view and then back to print view. I am having IT...

I have a report with a Table of Contents created in the Report Header. Then the page numbers for the actual data sections should start after the report header/TOC section. This would be easy if the TOC always took up one page, but depending on the amount of data, it can fill more than that...

I have a database form that is set up as an interface for importing data from an excel worksheet (the worksheet is generated from a different/larger system with a lot of data I do not want imported). When the user selects the appropriate file (me.admin_link) and clicks an 'import data' button...

We want to use the Workgroup Templates Option in Word to set up a forms directory (so our staff doesn't open/re-save master forms) and our IT dept. may not want to delete the standard tabs/templates. Is there a way to set the sort order of the tabs on the File New Dialog Box/change the...

I have a form with a multi-select list box that I use to filter several reports. If nothing is selected and the button for a report is clicked, all of the data is given, otherwise, if one or more people's names are selected only the data related to the selected individuals is shown. So far I...

I have a form that has a toggle button in a subform that changes which subform shows up and the related sort order (among a bunch of other formatting options). The orderby section (form open event) looks like this: If Forms![Main Review Form]![View Type Subform].Form!View = True Then Me.OrderBy...

Thanks to Duane Hookom's example database I was able to set up a simple timeline report that worked great. However, when I modified the code so that I would use it for a series of dates attached to one project (each project can have up to 3 spans using 6 total data fields from an external...

I need to set up a pivot chart or table that looks like the basic example below: Oct Nov Dec.........Sept Project1 SD----------ED Project2 SD-----------------ED This is similar style as a MS Project timeline, but all of the data is in an Access database. We may need this...

I am used to MSAccess, but I am new at importing data on a regular basis and then appending it to multiple tables. Each week we download a set of information into an excel spreadsheet from a larger system. I have a macro set up that limits the information in that spreadsheet to what we need to...

I have a report grouped by a person's name that I want to have lines in between record details, but not a line at the bottom. In the Northwinds Sample, they used the OnFormat Event to hide the group footer when a textbox in the header or detail section ("count") went up to a certain value...

I have a query that uses a Criteria form/combo box to pull records. If the Criteria form has a value selected just those records with that value come up. However, I also want to be able to not select a criteria and only have those records who have 'Null' values to come up. The query criteria...

Similar to other posts, I have a main report with a subreport that I need to use to capture a 'grand total' in the main report footer. The main report is based on information from a query (combining the main table and another many-side table) and then the subreport is pulling a count of the...

I have a spreadsheet where the 3rd row is going to be filled with various people's last names. Is there a way to change the Cell Name to be equal to the value in that cell? For example if cell B3 has "Smith" entered as a value, can "Smith" also be automatically set as the cell name? Any ideas...

I have an on Format event that changes the font style/size depending on the value of a field. It works very well, but the control is not growing to fit the contents, even though the 'cangrow' property (for both the detail section & the textbox) is set to yes. I am using Access 2003. Do I have...

I had a database code corruption occur today and I am just wondering if anyone else has had a similar occurance and or knows of a better way to fix it. I have a multiuser database that is replicated (I haven't had to split it yet and since it is a short term database I am not looking at doing...

I have a pop up search form that I use to find National level Contact names (located in a Main Form) that are connected to Local level Contact names (located in that Main Form's Subform). [This form pulls one or more National Names in connection with a Local name, as each local name could be...

I added a locked field to my main table and added the following code to the main forms on current and also the 'locked' checkbox's after update events: Dim c As Control On Error Resume Next If Me.LockedCB = True Then For Each c In Me.Controls If c.Name = "LockedCB" Or c.Name = "CTU...

I have a main form (Main Admin Book) that has several fields where users enter 'degrees' for personnel. I want to be able to have a pop up form where they can select multiple degrees and have those degrees then sent to the textbox when the pop up form closes. Table: CTU Info Field & TextBox...

I have a Main table that is linked in a one to many relationship to another table where users store 0-6 different field values per one main record. I want to exclude those main records that have a specific value entered in the many side linked table. For example if John Smith has value #2 (by...

I am not sure if this is possible, but I want to make a query for a combo box that uses the 'Institution' values from 2 different table's fields and only have the union query results show up if the ID matches the forms ID. I have this for non-union queries, but not sure on the SQL for this one...