Description:
Microsoft Office Access newsgroup.
|
|
|
Display different color on report
|
| |
This may sound crazy. If I want to display red for negative numbers and yellow for positive numbers on the same text box on a report, is it possible? Thanks
|
|
|
Can't change office assistant
|
| |
When I try to change "Office Assistant", I get a message; "there is not enough memory available to complete this operation"
|
|
|
Select the "older" cell
|
| |
Hi Guys, I have a table "Orders" and I would like to erase the older entry from "Orders" for certain Customer. This table would have of course many Orders for one Customer: Customer - Order - DateDone John - 1234 - 08.20.2009.6pm John - 4567 - 10.20.2009.5pm John - 8910 - 11.20.2009.7pm What would be the DELETE/SELECT command that I would use to select the... more »
|
|
|
Memo Field needs to include field name within field.
|
| |
I need to add a memo field into a report and I need to have the data preceded by Note:. I used the expression "Note:"&" "&[Note] and now it appears I have a text field not a memo field. What is the best fix for this?
|
|
|
DoCmd.TransferText Method combines header into one
|
| |
I'm running a straight and simple TransferText method and getting an error: Run-time error '2391': Field 'RequestID_PartID_UnitNum' doesn't exist in destination table 'RequestPart' The code is such: DoCmd.TransferText acImportDelim, , "RequestPart", "C:\importrequestpart.txt", True importrequestpart.txt is a tab delimited file with a header row (3 columns).... more »
|
|
|
Generate string from selected checkboxes on continuous form
|
| |
I have a continuous form with a bound checkbox ("ExportSelect") on each line. I would like to have a command button on the form footer with an onClick event that finds all the records with checked checkboxes. Each time a checkbox is true I'd like the string to add to itself the value of another field on that record....... more »
|
|
|
döner
|
| |
ja döner macht schöner
|
|
|
Calculations on Option Group
|
| |
What I'm trying to do seems like it should be easy, but I've been banging my head against the wall for 2 days now and still can't figure it out. I have an option group with 6 selections, stored as 1-6. I want to run a summary function on these within date parameters and display a separate count for each of the 6 options. I've tried executing this with a SQL query, a... more »
|
|
|
|
