Recent content by eddy

I have a contract in a Word document. I want to click a button on a form in Access and open up the contract to print but put the client information and items in the appropriate place. Can anyone help or point me to the right documentation to do this? Thank you.

I thought it would be useful but it still returns only 4 for me instead of 4 for each invoice :( This is what I used. SELECT CSNotesDetail.* FROM CSNotesDetail WHERE (((CSNotesDetail.ID) In (Select Top 4 [ID] From CSNotesDetail Where [ID]=[CSNotesDetail].[ID] Order By [ID] Desc)));

Hi, I have a a table that keeps notes about the status of an invoice. It can have 1 or a lot of notes per invoice. I need it to just display the last 4 notes for each invoice. I used TOP 4 but it only shows the top 4 notes and note the top 4 notes for each invoice. Can anyone help?

Perfect. Exactly what I was looking for. Thank you sir.

Is it possible to print just certain objects on a form? What property do I use for this if it's possible?

This is my problem. I have a table that tracks the status of an invoice. It can be that an invoice goes through 5-10 status' before it is paid. So let's say, first time, it's on call, second time collection, third time in payment, forth time needs to be verified that it paid, etc... Table has...

I have these fields ID,InvoiceID,DateEntered,Description What I need now is to show the most recent transaction per invoice and what was the description for it. Doing this SELECT InvoiceID, Max(DateEntered) AS MaxOfDate FROM TableName GROUP BY InvoiceID; Works Perfect. The problem I have is...

I am trying to do a deposit list and I need a blank line after every 15 deposits printed. My deposit number is generated directly in the report and not in a table. It has the deposit number, check number and amount. It should look something like this. 1 #4454 $660 2 #4554 $6650 3 #7454 $3260 4...

Just wanted to mention that I did create one last week for the same printer and it works fine. I can select the paper size in the report. It's the one I am creating now that doesn't show up for some reason.

I create a custom paper size by going to Printers and faxes, selecting the printer then clicking File, Server properties and saving the custom size. I go back into access and page setup my report. I click on Use specific printer of the page setup of the report. But when I select the dropdown...

What do you mean by that? Should I be formatting it as MM/DD/YYYY before I write to the table??

I have a query that pulls out a date. It's value is 05/10/2007 as DD/MM/YYYY Then I do a basic sql statement via a recordest with this code UPDATE TempValues SET LastShippingDate = #05/10/2007# The problem is the way it gets stored in the table. I see it as 10/05/2007 DD/MM/YYYY. The format...

Sorry guys, you are right, it should be with a [] around a name without the _ but the # instead. I really don't know why I was using the underscore. Long day :( Thanks for the help all.

That didn't work either. I've tried with table name in front also. I'm totally at a loss on this.

I have a problem. One of the fields in my table is called item#. I am opening a recordset and using item_ as the field name in the sql statement but it keeps failing because of it. Does anyone know how to fix it? Or can it be fixed at all? The sql statement was very simple. SELECT item_ FROM...