Search results

I have a query that has a Year field. I want the report and form that I generate from this query to only show current year results. I already put 2012 in the criteria area of the field for now. Is it possible for me to write an expression (or other) that will update to 2013 when the new year...

Hi, I have added a pie chart to my form. However, the chart itself is really small. I keep increasing the entire grid but it's doing virtually nothing for the chart. How can I make my chart bigger?

Hi, I have code that will determine that days between two date fields in my query. The issue that I have is the days return perfectly when both date fields have data. However when the Begin Date field has a date but the End Date field doesn't yet have a date, it returns #Error. Is there a way to...

Hi, I have inserted time on my form. Control Source =Time(). Is there a way that I can make it update/refresh when a user is on the form? Right now it only changes the time to current when the form is closed and reopened or when toggling to design view. Please advise. Thanks!

I have a form that has a button the activates a report that is based on a query with a parameter. The parameter asks for the begin date and end date; it's for the same field in the query. (I used Between/And.) I don't like the little gray pop-up for the parameter value. Is there a way to...

I have a report that is based on a query where the criterium of the date field is: Between [Enter Begin Date] And [Enter End Date]. Is it possible for my report to display the two dates entered by the user?

I dont know how to write code so please bear with me. I'm using Office 2003 and creating DBs in 2000 format. I have a database where issues are recorded and resolved. There are certain issue types such as System, Communication, General, etc., etc. I have an IssueTypetbl to update the available...

(Office 2003 / 2000 format) I have a Main form created from a Main table. However on the form are combo boxes that allow you to choose from the list and the lists show row sources from other tables. (e.g., The form has a combo box called "Manager" and it is pulling the results from the MgrTbl...

I have a mainform with an unbound combo box and one subform. The subform lists all the records in the database that is associated with the item chosen in the combo box. However it just shows the current records but does not allow for adding new records. I checked the properties of both the...

I have an unbound combo box in my main form and I have a subform. Upon opening the main form, the combo box shows no records until a selection is made (which is what I want). However I also want the subform to show no records until an item in my combo box on the main form is selected. Right now...