Search results

  1. Y

    Merge two fields from field list.

    I think the way I am generating table is wrong. Whats the correct way of printing tables in the report?
  2. Y

    Merge two fields from field list.

    No no no!! I just changed the name of column in the table and it worked out well:)
  3. Y

    Merge two fields from field list.

    yes I did. it still kept changing it from "name" to "Name". I have another question. So I want several rows to show up in the table format like this Column 1 Column2 Column3 Row1 ------------------- Row2 ------------------- Row3 ------------------- Row4 ------------------- Row5...
  4. Y

    Mapping of fields

    where do i insert this switch? If I just open my report's VBA code its empty there. How can I make the report substitute all the switches that I have in some sort of function. I need to have some sort of function that will say sub_format that will be run before it opens and substitute all...
  5. Y

    Merge two fields from field list.

    damn. :eek: I didnt develop the database. I am just asked to add a new report to the existing one :( Thanks a lot. I guess I would have to go and change the name of the column in the table where it stores it :mad:
  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.

    thanks that helped and almost worked:) In my field list the MyField2 has a name "name" when I enter that it automatically converts it to "Name", which is the name of the report. How can I enforce "name" and turn off intuitive auto-filling?
  8. 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...
  9. 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?
  10. Y

    Creating a table with multiple rows extracted from the query?

    I see. then report takes it after that with passed filter string. Then how does report know where to get information using obtained filter string? Provided code just assumes that it has all the possible report and will sort out what we wanted. But initially how does it get those reports up...
  11. Y

    Creating a table with multiple rows extracted from the query?

    From the code you provided, all i can see it is doing is creating a filter string and opening a report. but how does it know where to get the information i.e which query to connect to apply the filter string and extract information those rows that matched the search criteria. how can I get...
  12. Y

    Creating a table with multiple rows extracted from the query?

    what is the format of the report filter string? the criteria for filters are given in the previous screen where the user hits the button generate report. it will have the combo box where he/she could select the filter there will be two filters used so two comboboxes will be populated and...
  13. Y

    Creating a table with multiple rows extracted from the query?

    That helped a lot. What if I want to pass the values along when I click report something like GenerateReport(Me.release, Me.round...etc) how can I pass these values and have them used in the code view of the generated report. I want to get the values from the previous screen's buttons(in...
  14. Y

    Creating a table with multiple rows extracted from the query?

    How do I open event? i.e connection to my query Also, for some reason field list doesnt show up on my report design view. I want to grab those list of fields from my query and put them in the right places so they show up there. Pretty much as I said if I use Honda Civic as my filter how...
  15. 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...
  16. Y

    can you update a row in a query using ADO?

    I fixed that part. Paul was right by saing that my data in query from different tables is read-only. how can i fix that? I mean change so it could be updatable.
  17. Y

    can you update a row in a query using ADO?

    is there a way to print the content of rst? I tried doing the old simple way msgbox rst but it didnt work... I just want to see whats going on there after .Filter gets applied to rst.
  18. Y

    can you update a row in a query using ADO?

    strSearch = "[rls]='" & rel & "' and [rnd]='" & round & "' and [acr]='" & app & "' and [init]='" & init_id & "' and [hrs]='" & hour & "'" Set rst = New ADODB.Recordset With rst .Open "QPMES", CurrentProject.Connection, adOpenDynamic .Filter = strSearch .MoveFirst End With QPMES is...
  19. 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?
  20. Y

    Sql Update Syntax Error

    also i use these help functions in my update sql piece. Private Function CheckNull_i(ByVal field As Variant) If Not IsNull(field) Then CheckNull_i = "'" & field & "'" Else CheckNull_i = "'0'" End If Private Function CheckBoolNull(ByVal field As Variant) If Not...
Back
Top Bottom