Search results

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...

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...

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...

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...

In my table, I have a column named "category". The data imported into this column, was previously entered as abbreviations, ie. acces, impor,dom,ect. I would like to create a query to convert the data in this coulmn, to the actual full name, ie. Accessories, Imports, Domestic, ect. I've...

I'm fairly new to MS Access, so I thought I might get some assistance here. (Background) I have a database (which has been split using the database splitter) with two tables. Table 1, is linked to an excel file which is updated nightly. Table 2 was created by importing the first table...