MS Access 2003 – table inside a report
I have an Access report that I use in a mail merge (export to Excel and then mail-merge into a Word document). The report currently shows:
CustomerId
CustomerName
SaleRepName
ContractNumber
ContractDate
I need to include data that shows the products and their respective serial numbers owned by the customer. A customer can have multiple products....
KrazyKasper
Last Activity: Sep 29 '08, 09:53 PM
Joined: Mar 27 '08
Location:
-
MS Access 2003 – table inside a report???
-
Access to Excel - fields across columns
I have an MS-Access (2003) report that I export to Excel; clean up some formatting; and use the data in a MS-Word mailmerge for letters to customers.
In addition to the usual customer name, address, etc., my MS-Access report contains the products ordered by the customer. There could be anywhere from 1 to 10 product items (and their associated serial numbers) for each customer.
How, when I export the data, can I get the... -
Parsing Employee Name field
My table contains single field for EmployeeName populated as LASTNAME, FIRSTNAME
In my report query qry_OptimizeIt1 I defined two new fields as Expr4: ParseFirstComp([OrderRepName]) and Expr2: ParseSecondComp ([OrderRepName])
In my report, for text box RepName, my Control Source is =StrConv([Expr2] & " " & [Expr4],3) which changes the name to FirstName LastName,
My problem is that I end up with a comma after... -
Change Case in report field EmployeeName
I need to change the EmployeeName field in my report (based on a query) to Proper case and change it from LAST, FIRST or LAST, MI, FIRST (Results should look like:John Q Smith).
The name styles in the source table vary as some are LAST, FIRST, MI; others are LAST, FIRST. Also, some are all caps and others are not. I do not have authority to change the field in the table (ODBC link).
Seems like it should be an easy fix... -
Sorting Multi-Column List Box - Access 2003
I have a Multi-Column List Box named List10 that is populated via a query (qry_OptimizeIt 3). I’m looking to create three Buttons, one above each column that will re-sort the list in ascending order based on the specific column. For example:
FIRSTNAME LASTNAME AGE
John Doe 24
Bill Jones 43
Judy Smith 21
Sally Johnson 38
I thought I could have each button change the RowSource order of the... -
Access 2003 – Multi-Column List Box – Select Multiple Items
Access 2003 – Multi-Column List Box – Select Multiple Items
I have a multi-column (3 columns) list box that works well to select one set of records or all sets of records (based on the first field in the list box). I need to it also select multiple sets of records (Multi-Select = Extended).
I modified my code based on code I found on some Internet site which gave an example using three fields in a three field table.... -
Case Statements problem
I really appreciate any help you can provide. Although I am only vaguely familiar with VBA I think my problem has to do with the way I am naming things or the “Select Case” statement in my code.
In my report:
The text box is named txt_MyPrice
The Control Source is =mod_CreditItem ()
In my code:
The name of the (Standard?) Module is mod_CreditItem
In the database:
The table... -
Got it done.
Thanks for your help.
Krazy (Bill) Kasper -
I've got it now.
Thanks to all for your help on this problem.
Krazy
p.s. If this thread needs to be closed, someone please let me know how to do that.Leave a comment:
-
Need help parsing "name" field into fname, lname, middleinit
I'm a Novice User using Access 2003
Tables are via ODBC (i.e., cannot alter fields)
I have a report that uses the field OrderRepName (text string) and is formatted as lastname, firstname, middleinitial (No prefixes or suffixes, etc.). Sometimes the field is blank and sometimes there is no middle initial.
I found the following code on the Internet and it seems like it will work except I get an error message regarding... -
Command Button problem - Access 2003
I created two Command buttons in a form, one to preview the entire report and one to "cancel" or exit the form. They both work. I'm trying to create a third Command button to select/filter data from the report. My code to filter the data is:
Private Sub SelectedContrac t_Click()
On Error GoTo Err_SelectedCon tract_Click
strFilter = "[LeaseMasterCont ractId] = '" & Me![LeaseMasterCont ractId]...
No activity results to display
Leave a comment: