Search results for query: *

Hey all, A hopefully quick question in regards to file versions. In my office I have just been given a new project to work on with photoshop. The IT staff has put me on the new version (7.0) and the other person working on the images is on 5.5. We have to share some of the files and I was...

Ok, help me before I flip out. Please I have three tables 1 - Dealers - Master 2 - Addresses 3 - Representative Relationships. A dealer can have many Addresses A dealer can have many Reps A Rep can only be assigned to one Dealer A Rep can not be assigned to a Address An Addy can only be...

Hello there, I have been writing VBA for 3years and vb for 1. I am starting to write reusable class modules and I would like to set them up into ActiveX dll so that I can load the functionallity with out loading the actual code. My Problem: I have a Encryption class module, I know there is a...

Hey there. The question come to code reuse in activex dll. I have a simple function that I want to reuse in many MS Access Applications but I do not want to expose it to the end user. Making a .mde is not optional and Access 2k will not let you lock sections of code just the whole project...

Hello there, I was wondering if there was a way to call an API function directly from the DOS prompt. What I need to return is the screen res as a variable in a batch file and then open the shell commend to control the monitor res depending on the answer. Opening the shell control for the...

Hello there. I need some help in writing a Batch file to write an update to a text file. The text file has a modem connection string that needs to be updated on machines aound the network. The idea is to write a simple batch program that will open the file (modem.cfg) which is a standard text...

Hello all, Here is one for the excel guru's of which I am not. I am setting up a Mail Merge to an Excel document. The Excel document has multiple tabs. Each tab has been set to it's own named range. The Word document is a regular basic mail merge document. The problem; When I set up the...

Help with Drivers Hello there, I have a client that is running a SQL Server 2000 and an AS400. What we are trying to do is to update a linked AS400 field through the ODBC driver. The field is packed though. The Error I get is 'ODBC - Update on linked table 'TBLNONAME' failed' Client Access...

Hey there, It may be a simple question but here goes. list in excel 1 100 3 300 6 600 using vlookup with the first field information. 1 will return 100 2 will return 100 3 will return 300 4 will return 300 5 will return 300 6 will return 600 greater will return 600 I would like to...

Hey all, I don't know if this can be done but any help is greatly appreciated. I would like to utilize two separate Stored Procedures, one as a master which will bring in one bit of data that needs to be returned and a slave that will bring in the rest of the data based on two variables sent...

Help with Dynamic formulas. I have a client application the need to have date sensitive formulas for the calculation of some of there reports. We are using MS Access 2000. The formula stucture could change but it will always use one variable and the rest is numeric. It is designed to get a...

Is there a limit to the list box within access 2000? I have a two column list box that is populate manually by the user but it is possable that the user could add up to 7000 entries. Would this exceed any limits on list boxes. The list box is currently linked to a table but I need to support...

Help, I'm trying to set up a report that is about 14" wide to print on to a 11" paper without the report being chopped into two parts. I know that in Excel you can do a 'print area' and then set the paper size. Can this be done in Access 97/2000? The report request is done through...