Search results for query: *

I have a table of tasks and about 9 records are "Daily" which are identified in a Frequency field of the TblMain. I also have a complete checkbox, a start_date (prepopulated) and an end_date. Once the complete checkbox is marked, the end_date is updated with today's date. If I check off all 9...

I have a validation dropdown list of names in which I need to match the users input to. If the user enters anything besides what is on the list, I need to display an error message. My validationlist is called =val_list which is on another worksheet (Names) within the workbook. I can get the...

I'm sort of having the same dilemma as buckag only I don't have subreports. I have a report based off of a main query that is based off other queries. There are apprx 6 queries that are based off one table with common fields (date). I need this date to have a between start & end date for...

I have a form with an unbound field that I want to use as an "End Date." This "End Date" will always be on a Sunday. I'ved tried just about every date function there is but because the system date changes, my "End Date" does also. I need it to stay on the following Sunday's date for an...

I have a report based off of a query that has a field called [Pro_form](yes/no field). Based on the value of the field, I want to be able to change the color of the font within the report, i.e., if pro_form = -1, then the font is red, otherwise, it's black. Any ideas? Thanks

I'm trying to get the number of weeks between 7/2/1997 and 6/8/2004. The code i'm using is what I found here in the forums: Using DateDiff("ww", 07/02/1997, 06/08/2004) gives me 0. Any help is appreciated.

I'm running Access 2002 on Windows XP Pro. I created a form that pulls from a populated table and created a command button to export the contents to an excel spreadsheet which uses a macro. The form itself is based off of this query: SELECT Office_Entry.* FROM Office_Entry WHERE...

I created a new Outlook Data File, named it Personal Folder(1).pst and moved all my items to it. My problem is that the messages do not show. If I look at the details, it shows that it is 38xxx kb so I know there is SOMETHING in there. How do I get Outlook to show the messages? Thanks!!!

I have an unbound field set to a combo box (named txt_week) on a form that refers to a table called tbl_WE. The choices are 11/16/03, 11/23/03, etc. I have another unbound field I want to be able to set to a week before this date based upon the users choice. i.e., 11-16-03 - 7 = 11-9-03. I've...

I have a form that lists open work orders that is based on my main table. I want to be able to click on a particular work order and give the details from another table, mainly the sum of the revenue. The textbox on my form (frm_Main1) is named WRNumber. Here is my statement: Set rs =...

Is there any way to print a checkbox control on a report? It prints if it's populated with a checkmark, but I want the box itself to print if it's empty. Thanks!

I've looked all over for an answer to what I need but can't find one. I have 2 reports: rpt_region and rpt_market. The region report lists info from a particular region and the market report lists info for the markets under that particular region, i.e., Atlantic. I have added the...

I have a Main report (Market) and a subreport (FA). Both have two fields in common (Region and Market) so they are my Child and Master fields. There is 1 record in the Market report and 41 in the FA Report. Whenever I run the report, the status shows the query running and then it hangs on...

Please help with an update query that seems like it's updating but it's not. I've checked the fields in the table I'm trying to update to and everything seems to be okay there. The query I'm using is UPDATE tbl_data LEFT JOIN pops ON (tbl_data.Lname = pops.[BankPtnr Last Name]) AND...