Search results for query: *

is it possible at all to have an active hyperlink in excel 2003??? i can not find anything anywhere.. completely frustrated.. my purpose is to open a word document from the excel pivot table.. the document associated with whatever corresponding cell... i know there is a miracle worker out here...

I reposted... i didn't clarify.. EXCEL 2003 pivot table.. Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same...

Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report???? for instance.. 2 page items are STATE, CARS, row field...

anyone see what's wrong with this? 4: Sort the data by the random number and move the top 25 into a new table strTableName = "tblRandom_" & Format(Date, "ddmmmyyyy") strSQL = "SELECT tbltemp.LSO_ID, tbltemp.LSO, tbltemp.AM, tbltemp.BorrowerName, tbltemp.LastCalcDate, tbltemp.CalcType "...

Need help the module below works great for producing random records, however I have 7 users that I will need to match for, meaning.. i need top 3 random records for 5 different groups-i saw group because i read somewhere that i need to use a group statement.. so maybe group isn't a good term...

I'm doing something wrong here.. looking at 3 date/time fields: 1)RedCalcDate 2)BlueCalcDate I'm querying for the [lastcalc] or the most recent date out of the calc datefields for that record...and all records last calc date in the current month.. which I got that fine, but not I'm looking to...

I've created a query, and in a module formed a code to randomly select records for an audit sample from a query. I'm stumped on the next part... I'm trying to accomplish the following: The results contain various fields of data for 6 different individuals. Criteria for the query is if the parts...

Bear with me- I'm a novice when it comes to this subject, I've never been "formally educated" in Access or VBA. I'm learning as I go. So my description may be muddy. I've got access tables linked to an ODBC database -a program that performs analysis- data is entered for multiple variables in an...

Bear with me- I'm a novice when it comes to this subject, I've never been "formally educated" in Access or VBA. I'm learning as I go. So my description may be muddy. I've got access tables linked to an ODBC database -a program that performs analysis- data is entered for multiple variables in an...

I have a table with the following fields: CreateDate--Date/Time (ex.9/19/06 9:17:00 am) LogType-- Number --1-6 (1shows logon 3 save 6 log off) Description--Text (description of action taken) UserName--Text UserID--Text ReportID---number-- shows the ID of each report TS--Date/Time...

I have a field that contains a TEXT data which could be a number with 2 digits up to 7 digits. I need all records to show as 7 digits. so if the record shows 52- I need to see: 0000052. I've tried to use an imput mask. It's not working. Any ideas?

Do you see a way to simplify this? The problem lies with the ActualYear field- which shows the year of the active report. It could be any year from 2001-2007. I need to show current reports and reports from last year that may have a due date of this year. Ex. December 2005 report may not be due...

The following query is not returning the correct due date. I have reports (sheetrowtext) that are are Decemeber reports that should show a due date of 2007, however they are coming back for this year. There is a field that i'm not using, called "actual year" which shows the year of the report...

I have a query which produces a field for a reportname and then shows fields Jan-Dec with a date field. Fields Jan-Dec, may or maynot have a date field. In my report, I need to show only reportnames when a date appears in any one of the fields Jan-Dec. If a date is not present for fields...

In One Table I have- a type of definition table--- 10=Title|StandardText 11=Active|InDefault|GracePeriod|DateDue|DateReceived|Received|SignoffNote...

How can I format at text box, or field on a report to remain blank if the corresponding field is null? I don't want data in one field to appear if data in any of the corresponding fields are blank, or have null values Any assistance would be great!

HELP! I'm new to Access. Never taken a class. I'm self taught, and I feel like i have an ok handle on things.. but good grief this stuff will drive you nuts! PLEASE HELP! I have a query that returns results of names of borrowers, names of reports due for that borrower, and if it is an active...