Search results

  1. K

    select a record X number of times

    How do I select a record X number of times? This is for a printout of sticky labels to apply to products...X is the quantity of each product. If we need to label 100 of part A, then I need to select that record 100 times and feed it to my report. Thanks
  2. K

    Question can import external data on one computer, but not another

    Something strange is going on. On one computer with Access 2007, I'm able to import data from any source whether it's a .csv, xls, .xml, ODBC, or any of the other supported sources. It steps me through the whole process and everything works great. On another computer I can only import data...
  3. K

    data entry through a PivotTable form?

    Hi, I have what I think (hope) is a simple situation. I'm trying to edit data presented in a pivot table form. This form was created from a single query, and I'm able to edit the data when I view the query in Datasheet mode. What do I need to do in order to view the results of this query as a...
  4. K

    no advanced options appearing during import/export

    I am trying to follow the instruction at : http://www.btabdevelopment.com/ts/default.aspx?PageId=25 and am not getting the expected results. After I've selected a file and click OK, the wizard instantly closes out, rather than proceeding to the next step where I would specify the delimiter...
  5. K

    refreshing queries prior to UNION

    First of all, this board is great. So many people posting questions and answers. I've only been using Access for a week or two so I don't have many answers yet, but once I do I'll definitely be here helping others. My question is, how do I force a query to refresh itself when it's being called...
  6. K

    reusing a query field

    Is it possible to SELECT AS into more than one field? I'm writing a large query where many of the output fields happen to the be calculated with the same formula. Any idea if this can be done directly within the query?
  7. K

    double cartesian product??

    Hi, First post to this forum so take it easy on me! I'm also a first time Access user. What I'm trying to do is generate a list of product and color combination. Think T-shirts in small, medium and large. Actually, my product is tile, which is glazed according to different glaze codes. Our...
Back
Top Bottom