Search results

  1. Y

    Apostrophe

    When I try to enter a text with the apostrophe inside the text box and hit save button it keeps adding apostrophes near my apostrophe I guess to close the opened apostrophe. How can I save the apostrope without having additional ones every time I hit save? Thank you
  2. Y

    Keeping table headers on next page?

    So I have a table that spills to the next page if it doesnt fit into one page? I want my table header to be appearing if report is more than one page. How can I do that? I tried so many things and cant figure it out. Right now it is like this: COLUMN1 COLUMN2 ROW 111111111111 ROW...
  3. Y

    How to hide a row in table? (not make invisible)

    Hello, I am trying to skip my row in the table. I tried using textfield.visible = false but it prints the white space instead of a row, which i dont want to print.
  4. Y

    not printing rows in table in report?

    When I print the table I want certain rows not to appear on some criteria in my case rows that have one column field < 200 hours. how can I do that?
  5. Y

    Exporting report

    I have a report shown in print preview. How can I save it word ? I tried export - rich text format but this method eliminates all the table borders and formatting that i used except the text itself. How can I save it some editable format that will save them exactly as i see it on the report...
  6. Y

    Mapping of fields

    On my report I pull out fields from Field List and they show up on the report when I run it as 0,1,2 how can I map them to something else that I want to show up instead? Like A, B, C
  7. Y

    Merge two fields from field list.

    Please help. I have a field list and I dragged two items to my report in the design view. When I preview report it all look just fine. How can I merge two of these items into one. Lets say one shows up in the text box field as Field1 and the second one as Field2 How can I make them show...
  8. Y

    how to enable the Field List?

    I am trying to link the values in the query and the field in the design view of the report and Field List is not pressable. Its shadowed. How can I make it usable again?
  9. Y

    Creating a table with multiple rows extracted from the query?

    I need to create a report that will have a filter that has to be selected before it is generated. For example I choose Honda Civic as my filter criteria I need my report to print a table that will print all the Honda Civics that I have in the query along with all the related information...
  10. Y

    can you update a row in a query using ADO?

    I am trying to update a query using ADO but it seems like its not working it gets the empty recordset and shows an error saying BOF or EOF. so i came to conclusion, is it really possible to update a query and not a table?
  11. Y

    Sql Update Syntax Error

    keeps giving me the SYNTAX ERROR UPDATE for this chunk of code. got stuck here for a while, could someone point me to an error. i am simply giving up on it after this point. sqlUpdStr = "UPDATE PDDEstimates SET" & _ "DesktopComplexity = '" & CheckNull(Me.Desktop_impact_cbx.Value) & "' ...
Back
Top Bottom