Recent content by paulfla

It is our server and we have complete control of it. Would you happen to have any source code examples? Thanks again.

I wish it was that easy. The vistors print selection needs to print on our Color Copier Print Press Machine. I believe the code above will print on the vistor's local printer. I don't want that. Thanks for your response though.

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

I need to be able to open the Photoshop CS file in Photshop ver.6 on another PC with all the layers available. Does anyone have a solution? Thanks in advance for your time.

How can I open a file created with Photoshop CS on an older version namely version 6?" Was there a solution found for this?

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

@ character means that information is being requested for the query. That is why I am passing: - s_invoice_nbr - s_date - s_jobjacket_nbr in the statement Set rs = oConn.Execute ("exec sp_upd_gadocard_oi " & s_invoice_nbr & ", '" & s_date & "', " & s_jobjacket_nbr & "")

Here is the sp_upd_gadocard_oi query in Access. As you will notice, it is referencing two othe queries, sp_OrderTotal and sp_OICardQty. I'm guessing I won't be able to just paste this into my ASP page.??? INSERT INTO gadocard1 ( id, invn, rcdat, div, loc, tsell, stax, totchg, shipq, fname...

Thanks so much for your replys. I don't think it's a problem with the path oConn.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\inetpub\wwwroot\xyz\ABC_V1.mdb") When I change the query sp_upd_gadocard_oi to update a regular access table, it works fine. When I change query...

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

Did you ever find a solution for this. I am experiencing something similar. Here is my code <script language="JavaScript1.2"> <!-- # Below is the Maximum Order Quantity Logic # //--> function doMaxOrdQ() { var entered_qty = document.qtyForm.f_ItemQty.value var maxordqty =...

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

Got It! Finally. [2thumbsup] It was a combination of this post and another post that was exactly a year old http://www.tek-tips.com/viewthread.cfm?SQID=627416&SPID=333 thanks to nevermoor for his post and DreXor for making me think about the "garbage in" part. Since I was getting the...

one other thing, % and & are messing up the INSERT also

In the function,the code below is giving me a "unterminated string" error: sqlhandler = replace(replace (strtext,"'","''"),"""",""""") Do I need to add another double-quote?