Search results for query: *

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, 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...

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...

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...

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...

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...

I have a labels report that I would like to filter using a tabular form with check boxes for the user to be able to select the name by ticking the check box then openning the report for printing. I am not good with code and I need some help. I have created a command button, cmdPrintLabel but...

Hi, I have query that includes a combo box field that has 4 items in it. I am trying to do a count on this field but I get data mismatch type error. I am using the Totals symbol in the query Design view as a grouping method. Is there another way get a count on combo boxes? Thanks [sunshine]

Hi, I have a form that has a subform linked. The form loads fine with all the records. However, I created a switchboard that I want to use as a median for opening the form and some reports. The problem is that when i open the form from the switchboard, the form opens but it does not load any of...

Hi, I am trying to figure how write code that will do the following: I have a drop down combo box and a corresponding text field. What I would like to do is to make sure that the text field is not left blank only if a certain selection is made. For example, assume my combo box has the following...

I have the following situation: Main Form = tblCustomer with pkey as customerID Subform1 = tbleReservationType has a lookup field with Lunch or Dinner value list and has ReservationTypeID as pkey Subform2 = tblNumberofReservations holds details of Customer reservation and has...

Does anyone know how I can count date fields? Example, I have a Customers table and Reservations table. What I want to find out is how many times a customer has made reservations by counting reservation date field for each customer who showed up and also a date field for those who did not show...

Hi, I have a lookup field that I am trying to query but I am getting "Data type mismatch in expression criteria". The lookup field type is number but field type from original table is text. I tried to change the lookup field to text but when I did that, my query is not yielding results. Is...

Hi, I have an Access main form with a subform linked to it. The subform is in Tabular format and the relationship between the main form and the subform is one-to-many. I also have another popup subform that I want to link to the second subform using the ID field on the first subform. Forms are...