The goal is to normalize data before converting text fields to datetime fields. There are start times and end times stored in text fields of a table. The...

How do I create a database for the use of invoices? I'm not sure how to start. Step by step would be good or at least a brief overview. I am trying to...

On Fri, 14 May 2010 19:14:23 -0400, "(PeteCresswell)" wrote: How slow? FMS Inc has a BusinessDayAdd and BusinessDayDiff loosely based on the...

Hi All, I want to make a pop up caps lock indicator on my login form just like we have seen hotmail sign in area, is there any way to do so?? I am using...

oiee moh !!!

"(PeteCresswell)" wrote in : Business days between two dates has got to involve a...

I have been trying to read a mutivalue field in an Access 2007 without any luck. I have followed the example at...

my question is about mac --- frmsrcurl: http://msgroups.net/microsoft.public.access

I keep hearing people say around my office that access is no longer supported? is this the case now?? have read some threads but are a few years old. I like...

So could someone help me please

is a text field in the table. This query SELECT .ID, DatePart("h",.) AS EndHour FROM WHERE (((DatePart("h",.))6)); and this query

First I'd like hearing your opinion for a strategy for handling the time data type. I want the ability to calculate and compare time. The database contains...

I have been requested to help design an application that uses sharepoint to gather data but then is able to transfer that data real time to access to do some...

For each record I have 2 columns with dates and need to identify the min or max from both. Using: MinDate: IIf(,,) MaxDate: IIf(,,) For the most part the...

I have a new PV Windows 7 which will not accept Corel Print House Magic. Is there a way round this. I do love this soft wareware. It is old. Thanking you. ...

Hello, Can someone please help me with my Case Statement Public Function FEE_TYPE(DET_REF As String) As String Dim strRef As String Dim strFeeType As...

I have a problem and I have been unable to identify the source and hence unable to resolve it. I have a 2003 db, secured using mdw, split and running fine...

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

I have the following in a text box, it works ok but when a LoanId number is already in the database or imported in this doesn't do anything instead it just...