Search results for query: *

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]

Name Courses #of taken TakenDate Expires Mary Employees 1 12/5/2009 12/5/2010 Mary Cust Service 1 10/5/2009 10/5/2010 Mary Employees 1 12/5/2008 12/5/2009 Mary Cust Service 1 10/5/2008 10/5/2009 Mary Marketing 1 05/5/2010 05/5/2011 Hello Again, I am trying to keep count...

So, now my parameter date filter is working perfectly. But my goal is to get the filtered customer names printed as labels. For that, I have created a tabular form that has check boxes and a print command button. This was working fine before I created the parameter. The problem I am facing now...

You Guys are Awesome! Your suggestions gave me the options I was looking for. I have decided to just use a parameter instead of the combo because the combo list was way too long. This way, I can just enter the month and year i have in mind and it pulls up the list. It's working perfectly so far...

I don't know if this makes sense because what I am trying to do is to filter part of a whole date by month and year. I am not interested in the day of the month. So, lets say the date in the table is 1/15/2010,what i am interested in is the month of January and the year 2010. I am not interested...

Hello, Please help, I have a table that has several date fields and I am trying to create a parameter that would filter a date by month and year. For example, If I want to find customers who dined with us in December 2008, I want be able to enter 12/2008 in a parameter box and pull those...