Search results

I have a form called [frmConfiguration] which is parent to the subfom [Formation Setup Date Section] in which are recorded the dates of revisions to information in [frmConfiguration]. In the footer of the subform [frmRevisionDates] I have a text box [txtCountDates] that counts the number of...

I have a database query that returns the following result from a 3 column table: The first column is “Sentence_ID” The Second Column is “Word_ID” (the PKF Field and sort field) The third column is “Word_Used” A 1 The A 2 Quick A 3 Brown A 4 fox A 5 jumped A 6 over A 7 the A 8 gate B 9...

I have a simple database but with roughly 30,000 name records in it. Each name record consists of three elements Name1; Name2; Name3 (similar to first, middle and last). Not all three elements are present in every record. The possible combinations for any given record are as follows: [Hussein]...

The ability to apply rich text formatting to memo fields (in Access 2007/2010) is quite helpful for me, however I wonder if there is a way to apply the same RTF formatting to multiple memo records (all at the same time)? As it is now, I need to go to each individual record and change the...

A report that I use fairly frequently has suddenly started "hiding" the Page Header and Footer on the FIRST PAGE of the report. It displays properly on all subsequent pages. I noticed too, that the first time I tried to run the report today that the Page Margin settings had all reverted to 0"...

I am using Access to double check some statistical analyses done “pre-computer” and published in book form some 70 years ago. So far I have been able to duplicate the analyses quite successfully, so that part of the project is not a problem. There is one feature of the printed document from...

I am having problems with the following code that is in the On Format event in the detail section of a report. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) ‘*************************** ‘ Change font color when translator name is “L” for Lamdin ‘ ”PM” for Patterson-Meyer...

Here is another off-beat problem that I need help with. I am working with a large Access database of foreign language (Greek) words that is being used to create a dictionary. The Greek alphabet is represented by translated western (“English”) letters. A True Type font makes the letters display...

I have a report with multiple columns. The REPEAT SECTION property of the Group Header is set to "Yes" (so it repeats when there are more detail records than there is space in the column). This is a nice feature but I am constantly replying to complaints from report users who claim data is...

I have a large report (+/-300 pp) where the field for each item in the Group Header is shaded grey. When the report is generated, I would like to be able to programmatically change the Group Header data item shading to other colors based on the text value of another field associated with the...

I am trying to devise a way to display query results in a row instead of a column. The table on which the query is built has this structure: Column1: Index (pkf) Column2: Group (int) Column3: Position (int) Column3: ItemCode (txt) When I do a select query, the data comes back like this: Group...

I’m working with a data base designed for the textual analysis of Ancient Greek documents (now in its 5th year of development). One of the problems that I have yet to resolve fully is a way to create grammatical data output (a report) in a rather unusual format. Specifically I need to display...

I am using an Access database for a foreign language dictionary project. One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA. This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad. The form in...

At one time I knew how to do this, but now I can't remember... I have a report that has 4 columns on it (roughly 200 data items). I want to print the first data item (in row 1, column 1) and the last data item (row 50, column 4) in the page footer. Like I said, I used to do this, but just...

I am trying build what I thought was a super simple data base, but this is driving me crazy. I have a group of building maintenance manuals (12) each of which is subdivided into sections. I have created a list of all the section headings and respective page numbers and have imported them into a...

Hi All- Is there a way to create something similar to a Cross Tab Report but that shows text data instead of numerical data? I'd like to group accumulated text data in columns based on column heading for North, South, East and West. Am I delusional, or is there SOME way to do this? Thanks!!!

I am attempting to use a custom dialogue form to pass parameters to a query when a report is opened. The dialogue form has a combo box on it that pulls employee names from a record source that is another query. When I open the report, the dialogue form opens properly, and permits me to select a...

I have a form with calendar control 11.0 placed on it. When the form opens, the calendar is invisible. When the cursor enters a field called ClassDate the calendar (calClassCalendar) becomes visible. When the user clicks a date on the calendar control I want that date to appear in in the...

Our organization (a University) has been engaged in becoming "paperless." As part of that initiative, we have spent the past several months scanning several hundred thousand pages of documents relating to building systems (HVAC, e.g.) as well a a massive quantity of detailed lead and asbestos...

We are creating a simple database to maintain driver license information for faculty, staff, and students who use cars from the university’s motor pool. To do this, I have created two tables: tblDRIVER and tblLICENSE. The fields in tblDRIVER are: pkfDriverIndex strLastName strFirstName...