Recent content by nyamrembo

I got it figured out. Made the checkbox invisible then added a label with a line which will on show the line if the checkbox is false. Happy Holidays to All of you wonderful people at Tek-Tips [sunshine]

Thanks for the info. Now I am thinking about displaying the checkbox value as line if condition is false. If I can accomplish this, then there will be no need to export to excel. Do you know how I can do this and where would the code go on the report? Thanks again, [Sunshine]

Hi, I have an access report that has a checkbox field on it and I want to export this report to an Excel spreadsheet. But when I export the report, the checkbox part on the report does not show up on the excel. Does anyone know how I can a achieve this or if there is a better option. Thanks...

Hi Daniel, I tried the above code and placed it on the report form but it did not respond. Am I doing something wrong? I replaced the name of my report filter form with frmCallingForm. And I have a form with radio buttons and a command button that opens the reports when a radio button is...

Sorry, but my subform is not nested with the mainform. It's linked using a command button with the following code to open the subform.Mainform is called [frmCustomerInfo] and Suform is called [frmCustPurchasesSubform]. Dim stDocName As String Dim strLinkCriteria As String...

Anymore ideas? this one is giving me some method not found error...do you know what else I will need to do? can I put the code in the command button because that is where the subform is filtered. Thanks again and have a lovely weekend! [Sunshine]

Hi, I have a Mainform and a Subform that are linked by a command button. Mainform has a combo box with Customer names. The subform show details about the customers. The mainform loads blank. When the mainform is blank, the subform also loads blank. But what I want is if the mainform is blank...

I got the solution here on Tek-tips. The solution is to set the report properties to pop up as well. So far, it's working great. Thank you guys...you are all really wonderful. Cheers! [sunshine] mondoray (TechnicalUser) 30 Oct 03 17:42 roaml, Access XP (2002) allows you to set reports...

Thank again. It worked beautifully![2thumbsup]

Beautiful idea. Will test and let you know. Thanks a bunch[thumbsup]

Hi, I have created a form with date fields to filter several reports. The form properties have Pop Up set to yes and Modal set to yes. Everything is beautiful except when I run the report, the report opens behind the report form so I am forced to close the form before I can view the report. Is...

I have successfully created a form with two date fields and used the code above and I am able to filter the report using the date range that I specify and this works great. Now, I have another question, I have several reports that will be using this same date filter. My question is, is there a...

Thank you. I will first try with text box because I need a date range.Will let you know how it fairs. [sunshine]

Hi, I am trying to build a form that I can use to filter date parameters. What I have in mind is a form that has three date fields, [purchase date], [receive date] [ship date]. The parameters will be used independently but I want them on one form so the user can select whichever one they are...

Thank you. Will let you know next week if I run into a problem. Have a great weekend and Happy Friday[sunshine]