Recent content by sparx

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.

No takers??

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 have many databases that are built in a similar fashion. But my BE doesn't have any links whatsoever, the FE is the one with the links. I have FE databases that are linked to several BE databases that are sitting on many different servers, and I don't see a problem with it. HTH.

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

Actually, what I really wanted to was to create the odbc itself.

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

Thanks a lot for your help guys, much appreciated. I'll do some research on that.

You are implying that tblTrans2 is a variable. Declare your variables and what value is tblTrans2 holding?

To be honest with you, I'm not sure how this would be possible, what would you suggest?

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

Thanks Pat, I will try and see if that works... Smercer, I don't think you quite understood what I was trying to do, or my explanation was simply poor, thanks for the input. Ciao, 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...