Recent content by JohnBlaze

Plextor In your sub report (obviously change to suit your needs) WhilePrintingRecords; Shared NumberVar YourVariableName := Whatever Then in your main report WhilePrintingRecords; Shared NumberVar YourVariableName

I am reading some information from excel into outlook as contacts. I have no problem with that bit. However, I have a custom contact folder that I would like to read the information into. How do i go about setting that in VBA? Thank you John

You could try something like; SELECT Right([FieldName],1) AS Name FROM Table ORDER BY Right([FieldName],1);

What type of data are you reporting off of? Are you linking to an Access DB or an ODBC linked table(s)?

Are you attempting to use Basic or Crystal Syntax within your formulas?

In pass through qurey design, right click on the query window. Go to properties. Under ODBC connect string you will see '...' Hit on that and then set your password/logon To my knowledge with ODBC tables, you save the password when you initialy set up the link to the table -John Blaze

I am having difficulty using Access with it's built in user security. I am the only user with admin rights to the database. However, when I open the database and attempt to edit or add any module, form etc. I get the message that I do not have the database opened exclusively. When I examine the...

I am having difficulty using Access with it's built in user security. I am the only user with admin rights to the database. However, when I open the database and attempt to edit or add any module, form etc. I get the message that I do not have the database opened exclusively. When I examine the...

Trendsetter, Thank you for your response. However, the dates in question will not always be 12/31/9999. Its just that the next documents new date must be higher than the previous documents low date

Hi I have been asked to perform a clean up on our companies contract records, and have not been able to figure out how to do this Basicaly, a contract can have more than 1 document associated to it, and, each document has an end and start date. When a new version of the document is applied to...

Hi I have been asked to perform a clean up on our companies contract records, and have not been able to figure out how to do this Basicaly, a contract can have more than 1 document associated to it, and, each document has an end and start date. When a new version of the document is applied to...

Try the below IF NOT MATCHED IF SFILE BOTH:CITY = SFILE:EXTR-OUT-CITY-NAME BOTH:DRAW = SFILE:STALLY PUT BOTH ELSE BOTH:CITY = HD2:SUB-CITY-NAME...

I have code that looks at a given word document and makes some changes. How would i go through all the word documents in say my C:Data\ directory?

You could also use the fetch command to limit the amount of records returned when using proc SQL ( I believe)

Thanks, I am not sure I understand though. I wanted to populate the textbox based on what query was ran. So that the results from Query2, would populate txtBox2. And when Query3 is passed, the results would populate txtBox3. I dont see how this would work with the code you have sent. Thanks for...