Search results for query: *

Hi, Does anyone know what combination of switches (R,W,X)..etc That I would need to allow users in a group to add and read files to a netork folder (mapped as a windows drive),...but not delete any files?

Hi Everyone... I have an access report that is launched from a form via vba and the NUMBER pages that are "auto printed" are based on a variable (labelsx) created by running a Mod function on the number of records in the report source. (THE PURPOSE IS TO MINIMIZE WASTE OF LABEL STOCK). i.e...

Hello fellow tek-tippers, The following code creates a post script file from select pages of a word document that I can then open (manualy), with the acrobat distiller within the adobe acrobat 6.0 .exe, and step through the "make pdf process" but all hyperlinks are ignored. So two questions...

Hi Any & All Has anyone had any success with the adobe distiller/pdfmaker and MsWord hyperlinks that contain a subaddress? I.E. ftp://ftp.my_server/path/pdf_file.pdf#page_in_pdf_doc I,ve noticed this issue: When links are "distilled/transferred" to adobe either from within word or from the...

Hi All, Has any noticed that the DCOUNT and DCOUNTA functions do not work correctly if one of the data items to count in the source is only 1 alpha character in length? If so is there a work around or fix? The functions ignore the single character items defined in the criteria and count all...

Can anyone tell me how to return the active page number in word via VBA? something simple like ... X=activepage.number would have been great...but noooooooooooooooo (that would make too much sense) :-) thanks for any help

Hi fellow VBA Dabblers,... Does anyone know how to return if a pivot item is hidden via vba? This code runs but returns false even though many are true ------------------------------ Sub Pivot_Items_Selected() Dim PvtItemName As String With...

Hi Everyone, I am starting in this forum because i'm thinking this might have to be a custom function. I have some records in this format... Ref Class Date_in A1234 3,2,3A 01/01/04 and need it to be this... Ref Class Date_in A1234 3 01/01/04 A1234 2...

I copied an access query, (righ click on query object in the view) > copy ...switch to word doc...>pastespecial>linked. the data comes in and is formatted genericly so I cleaned it up (selecting the table>properties) ...life is good!!!! ...but only for a period of about 15-20 seconds, then the...

Hey everybody, I use the File>Send to>Mail Recipient... command from within Excel from time to time. The problem is after using this option..excel automatically makes the Mail Bar part of the sheet...how do I kill it?

I have an established db that runs a macro procedure to send a query as an .xls via email. This process works on newly created db's and used to work with this particular db. In the db in question, if I change the output type to HTML or text or RTF, all is fine,...only .xls results in an...

Hi, I have am Office XP Word doc with a linked object (Excel sheet) that will not auto update. If I dbl click the object, it will open Excel and reflect the changes, but upon close of the word doc the object reverts to original. I have checked auto update option from the "links..." propertie...

Hi, I bought an old laptop (IBM 750c)..to use as a command center for my home theater... The problem, one week after delivery, it will not P.O.S.T., any suggestions as to where to begin trouble shooting? ...could old bios / ram batteries cause this?

This used to work in Word 2000, but now Word XP runs the code but refuses to actually goto the record. I'm using a mail merged document as a form letter...but only printing one copy based on input from the user. sub get_merged_record() dim PE as string PE="2004-011" 'this value from user via...

Hi, Can this be done in a access query? I have 3 fields,...key, date, comment I need to return both the last comment and the next to last comment for each key. any clues?

Hi, Has anybody seen this... I have a chart that is it's own sheet, on that sheet (on top of the chart) there is a list box (from forms tool) It works fine until I want to change the input range for the box, then the box no longer displays the items in the range. If I create a new list...

In a nutshell... Can an externally powered hardware wedge pass ascii code directly from scanner to an rs232 port? I have a home theater unit that will accept setup commands via a serial port. I don't believe it is powered and i'm not sure if it's 2-way communication. I only need it to read...

Hi, In have a workbook that was created in excel 2000,but running on office XP... I have code that is bombing on the mid() function in more than one sub. ...tells me i need a library installed yet the vba lib.is installed, and it only is erroring in this particular workbook. any clues?

Is there a way in Acrobat to... point to a folder and have all (.doc) files in that folder converted to pdf in a "batch process"?

Hi, I have a table of multiple comments called "comments", each comment has a date, each date & comment combination is related to a master table by 4 KEY fields,... I.E. |--------KEY FIELDS---------| | KEY1 | KEY2 | KEY3 | KEY4 | Date | Comment How do I query just the comments...