Search results

  1. C

    Can't get rid of border around list box in report

    are you sure that the transparent is set on the border or the text itself? It won't show blank data if you only set the transparent into border.
  2. C

    Sub Report - not displaying field labels

    I faced the same probelm, too. My solution for this is to copy the title from the Sub Report and place it right into main report . It will show as exact the title in sub report. If you want to know the setting to simplify the process, I wish there is someone know how to do it.
  3. C

    Textbox on Report resizes by itself

    just make sure your fields in the Detail, the property of 'Can Grow' turn to 'Yes'. Hope it will solve your problem.
  4. C

    Anyone know how what's the code for detecting Form is loaded from other database

    I am looking for the code to detect another form being loaded in another database, and return the path directory. Is it possible? Anyone can help? Thank you.
  5. C

    Append query in code

    thx John, Steven. I solve the syntax problem eventually, the code should written this way Dim dbs As Database Set dbs = CurrentDb dbs.Execute "INSERT INTO TempTblTransac SELECT * FROM [4TBLTRANSAC];" dbs.Close
  6. C

    Append query in code

    oh! this is what I have tried but it was not work. the code stop at qry.execute command
  7. C

    Append query in code

    Anyone know how to write code for append query in VBA. the append query can change the attributes based on the criteria. it looks something like that... if condition is true then append field 1, field 2 else append field 2, field 3 end if
Back
Top Bottom