Search results for query: *

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

But wont that make the logo appear on every single page? The report, which is actually a letter, must have the logo on the first page only.

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

Hi, just passed my SCJA exam yesterday and I found out today that there is no logo for this exam. That is unfair. Did anyone else get the logo?

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?

Hi guys, Sorry abt my last post. I got it. Thanks to Remou.

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

Thanks. That worked perfectly.

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