Search results

You can download an addin somewhere that will give you an Adobe toolbar This will give you two buttons; one to convert to pdf and the other allows you to convert to pdf and email. I know it works in word but I haven't tried it in Access. The only problem is I can no longer find it. The...

This is a very simple question, adn i have no idea why I can't get it to work, but here it goes. I need to create a form that will allow the user simply to add information to a speified table. I only need to link it to one table. One of the fields that they must be able to add is a hyperlink...

Open the report in design view. You can either go to File/Page Setup and change the margins of the page. Or you can click and drag the white/gray area in the report in design view and adjust the size of the report. Hope this helps

Table A has WorkOrderID CustomerID CarInitialID CarNumber TrailerNumber etc... Table B has CarInitialID CarInitial In Table A change all CarInitialID fields so that they are greater than 0 and not blank. when you link the two tables together you lose all the info where Car Initial...

Here is your problem. Car Initial ID cannot be NULL. i.e. cannot contain 0 or be blank, it is a primary key in the other table, you cannot have a null value in a primary key. If you make these changes then the query returns all 9 records. I only see one record with a trailer number in the...

Where are these tables in the DB and What are they called?

I cant see why it isn't working from here. If you can post the tables I can try and create new queries.

IS the Car ID more than one number?

Did you check the original query that has "Trailers". look at it in design view and make sure the SHOW box is checked otherwise you cannot see it.

It sounds like there is something wrong with the Query. Is there any way you can post the DB or something similar?

SIze Restriction Just a little reminder. If you plan on creating a very large database then don't use Access. Access has a 6GB size restriction. This is a very large Db but I would hate to see you put in all of this work to find out that you can't keep adding records.

Use the wizard When you use the report wizard it allows you to group on many different levels. I think this is the easiest way to go about this.

Reports Is it an option to use a report?

OK I got it Sorry about that I was looking in the wrong place. It works perfectly now. Thnk you very much for all of your help. It is greatly appreciated

Grouping options I dont get any grouping options that refer to footers. I tried to enter the code =Sum([COST]) into the main footer and i get an error?? Everything your are saying makes complete sense, i just cant find the grouping option that will allow me to edit the footer.

I am trying to put together a report that will allow me to group records by division(not a problem), Then I have to calculate the total spent by each division. This is my problem. I cannot figure out how to add the sum formula into the report. ANy help is much appreciated.

Trying to run a report which takes the text from a filed in the table and then links it to and image file on the hard drive. I ran the report with only a couple of fields and it ran perfectly it displayed the images with no problem. However, when I go to run the report against the ehtire...