Search results for query: *

Hi all . . . again, I just know I'm doing something stupid here, but I am using Crystal Reports XI on Windows XP. I am pulling against a local Access DB on my desktop. I have designed a report form with a parameter that allows me to select the lab number to see when I refresh the form. I...

Hi again, I am using CR XI for a report pulling from an MSAccess DB. I have a text box that I want to fill with the text "Germination to follow" based on whether or not a data/time field in the DB is or is not null. I have tried the following formula: If Isnull...

Hi all, I am using Crystal Reports XI with Windows XP and am fairly new to Crystal Reports, even though I have used it for years as part of MS Access. I have a report with several detail section. One of the sections, I would like to have print/show based on the presence/absence of data in one...

I have Crystal Report XL running on Windows XP. I have a field in a form that I want to not print if the field is empty. But, what I would really like is for the space it occupies not to be blank and there to be no gap between the line above this field and the line below. Is this possible...

Hi, I'm using Crystal Reports XI with an Access DB on a local machine. I have a report in which for each lab sample there are two company names in the database. I want to be able to print one company name on the left side of the form with the address, etc. and if there is a second company...

Hi guys, I have a question regarding linking tables together. I've run out of my expertise for this, so I'm hoping someone here has a solution (as you always do - almost). I have a table (LabNumber) with a primary key (OldLabNumber) and a field (CompanyID). I want to link that to a table...

Hi all, I'm new to this forum and new to Crystal Reports, so please forgive stupid questions. I have a report in Crystal Reports XI. It has three detailes sections with some subreports. For some reason I can't solve, the three details sections repeat once when the form is viewed in preview...

Does anyone know how to set the default value for a combobox or a listbox? I have a very simple combo box with three values. I want the top value to be the default so the user can just hit enter and select that entry without having to use the down key to select the entry unless another...

Hi guys, Here's the dumb question of the day. I work with VB 6.0 off and on and sometimes can't remember the simplest of things after months pass. I have an established application pulling from a MS Access database. I have added a field to the DB and want to add a simple listbox to the form...

Hi all, I am trying to convert PDF document that is a table to a Word document. I was able to do this last week, but now, for some reason it won't work. If I save the PDF documents as a Word document, I get gibberish. The scanned in PDF won't let me select the table either. I think IT has...

Hi all, I have a table with two columns, CountyId and County name. I want to have a text box on a form into which is typed a county Id number and then have the Name of the county appear in another text box, both drawing from this table. As simple as this sounds, I have been unable to find my...

Hi folks, I'm just beginning to learn .asp and have what is probably a stupid question, or something stupid I'm doing. According to the online class site I'm using, I have to have Internet Information Services installed on my Windows XP in order to run the .asp files I will be creating right...

Hi Guys, I'm looking for a font that will work in Acrobat that makes the zero a strikethrough. I have created my own font and tried that. Word, Excel etc, will pick up the strikethrough in the new font, but not Acrobat. Any ideas anyone?? Kathy

Is there a way during data entry into a form to fill one text box based on the value in another. for instance Combobox "Animal" gives the choice of cat or dog. If the user selects "dog", Textbox "Type" records "canine" in the database. I know displaying data already in a table can be done...

Can anyone point me toward a resource that give examples for the construction of DCount functions plus other functions? Help is not broad enough and I don't seem to find much online speaking to this. kathy

I've been told that it's possible in Excel to have dates display in a color using either the IF function of VBA coding. For instance two days from now I need to open a spreadsheet and see that I need to read cultures because the day's date is displayed in red. Is this truly possible? I would...

Does anyone know if it's possible to put a combo box populated with sample numbers on a form populated and have the selection of that combo box take the user to the record for that sample number? I'm sure this has been addressed here at one time or another, but I haven't had any luck finding...

Hi all, I'm trying to put a value in a text box based on the values from a field on a main form and one on a subform: =IIf([resultelisa]="Positive" And [Forms]![subform1]![subelisaresults]="Positive","Positive","In Process") I got some of this from thread702-733634, but the above gives me the...

Can anyone point me toward some examples of an if statement where 2 conditions must be met? I'm tryin to do something like this: IIf ([elisaresult] = "Positive" and [subelisaresults] = "Positive", "Positive") which of course doesn't work, but that's as close as I can get with Access help...

I have a report with a subreport. I want to count fields on the subreport and have the sum appear on the main report. I've tried this: =count([subreport1]![subelisaresults]) with no success. I've found little help in MS Help. Any ideas anyone?