Search results for query: *

Hello - I have a report in Access 2008 and i have a call records and a field called Total, and another field called Status... in the total field i have numbers and in the status field i have [closed] and [open] i want to sum the total amount that was closed. how do i get the report to show me...

Hello - I have a database in Access 2007 with an Auto Number - "FY2011-01" each time we add a record the number at the end of FY2011-## change.. however now it's FY2012 I would like to start with FY2012-01 instead of FY2012-305 is there a way I can set the record to start at 01?

Hello- How do I generate a pop up that tells me when a "Date Closed" have reach 2 years and need to be deleted. Currenly I have a date function that said "Date_Closed" I would like when the "Date_closed" reach 2 years from the date that a pop up will notify me to delete the record.

Hi, I have a form and we have a txtDetermination and a Determination_date - what happen is the user will enter the Determination_date but does not fill in the txtDetermination (this is a drop down, "Pass" or "Fail") is there a way that we can have a pop up message that tell the user "...

Hello - I am trying to do a name search from a button. It works fine when I only have 1 table to search the last name by… however now I am ask to add 5 other tables to the search, is there a way I can have 1 button search through all 5 tables and show me anyone with the last name “Smith” I...

Hi -- SOrry yes it's me again... i am creating a button where it will input the data into a text box - everything works EXCEPT Me.txtIssueCategories this field is from a table and when i look in access the "Row Source" is from an SQL statement- when the button is click Me.txtIssueCategories...

Hello - i'm working access 2007 and creating an email with 4 attachement but i am getting an error message "Too Many Lines Continuation" the body of the email is pretty long and there are a few breaks in there... is there away i can get around this? .Body = "Dear " & vName & "," & vbCrLf &...

Hi not sure if this is possible but can we show a date when the data is null? I have a [Begin Date] and [End Date] where a user is prompt to enter a range of date that they would like to see the report... however when there is no data for the date it just come back blank... i would like to...

I have a report that show how many cases a person have close on a range of date – I have a Begin and End date where the user can enter a date that they would like to run this report. However, if a person that was selected did not close any cases that day the Begin and End date give me an #ERROR...

Hello - I'm tying to do a mass update adding notes to our Access 2007 database, but I'm running into an issue - I am matching an empyee ID worksheets up with our master table in access 2007. i would like to add a note that say: Date: Batch update: subj is part of upgrade project. subj has...

Hello - I have a report that generates case information using the Case Number - right now the reports open all cases... filter by the case number - we have a total of 5 hundreds cases... and when the report is generated there is about 300 pages. is there away we can have the user to select a...

Hi - I working on a form that was already build and what i would like to do is, when a user click on a button it will move fields case_status, case_compDate, and CaseID to txtNotes, with a note that say something like 'today date: case_status (ie.denied) for depart on case_compDate (ie.4/1/11)...

Ok - i know this should be pretty simple and striaght forward... but I can't figure out how to get this to work - in access 2007 - i have a table called userDatediff. I use the date release MINUS date assigned to get the date diff (how many days it took the user to release the case) i would...

Currenly I have this mesgbox that pops up when user are using the wrong/old version of the database in access... is there away to lock access to force the user to download the lastest version? I understand that access is on the client site, and when the user click 'OK' on the pop up box the user...

Hello - I have a situation where I need to “import” an excel file into access but the file name constantly change. Is there a way I can import the file by the date? The file come in as ‘report20110419052731.xls’ the 20110419 is the date stamp. If this is not a good option – is there a way to...