Search results for query: *

Hello all, I want to export my fields, types and descriptions from Access to Excel. I do not want to export the data itself, just the fields, types and description of fields.

Okay when I export the data into Notepad, I get a bunch of garbage...Commas, spaces...etc. It does not look like the format I sent to you earlier. See first attachment.

How?...Would it be like I have it in Crystal Reports? I did a query in CR and formatted the data as requested by the recipient. This was done because the formatted data that came with an already existing application stopped working. I guess I do not understand the concept.

Will you send me an example on how to do so? I have no idea at this point.

It has to be sent in text format or ASCII format in Notepad.

I am using Access 2007 and I am trying to develop a small application for tax purposes. What I need to know is what is the best approach to exporting or converting the data in Access into a text file to be sent to recipient in the correct format. Here is what I have now...but this is hardcoded...

Hello all, I am needing some kind of direction on how to create output and input forms in Access. I know nothing about Visual Basic, however, I am needing to create Tables and Forms to store the data into Access. My question is this...if I just import the external data from Visual Basic into...

I have a gentlemen that has built data and codings in VB and I want to store the data in Access...what do I do next? I know how to build tables in Access, however, I do not know what I need to do to store this data in Access. Help me wrap my brain around the concept. Any help will be...

Thank you so much to both CR85user and lbass for the solution. Yes, both work just great! Again, thanks! austin22

Hello all, I am using Crystal Report XI. I need a simple formula that will allow me to do a range on a list of last names. For example, I would like to see all last names that starts with range of A-L...this is what I have now: {DefLastName} startswith...

Yes, I've used Crystal before... Yes, I have linked the two tables... The two tables are: {Case Physical Table} and {Case Transaction} both are linked by the case number. The report is grouped by the case filed date and then grouped by the case closed date (these fields are found in the 'case...

I am using Crystal Report 8.5 and I want to calculate how much revenue collected in a particular year. I am having a hard time thinking this through... Say that I had 176,000 cases filed in year 2003, and 55,000 of the cases filed were closed in 2003 due to payment. I want to know the revenue...

Thank you so much...it make sense to me now. Have a great day! austin22

Can someone interpret this formula? NumberVar DoBVar := IIF((100 * MONTH(CURRENTDATE) + DAY(CURRENTDATE)) < (100 * MONTH({Case_party_PHYSICAL_TABLE.CP_DOB}) + DAY({Case_party_PHYSICAL_TABLE.CP_DOB})), 1, 0); NumberVar YrsVar := DATEDIFF("yyyy",{Case_party_PHYSICAL_TABLE.CP_DOB},CURRENTDATE) -...

You are great! That worked for me. Have a good day! austin22

No mistake. The complaint form is a Filing Action Type and the docket is an Event Action Type. However, the codes "NJT" and "COMPL" are both in the ACTIONCODE table: Like this: ActionCode ActionDesc ActionType NJT Non-Jury Trial Event COMPL...

Hello All, I am using CR 8.5 I may have asked this question before, however, I cannot find a thread to answer this question for me. I want to create a list of cases that are set on a particular docket and identify those cases that may need a complaint form. If complaint form is already on...

Yes, CNumber is the same as case number and the report is grouped by the CNumber. Sorry for the confusion. I figured out what I did wrong...I had the wrong criteria in my Group selection formula. The report works just fine. LB, thank you so much for your patience. [thumbsup2]

Thank you for your response. I still get cases with either one of the 'letter' or the 'complaint form'. I want the report to display cases that have both the letter and the complaint form on one case. Then suppress the cases that have one of the other. At first, I thought the formula worked...

Continue... The {CASE_PARTY_ACTION_PHYT.JEboA} is the CNumber and my report is grouped by the case number.