hi,
Thanks for all your help. Eventually what I did was remove all the headers and brought the logo down to the detail section of the report. The report was already per customer so I did not need the group header. It worked finally.
thanks again.
Ok. So now I have the logo as part of the group header. So, the logo does not appear on each page, which is great. However, the logo does not appear on the first letter and it is appearing on a seperate page before the letter (but not for the first letter though.This is happening from the second...
Yes. The logo is correct. I think I can explain better.
My letter is two pages long. There are like a hundred letters that are to be printed each time. I need the logo to appear on the first page of each letter only. But right now, I removed the report header and placed the logo as the page...
Hello all,
I am a little unfamiliar with MS access reports,which is why I am struggling with what seems to be an extremely simple problem.
I have a report header which must display a logo at the start of every report. My program prints out multiple reports at a time. The problme is the report...
Here is the statement that is causing all the trouble.
a - table in local db
b - table in remote db, accessed through db link
merge into a
using b
on (a.id = b.id)
when matched then
update
set a.spec = b.spec,
a.mctn = b.mctn
id is the primary key for table b.
when I run this statement...
Hi all,
I have two tables residing on two different servers. I am trying to update table 1 with values from table 2 using a merge statement and I get this error. I am not sure what it means. Any help?
I get an error saying invalid procedure call.
This is the code I have
Public Function CurrDB() As String
On Error Resume Next
Dim tdf As TableDef
Set tdf = db.TableDefs("name of my linked table")
x = tdf.Connect
CurrDB = x
End Function
Where am I going wrong?
Hi all,
Right now, I have this code in my VBA module. One of the columns in my tables is the name of the database.
Public Function CurrDB() As String
On Error Resume Next
Dim dbs As Database
Set dbs = CurrentDb
CurrDB = dbs.Name
End Function
But instead of the name of the database, I need the...
UPDATE a
SET EFF_DATE = CONVERT(CHAR(10),b.EFF_DT,101)
FROM b
WHERE b.TYPE = 'c'
AND a.CK = b.CK
AND a.TERM_DATE >=
(SELECT MAX (b.EFF_DT)
FROM b,a WHERE b.EFF_DT <= a.TERM_DATE AND b.TERM_DT >= a.EFF_DATE)
AND a.EFF_DATE...
Hi,
Thanks Denny. That is what I did finally.
i am wondering if you can help me out with something else.
it is an update statement again, and I want to update a date column in table a with values from a date column in table b. The values from table b need to fall within a date range and I...
Hi all,
I have this statement. I am trying to update a column in a table using values for a column in another table.
UPDATE a
SET DIAG = (SELECT b.ID
FROM b ,a
WHERE b.ID = a.ID
AND b.TYPE = 'c')
WHERE a.ID =
(SELECT a.ID
FROM b,a
WHERE...
Hi,
Well..what I was trying to say earlier was that I have two reports that are generated based on queries (obviously). As a user interface, I have a form where in users can enter parameters which are passed to the query, which will then generate the report. That is the set-up.
When I try to...
It is part of the query code.
When I input a 0 in the form, it gives me that error. But, when I give a different value, like a 1, it seems to be running. This is happening only when I use the form to generate the report.
When I use the query, I can input 0 and it still works.
Hi all,
I have a form which contains a report that is based on a query. When I run the query itself, it works with no problem at all. But when I try to run the same query from the form, I get a message saying the expression is too complex to be evaluated........
I think the problem is with...
Hi all,
I have been trying to set a default value in a text field in an access form, but something seems to be goin wrong and I am not sure what.
Basically, I have a text field in a form whose value is passed as a parameter to a query, which generates results that are displayed in a report.
I...
Hi all,
I am not vey familiar with access, hence this question.
I have a form which has a text box. Users are meant to input a value (character string) into this textbox. Based on what they input, this string needs to be passed to a query which will then generate a report.
I am using the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.