Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aspiringprog

    Report Header problem

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

    Report Header problem

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

    Report Header problem

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

    Report Header problem

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

    Report Header problem

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

    SCJA logo

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

    ORA-02064: distributed operation not supported

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

    ORA-02064: distributed operation not supported

    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?
  9. aspiringprog

    Question about database name

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

    Question about database name

    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?
  11. aspiringprog

    Question about database name

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

    need help with update statement

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

    need help with update statement

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

    need help with update statement

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

    problem with reports/forms

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

    problem with reports/forms

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

    problem with reports/forms

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

    setting default values in a form

    Thanks. That worked perfectly.
  19. aspiringprog

    setting default values in a form

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

    passing parameters from forms to query

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

Part and Inventory Search

Back
Top