Recent content by davec69

Sorry for the confusion. The field "State Total" in the report footer section is not totaling correctly. It should be around 12500.00 not 130335.94. What I think is happening is that even though I don't have that field in the detail section of this report, the state totel amount from table 2...

I'm a noob at Access, sorry for the lengthy question. Can someone tell me how to keep Access from including the detail line items in my report total? Below is a quick image of part of the report. The report is compiled from two tables. The first table has detail information on each line...

This can't be this difficult. All I want to do is add an Image (already uploaded to my webserver) to a report in Access. Is there a simple way to reference an image that is located on a webserver, in an access report? I've tried adding a column to the table which holds the URL for the...

Thanks for your help. Does this work when the URL's are not on the same machine, but are instead on a webserver. This is an example of one of the image addresses that I'm trying to link to: http://www.musicesp.com/images/584231084-B-1.jpg When I try to run the form, I get what looks like a...

Convert URL Field To Show Images I have a field in my database which holds the Image URL in text format for each items picture. Is there a way to make this column show the actual image, instead of the URL?

I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders. My Problem? The field...

Just in case others attempt this. There was an error in my original expression posting. It should read: Expr1: [ARTINAME] & " " &[TITLE]

That worked, perfectly. Thanks for your help.

I have a query that pulls information from two different columns in a linked table, and places them together in a single column in a new table. The expression that i use in the query is: Expr1: [ARTINAME]+[ TITLE]. I need to put a space between the two. Is there a way to put a space in...

Yes we have split the database into front and backend, though they are both located in the same folder on an internal server. To clarify, when several users try to send any report, using "Mail Attachment", then choose .rtf as the format, that is when they get the error message mentioned...

We are just trying to run a report that was created in Access, based on a query, which is based on a linked table. I'm not sure what code you're referring to. The report was created using the report wizard. The only problem we have is that when we select print or export to .rtf, we get the...

I have a problem printing or exporting .rtf files from reports in access. The database is located on a network server, and is accessed through mapped drives. Anytime I try to print or export, I get the following error: "Microsoft Office Access could not find the database on the server. Verify...

I have several workstations in the office that fail, when trying to send a report as an email attachment, in .rtf format. Most of the workstations have no problem doing this, but on a couple machines we get the error, "can not find the database on the server". The procedure we use is to run...

I've created a new database linked directly to the order table on our mysql server, and one of the fields in the database contains a line item detail of each customers order, formatted as below: <p><b>Invoice # 14494</b><br> <table bgcolor="#999999" width="95%"> <tr bgcolor="#cccccc"> <td...

Well, I don't understand the concept of inner vs outer joins, but I was able to get the query to do what I wanted. Thanks much, for the help.