Search results for query: *

Is there any way that I can format a field in my table to take a fraction? - I realize that I could just make it text and write it manually, but I want to be able to total it as a real number in a query. I see that Excel can do this, but I can't figure out how to format for Access - I don't...

Hello, <br><br>I have a report that lists meetings and their status letter, grouped by their related account.&nbsp;&nbsp;What I want to do is get a subtotal on each Account of how many Definite-status (&quot;D&quot;) leads there were per account - not a subtotal count of all meetings, JUST the...

Hello, <br><br>I can't quite figure out how to do this - do I need SQL? ...I am a newbie at it<br><br>I have households of customers(all grouped by a unique household group id number) and the magazine (represented by a magazine code) that they responded to.&nbsp;&nbsp;What I want to create is a...

I have a report in which I am grouping data together by unique address. I want to create a total in the footer of the report that counts the number of unique addresses from the address field - so I can see how many address groups I have in the report.&nbsp;&nbsp;All I see in Access is the COUNT...

Hello, <br>I am using Crystal5 and was told that it is not possible to total off of a number in a group footer- is that really true?...this is my situation:<br><br>I work in the travel and tourism industry and have a report that tracks meetings booked in my town and the hotel - or hotels - that...

Hello...<br>I am trying to recreate an example I found in the MS Access97 Step By Step book p.179). It is where you create a dialog box (form) using a list box to pick a record to go to a specific record on the main form.<br><br>This is the code from the book, modified for...

Hello, <br><br>Has anyone used any of the merge/purge or &quot;dedupe&quot; mailing list scrubbing softwares out there that claim to &quot;plug into&quot; Access directly, instead of having to export out a file?<br><br>Thanks

Hello, <br><br>My goal is to create a database of names of email respondents to our website.&nbsp;&nbsp;I have all incoming emails in a folder (in Outlook97).&nbsp;&nbsp;I am using MS Access97 with the &quot;link to Outlook&quot; free plugin in order to hook the two.&nbsp;&nbsp;I can pull the...

I bet this is an easy one, but I just need someone to help me understand the basic concept - I've never done this before...<br> <br> I have a form (form1 )and a subform(form2). When data is entered on form 1, a customer number (an autonumber) is generated. This number and the other data is then...

Hello, <br> I know this is easy, but I am new at this.....<br> I am trying to create a button that will open directly to a document of a registered app on my machine (in this case, Crystal Reports) What's below doesn't work. <br> <br> In other words, I want to open the Crystal Reports report and...

Hello, <br> <br> I'm trying to use the above free MS utility to import my Outlook emails into an Access97 database. My problem is that the import will not read the entire body of the emails - In the import boxes, I see the &quot;¦&quot; symbol, which I assume is a hard return. When the import...

I am trying to use Crystal 5.0 with Access97 databases I have created (I've done this at home - it just won't work at my office...I suspect I have a setup issue?!).<br> <br> I get these error messages when I try to open any Access database:<br> &quot;Config Error: The Library...

Hello, <br> <br> I have a small rolodex program that I have created with Access97. It has a front-end form that users use to lookup info. Is there a way to track the number of times that each record is accessed? I want to be able to see the most popular entries as accessed by the users.<br>...

I still can't make this thing work!!!<br> I've tried what I find in books to make the final resulting calculation (in LblEI.Caption) format for currency, but I can't get it to do it. As it's set up, I get a &quot;.&quot; instead of a &quot;,&quot; and if the last number in the answer is a...

This is a newbie question --- I have created a small program in VB6 - compiled as an EXE - from home on my Win95 OS machine. I take the program to work to run it on NT4 machines and I get a message &quot;Class not registered. You need the folowing file to be installed on your machine...

Anyone out there using Crystal and the Newmarket CVB database product CVBreeze???

In an Access97 database, I want to track respondents to direct mail campaigns. I track the name & address of those who respond to the campaigns, and code their name entry with a unique campaign code (MediaCode field) Each &quot;line item&quot; of name, address, mediacode is entered into my...

I have an Access97 Database (I realize that Access has it's own SQL &quot;flavor&quot;)where I want to track respondents to a direct mail campaign. I track the name & address of who is sent the campaign and code their name entry with a unique campaign code (&quot;MediaCode&quot; field). When...

Is there such a thing out there as a book like &quot;Learn MS Access97's SQL Language?&quot; I understand that SQL comes in different &quot;flavors&quot; but as a beginner, I'm frustrated that I seem to have no definitive source on MSA's version of the language - I was told that MS SQL Server...

I am trying to currency format a label field (the final calculated result--LblEI.Caption) in a small calculator program I have written. I keep going over and over solutions in my books to try to make this label format the result as currency. The closest I can get it is below -- I really want...