I have a form with a table in it, that is populated by a query. It all displays ok excerpt for one colum that has <Div> on either side of the data. What have i done wrong.
I have a form with a table in it, that is populated by a query. It all displays ok excerpt for one colum that has <Div> on either side of the data. What have i done wrong.
Form is bound to a table but the table is populated by a query? Why?
Show the sql statement of the query for analysis.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
sql =
SELECT [Expense Report Extended].*
FROM [Expense Report Extended];
You are appending records to the same table as the source data? Still don't know the why.
Simple enough sql and don't see cause for the issue.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The form is "Expense Form List"
test.zip
There is a form called "Expense Reports List". I see the issue on that form.
The Display Location field in Expense Reports table is a memo type and it is set as Rich Text format. Change it to Plain Text and the tags go away.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks so much for your help.. I never would have found that!
Also on that same form "Expense Reports List" i want to be able to click on ID & the form with that information in it.
But i can't get it to popup the first form.
You have code in the Expense Report Detail form Open event that goes to a new record. With that in place the form will never open to an existing record.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That code is there so when you open a new form that is is a blank form... Is there another way around this?
Since you have an Autoexec open the form by default when the db opens, set the Autoexec to open the form to new record. Set the Data Mode argument to Add.
Remove the Open event code.
Now the form has versatility to be used for existing and new records.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Many Thanks for your help... one last question please.
On "Expense Report Detail" form when i print preview to pdf i get more than one record on the print preview.
How can i stop that?
If you want the output to be for only one Expense report then need to filter the report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i don't know how to filter the report... I have tried many different ways but i can't get it to work.. can you point me in the right direction?
Options:
1. parameterized query, review http://datapigtechnologies.com/flash...mtoreport.html
2. Code (VBA or macro) to set filter criteria in DoCmd.OpenReport method, example:
DoCmd.OpenReport "Expense Report Detail", , , "ID=" & Me.ID
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.