Recent content by k2tile

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.