Search results for query: *

All: Does anyone know if I can add a variable to a control in a report footer? Example: =" - " & [Page]+ StartPageNO & " - " where StartPageNO is the variable. If there is, how do I do it?

I have written a routine to add the page number of a report in the footer section. The routine populates a textbox control so that I get this: =" - " & [Page]+13 & " - " . How do I preview the report with the page number? This entails calling the routine before the report previews but I don't...

All: I wish to put up to 11 images on an Access Report from data in one Table. The number of fields include ID, Org, FName, LName, Office, OfficerName, and FilePath (to the image). I create my Table with a form, inserting single images for each name, and show the image in an image box. I...

I am using MS Access 2007, Windows 8.1. I input the FilePath to 11 Chapter Officer images and names on a form using a table source. That Works oK. My Table: Org (Organization number to re-org the officers if needed). ChapterOffice (President, VP, Membership, etc)...

I want to insert an OLE image onto an Access 2007 form but all internet assistance I find says "drop the OLE object on a form, right-click (presumably in Design View) and click on the insert image" option. The problem is I can't find the option in any dialog as stated by YouTube or Internet...

I am writing a report with a multiple-record interior subreport. When I print (preview) the report, I get multiple pages with the same group of records. I suspect the report writer is printing a report page for each record. I would bet the problem has an easy fix but I am at a loss to find the...

What's going on here? Access program I've been using for years now throws an error message ". . .can't send this email message" when I try to email a message to individuals in my database. Windows 8.1 64bit Windows update thru December rollup. MS Office 2007 Pro (Purchased license from Ebay)...

I have tried my level best but nothing seems to work. Can anyone help? Here is my code: Sub cmdResetRecSent_Click() Dim strSQL As String strSQL = "UPDATE [tblHOA MEMBERs] SET [tblHOA MEMBERs].RecSent WHERE ((([tblHOA MEMBERs].Member) = -1))" DoCmd.SetWarnings False...

All: My problem seems simple but it is in two parts. PART #1 I have a data entry form with an underlying table called tblCOVER This table has 1 record with two fields: "Year", "Cal1" With an UPDATE query in an After Update Event, I update tblCOVER.Cal1 from a table of 100 values with fields...

All: I can write a query with the "group by/count" total that outputs the number of records for a value in the table but, can I add a joined table to the query so I can add other fields to the query output? If so how? I have tried but I get only a count of one for each record. Ron

All: I have a db file running under A2003 that for some reason now does not work. The "Trim" and "Left" functions are not recognized, at least one table is missing and all links to that table are broken. I suspect Office 2003 SP3 is the culprit but cannot prove it. Other db files I use don't...

All: I replaced my hard drive recently and reloaded MS Access. Now when I examine the code behind one form, all the code behind forms windows open. Strange! How do I make Access open the one code behind window? Tnanks, Ron

All: Hope this is right forum. 1. I have two tables. One contains 2000+ member records and one contains 60+ chapter records. I can marry the tables in a query. 2. Each member record contains a member number and a membership expiration date (expire_dt) in the form of yyyymmdd and the chapter...

All: I have a query output with names and email addresses. My goal is to send the data to Outlook Express preferably not as an attachment. Does anyone know how to send the query output to IE with the email addresses hyperlinked so the recipient of the email can open an email by clicking on...

All: I have a form with fields referenceing a table source, tblFamilyREc, and two subforms, one with a second table source tblIndivRec, and another with a query built on both of the aforementioned tables. Both tables include a FamilyID field which are joined. I wish to print one record from...

All: I fear I'm in the worong forum but this seemed the most logical. The Office Links drop-down feature (MS Word, MS Excel,etc.) is not turned on when I preview a report. Does anyone know how to turn it on? I have tried evertything I know how from reinstalling to reparing the installation...

All: I'm stumpted. I used to be able to print my report to MSWord from inside a preview but since I cleaned and reloaded Windows, the OfficeLinks button is grayed out and I can't make it active. What gives? Any suggestions? Ron

All: I have a report (chapter directory) with a list of chapter officers for each chapter--one chapter per page--in my organization. The chapter officers (Pres. VP, Treas, etc.) and chapter names etc., are contained in a subreport. How do I count the number of memberID's in a chapter then...

All: I have a table with 2000 MemberIDs spread out over 60 ChapterNo's. At print time, I print a separate report for each chapter that includes the number of memberIDs in that specific chapter. This looks like run-of-the-mill stuff but I'm lost. I'm using Access 2003. My original thought was...

All: I am running 2003 Access. Two things occur that I don't understand when I create a query: 1. When I "VIEW" a query with no fields specified, I see all my data fields. 2. When I run a MAKE TABLE query with only one field and view the new table, I see all the fields. What gives? How do I...