Search results

OK. And please forgive me as I'm used to working with Access but not so much with writing code. I have a form that has a link to the report that is based on that query. I just have an OnClick macro that opens the report. I havent written any special code for it. (I promise I'll learn more about...

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 and thanks. Just to make sure I understand... So in my original table that the query is based upon, I should have 2 fields, begin and end date fields, if I'm going to make this work; is that correct? It won't work when the dates are being querired from the same field, correct? Thanks again...

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?

Great great great IT WORKED.... I just love Access-Programmers site. This is such a usefull tool. WOW!

Thank you. Should I make this adjustment in the VB code or the query expression? (Or the report?)

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?

Thanks for your reply. Does this mean the user would have to type the issue type in order to generate the report based on the parameter? I'm trying to avoid them having to type the issue type as a parameter value because they may not always know what it is. i want them to be able to select from...

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

Actually, I just went back into my Main table and one by one made my desired fields Required: YES. I changed one, then open the form and entered a dummy record and closed it. Then I'd go to table and changed another to Required and save, open the form, created a dummy record and closed. I didnt...

Thanks, I went back to my Main TBL and changed all Required fields to "No", although I wish I could keep them. My form didnt respond at first (each time I clicked the Manager combo box, it would not show the drop-down or do anything; but it would delete already entered fields on the form.) I...

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

This explains it all. At first it was bound by a table but i changed it to a query. I'll go back and get it right. :)

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

Thanks. If I delete the record source in the subform, I get Name# under each column in the subform. I dont know how to write VB scripts and the afterupdate script for the unbound combo box on the main form is foreign to me. (The tbl / record names I gave in my original post were generic for 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...