General

Min Max dates not consistent
For each record I have 2 columns with dates and need to identify the min or max from both. Using: MinDate: IIf([CalloutDaystoDuefh]<[CalloutDaystoDueFC],[CalloutDaystoDuefh],[CalloutDaystoDueFC]) MaxDate: IIf([CalloutDaystoDuefh]>[CalloutDaystoDueFC],[CalloutDaystoDuefh],[CalloutDaystoDueFC]) For the most par... 14 May 2010 22:41

Age Calculation
I have the following sample field and record Age ApprovedDate 40 15-05-2000 Age-number field that shows the current age in 2010 Approveddate - date field when the application was approved. How to calculate the age of the applicants at the point of approval. In the above example the age would be 30..... 17 May 2010 22:24

cpu
error code723729147`32043094835085459145845197415481305883`48`3257356743368137513 ... 13 May 2010 20:30

field formula for newbie
I'm not well-versed in Access, and I'm hoping someone can give me a simple fix for my dilemma. I want to create a new field (NewID) in a table that looks up the data in a different field (CurrentID) in that same table and then drops the first character. So if the value in CurrentID is 012345, the value in New ID... 13 May 2010 19:24

Collect and update via email with a Table/spreadsheet
Hello, I would like to use the "Collect and update via email" function within MS Access which sends out and collects emails with MS InfoPath. I know how to use this function, but what I would like to do is something slightly different. Instead of emailing out a "form" that has the customer and then all informa... 13 May 2010 20:30

No Field Edit capability
I have a large data file as the parent, left joined to a child table which is many to one. and the parent also joined to a sub query that counts the number of records in the parent that match the child. when I run the query it delivers all the data in a table but it will not allow me to edit or change any of ... 13 May 2010 18:17

Sys table Query to Obtain List of Queries used in Reports
Is it possible to query the Access 2007 Sys tables to obtain a list of which queries are used in which reports? Thanks, Brad ... 17 May 2010 18:01

Access 2007 Developer Tools and SourceSafe
On Wed, 12 Sep 2007 21:59:59 -0400, Charles Calvert <cbciv(a)yahoo.com> wrote in <3a6he3dobkef62e8k9c1i8orshr5vr1bs2(a)4ax.com>: On Tue, 11 Sep 2007 23:44:16 +0200, Andr� Minhorst <info(a)access-im-unternehmen.de> wrote in <O#AArzL9HHA.1208(a)TK2MSFTNGP03.phx.gbl>: [Adding project to SourceSafe fails silently] ... 13 May 2010 17:10

Condition navigating between Controls
I have a form in access 2007, with several controls. I used the On Exit Event Procedure for navigating among controls. Example: If Method of Payment = “Check” Then Check No.Set Focus End If If Method of Payment = “Credit Card” Then Credit Card Name.Set Focus End If End Sub And so on for all controls. Form fu... 14 May 2010 19:26

calculate in form
work with Xp and Access2003 I want to do following In an Input form I want to check if some data aore correct. based on invoices I introduce the BasicAmount, the txes and the total of the invoice i.e. the sum of Basic + Taxes say i.e. 100 + 21 = 121 I intorduce the 100, the 21 and the 121. As matter of contol I ... 13 May 2010 19:24