Search results

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.

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?

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

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

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

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

I need to set a value of a text box to the 3rd field of a query when I click a command button in the form. It'll run the query, extract the 3rd field and show it in the text box. Can anyone show me a snippet of code that would do it or something similar?

I have a query that has 3 fields and gets the values I want. What I am looking for is how to get one of those values into a field on my form after I make a selection from a combo box. The query uses another query to get its results.

Hi all. I have a little issue at the moment. I'm stuck on a report. It has a grouping on Collector for an account. Then shows how much they collected and who was the salesperson for a file. Example (sp is salesperson. It is sorted by salesperson name) Collector: John SP Total A 100 B 200...

I'm trying to get 2 reports to become one fax in winfax pro. If I send 1 it works well. Trying to send a second will cause winfax to start a whole new send fax procedure. Does anyone have experience with this. The code I am using is as follows: Private Sub cmdFax_Click() Dim objWFXSend As New...