Search results for query: *

This is what I've been asked to do: ------------------------- I want to be able to have a website create print jobs: Go online select item(s) from list/form. Postscript or pdf file associated with item(s). Submit order sends print job(s) to color copier, ideally with quantity ordered. Also...

Page maker newbie here. I have a business card template that performs a merge with a .txt file. On the business card, the person's information builds from the bottom of the card up. They can have up to three different phone numbers and the address is optional. The Name must be in bold. Since...

I sure hope I can explain this well: I am displaying a form on an ASP page that allows a user to enter an invoice number, Date and Job Jacket number. The entered info is used in a Access query that has two tables and a couple of sub queries to come up with the totals and updates a FoxPro...

My SQL knowledge is limited so please be patient with me. I have a table with 4000+ rows in it. I need to extract every 12th row from the table and insert it into a new table. Can you please tell me how to do this? Thanks in advance for your time. Paul

With an MS Access database and ASP, I want to insert a row. The problem is that one of the columns, which is the iten description, may contain characters like a single quote ', double quotes ", pound signs # and any other character. When I perform the insert, sometimes the update is...

Hi everyone, I really appreciate all of you experts that take the time out to help us VB challenged people. :) From VB6, I am able to execute a query in my MS Access database. This query has parameters that I pass. It runs the query but the values are the actual variable names "var1" and...

I have an append query where I want to set two columns with the same user entered data. I places data from one table into another. When the query runs it ask the user to "Enter The Client ID". This entered data should be contained in all the rows of "Column A" and "Column D". Below is what is...

I would appreciate your help. I'm using VB6 with Access 2002 on Win 2k I want to automatically export a report from Access 2002 as an excel file. Iwant to call the VB exe from the Task Scheduler. When I run the Visual Basic 6 code is says Runtime error '3011' The Microsoft Jet Database...

Hi everyone I'm pretty new to MS Access 2000 and I have a question. Why should an AutoNumber field NOT be used as a primary key? I ran across the following info below on a web site. Can you all enlighten me please. Thanks so much in advance for your time. Each table, that might be used as a...

I have two different tables that have the same structure. I want to create a report that will display only those rows that may be potential duplicates. Duplicates being based on first name and last name columns. The tables contain a person's record id, first name, last name & address...

I built a query that works in Access 2000 (A2k), but not in Access 97(A97). In A2K I used the Convert Database, Prior Access Database Version. So I could use the DB in A97 on another PC. Here is the code in the query field: zipformat: IIf(Len([ZipCode])>5,Left([ZipCode],5) &...