Search results

  1. J

    Changing the sort order of a union query

    I have a which combines the results of a few other queries. When I run it, Access automatically sorts it alphabetically on the first column. Instead, I would like it to preserve the order in which the input queries are written. ie, SELECT Content FROM qryFormatT1 UNION SELECT Content FROM...
  2. J

    Copy Tables and Create Links with SQL Backend

    I have 2 tables, A and B, in a 1-1 relationship and on an SQL backend. With my Access front end, I would like to be able to make renamed copies of these tables on SQL, create the 1-1 relationship between the copies, and link them down to my front end. To make the copy, I was going to use...
  3. J

    Data mismatch in criteria expression

    I have an unbound text box that will update a table after the text box is updated, however I keep getting the above error when the event runs. The query runs if I comment out the where clause, and I can't see where there is a data mismatch. They are all strings, and the fields are Text. Is...
  4. J

    Populate text boxes from a combo box query

    I have a combo box that is based off a query returning 5 columns. The first column is the row source of the combo box and I want to use the other 4 to populate 4 text boxes on the AfterUpdate event of the combo box. The second columns' text box fills properley, however the others do not. The...
  5. J

    VBA runs incorrectly when multiple are records included in a report

    Thanks to assistance I recieved here a few days ago, I was able to re-run my code on each new record's Format event, which essentially would check if certain fields had any content and would make the bound text boxes visible, and move them to a position relative to other text boxes that were...
  6. J

    Show or Hide different controls for each record in preview

    I have a report with a series of controls, whose visibility and position change depending on the record. When I preview the report before printing, it formats which controls are visible for the first record only, and all other records follow that template even if they need to show something...
  7. J

    Update with multiple records

    I have a table of names and points: Name -- Pts1 -- Pts2 -- etc I have a second table which I would like to store the sum of all the points in a record. Table 1 Name1 -- Pts1 -- Pts2 Name2 -- Pts1 -- Pts2 Table 2 Name1 -- TotalPts Name2 -- TotalPts I am trying to perform the calculation and...
  8. J

    Apostrophe interfering with form filter

    Hi Everyone, I have poked around this and other forums looking for a solution to this but I haven't been able to find something I can adapt to my needs. I have a form with two combo boxes, the first limits the selection of the second. The second applies the filter to the form and is a list of...
Back
Top Bottom