Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Chart MDB OK, ADP not working
TRANSFORM Min([CPID]) AS [MinOfCPID] SELECT [RD] FROM [BrandRespondDay2] GROUP BY [RD] PIVOT [BN]; I used the chart wizard to create this on a view I linked to the mdb. It works fine. When I copy and paste the chart to an ADP bound to the SQL DB the link was in I keep being told that the...- celtc
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Bound Rich Text Box On Report
Does any one know how to use a bound rich text box on a report. I have addresses stored in a table with each line being a field, but some lines in some addresses don't have values, so I concatenate the fields putting chr(13) at the end of each line which does have a value. When I try to show...- celtc
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Single Quotes Removing
Here are two functions to help with Single Quotes. The problems are caused by the character with ascii 39, and there is another character that looks very like it, ascii 96 which causes no problems. FixApostrophe replaces all the char 39 with char 96. QorN is for preparing strings to be put in...- celtc
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Help Files Unavailable ADO & DAO
In all office applications, in the Visual Basic help, help file names are available in the lists on the left, but any help article about ADO or DAO do not appear when clicked. EG Index Keywords Enter "ADO" Click RecordCount Property (ADO) nothing happens, no new article appears. The...- celtc
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
