Search results

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

That's all it was.

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...

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...

Step 1 Step 2

Sure... Then I click OK in that window and nothing happens.

Tried with that checked and unchecked. Can't get to the advanced options either way. :(

The access file and source data are all in the same folder, which I added to the trusted location. Still no advanced options... I am only able to get through the first four screenshots from your tutorial.

I have not. I'll research that and give it a try. I'm very new to Access by the way. I did try your suggestions from 2003 per http://www.access-programmers.co.uk/forums/showthread.php?t=37696&highlight=export+wizard

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...

Hi Bob, Just checked out you site. Excellent stuff! I'm following a couple of your tutorials tonight and will be putting them to use tomorrow. Looking forward to your reply in this thread. Also in my other thread about reusing the same field...I'm not sure why I didn't realize earlier, but...

Here goes... SELECT [ATTRIBUTES]![Attribute] & "-" & [FORMS]![Form] AS PartNumber, [FORMS]![Description] & " in " & [ATTRIBUTES]![Name] AS PartDescription, [FORMS]![Details] AS PartDetails, [FORMS]![UOM] AS UOM, " " AS UPC, "10" AS PartTypeID...

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...

Thank you everyone for your help. I'm going to try writing a function. That seems like a really nice concise way of handling this.

The values are literally exactly the same. This is for import into sales/inventory software. The software has several different fields for alternate product numbers (internal SKU, vendor code, product code), but we just want to use the same value for all these fields.

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?

Thanks for the advice. I actually ended up revising the structure to make the table more normalized. Now have another problem. I've further separated the glazes from the products(renamed to "form") by use of some many-many joins. Now I'm getting an "ambiguous outer join, please write your...

I forgot to mention that the field Series exists in both the Glazes table and the Products table. They're totally unrelated. Not sure if this will affect my final query but I thought I should mention it. Thanks again

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...