Search results

Anyone know how to modify a range from being sheet-level to workbook level? I'm importing sheets into a new workbook, and the ranges are copied over as well, but they are only sheet-level, I need to make them available to the workbook. Any ideas?!?! Thanks in advance.

I simply want to know where you can find info on the 'auto dialer' or something along the same lines. Ideally what I want to get done, is have a program run through a list of phone numbers and dial each one, one at a time, and as soon as the person or voice mail picks up, I run off an automated...

I need to find a way to search through all our existing databases and retrieve all the links. I need to know what database has linked tables in it, and where these links point to. Any help would be greatly appreciated. Thanks, Erik

I created my ODBC and can link to tables from Access to our AS/400 mainframe. I can update, append and delete to and from any of the tables. My question now is, I would like to create a table from an Access database to our AS/400. I simply want to know if this is feasable. If so, any ideas...

Does anyone know where I can find some valuable information on a step-by-step process on how to link as/400 tables to an Access database?? TIA, Erik

Is there anyway to have MS Access generate different types of barcodes upon user entry??

I have over 500 winzip files, does anyone have a clue how I can unizip this files without having to do this manually. Thanks for your help, Erik

Hi there, I have to print a report that is over 7500 pages long. It was be a waste of paper to print it single-sided. My printer is capable of double-sided printing, that's not my problem. My problem is this. My page numbering on the report resets itself when a store number changes...

Is there any way that we can avoid having to compact and repair a database?? I know there are certain ways to be able to bypass this step and still have the size of the database remain stable when importing a bunch of files and then deleting them (eg creating dummy dbs to hold the blank...

I have this little bit of code which I extracted from VBA. I need to convert it to a script. The VBA function 'WGetComputer' is not available in VBScript. What this code does is it simply returns the name of the current computer. Dim lngLength Dim lngActual Dim strComputer lngLength = 16...

I would like to know the function that would return the computer name that is currently running the database. Any and all held is greatly appreciated. TIA, Erik

Is there any way to search through SQL statements and/or VBA code without having to open the actual form or query?? TIA, Erik

I would like to open an instance of Excel, but no workbook in particular, therefore, by default, Book1 would be the worksheet to open up. Upon opening excel, I would like to run an excel macro, and then close excel. I've searched for this but haven't found a way to open up excel. Any and all...

I know this is a little off topic, but you guys have all the answers!! I need to rename a file as such: current file name: puro.88344 to be renamed to: puro.20031015.88344 Does anyone know the command line to execute this renaming? Also, I have about 300 files like that eg.(puro.94323...

Is there a way, I'm sure there is cuz Access can do it all, to automatically zip a specified file. I would like to zip it as soon as I export it. Any help would be greatly appreciated Thanks, Erik

I know the property exists in Excel, but can I shrink the font of a control depending on the size of the text, while keeping the control the same size?? TIA, Sparx

I need a function that will convert a julian date into a regular date (ie 2003-03-06). Anyone have any ideas. TIA Sparx

I am creating a query where fields are all fixed width. When the field is numeric I fill the field with zeros, when the field is text, I fill it with empty spaces. The problem here is that the empty spaces get added before the text, but I want the empty spaces to get added after the text...

I am writing to a file, and VB automatically put a carriage return after the final line of the written file. I cannot allow this. How do I get rid of the blank line? TIA, ERIK

I am running code in vba that is using the Write command, and I am creating a text file that is delimited by * and is also fixed width. After every line, there is a separate delimiter which is the semi-colon. But the problem I have is that by default, quotations get added at the beginning and...