Search results for query: *

Thank for the reply. Actually, I used another calendar form I have that is known to work in subforms of other DB's I created. I will step through the code and see where the snafu is......... Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the...

I'm using a small calendar in a subform with the following to call it up: Private Sub Date_Click() DoCmd.OpenForm "frmCalendar", , , , , acDialog End Sub The problem I'm having is when I click on it I get an error as follows: [94] Invalid use of null Any ideas as to why this is...

Thanks Duane, worked like a charm. I copied and pasted the expression into my Query and it returned the values exactly as needed............ Thanks again........ Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

The Expression I'm using Expr1: Nz([Corp_Code]+"/") & Nz([Recip_Code]+"-") & [Agreement_No] works fine in the first five lines of the following example, but the problem I described, comes to life on lines 6, 7, and 8 of the following example. I would like to eliminate the...

After doing a search of this forum, I solved most of my problem with the following expression; ----------------------------------------------------------- Expr1: Nz([Corp_Code]+"/") & Nz([Recip_Code]+"-") & [Agreement_No]...

If you install the full version of Adobe to your machine, you can then select "PDFWriter" from the printer selection menu of the print dialog box. Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi Ken Reay, Thanks for the reply. I will give it a try and post back........ Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi all, How can I make several reports from the same query? Most of my reports are based on the same query so I've been copying the Query and renaming it and then building my reports from the copied query. Some of my reports are based on parameters at run time, others are not. Any good...

What I usually do is print my Access reports to Adobe Acrobat, this way anyone can view the report and all formatting is intact....... Hope this helps.......... Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi gwinn7n, Thanks for the reply. I'll give your Idea a shot tomorrow. It looks like it could simpler, but I'll find out when my head is a little clearer... Thanks again.......... Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you...

Hi again, Thanks WildHare and jbehrne. I'm using the info both of you proposed and it works great. jbehrne's idea about setting the other subforms to false when triggering the current subform is a very simple approach to what I thought was going to be a problem. Thanks again for the GREAT...

Thanks for the replies - I'll give it a go and let you know my progress..... Thanks again for the info.......... Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

I have a database that has one Main Form and I would like to have four different Subforms, calling up each Subform with it's own Command button. Is this scenario possible??? Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi TomCologne, Thanks for your reply. I've tried 3 different brands (Phillips, Imation, and Sony) of CD-R's and none are recognized. I don't use CD-RW's, only CD-R's. Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi All, I've got a Lite-on 32x12x40 CD-RW and have Roxio EZCD 5 with updates. My problem is that the drive will recognize anything I put in it except a blank CD-R. I've already run the repair from the Roxio CD and re-ran the update for the drive but I still can't get the drive to recognize a...

Hi JohnVDB, Glad it worked out......... Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

Hi JohnVDB, Try going to this site and get his "Label Saver Database" and give it a whirl - it works great for me....... http://www.peterssoftware.com/ls.htm Please Post back, so other can benefit too. Later JohnSteven "The only stupid question is the one you don't ask"

How is it possible to set a Label's properties "to shrink" or "to grow" as these are not options allowed a label????

I have a report for Interoffice Memos and need a little help. The problem is in the "CC:" field, if there is no person to "CC:", how can I get the report to print without showing a blank "CC:" field??? What I would like to do is if there is nobody to...

Hi All, To anyone who has been following this thread, Paul Bricker has come up with the solution and my hat is off to him. Thanks again Paul....... The solution is as follows; Expr3: [CopyTo1] & Chr(13) & Chr(10) & [CopyTo2] & Chr(13) & Chr(10) & [CopyTo3] & Chr(13) & Chr(10) & [CopyTo4] Hope...