General

hu
my question is about mac --- frmsrcurl: http://msgroups.net/microsoft.public.access ... 15 May 2010 02:58

Data Type mismatch error
[End Time] is a text field in the [Classes Proposed] table. This query SELECT [Classes Proposed].ID, DatePart("h",[Classes Proposed].[End Time]) AS EndHour FROM [Classes Proposed] WHERE (((DatePart("h",[Classes Proposed].[End Time]))<6)); and this query SELECT [Classes Proposed].ID, DatePart("h",CDate([C... 15 May 2010 01:54

Windows 7 will not take Corel Print House software it's old
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. Adele ... 14 May 2010 21:36

Case Statement Problem
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 String strRef = DET_REF Select Case strRef Case "LP*" strFeeType = "LP" Case "PP*" strFeeType = "PPP" Case "Prop*" ... 14 May 2010 20:31

Multivalue Field in Access 2007...
I have been trying to read a mutivalue field in an Access 2007 without any luck. I have followed the example at http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been able to get that to work. Has anyone sucessfully accomplished this task? ... 15 May 2010 04:02

Recording database usage
I would like to automatically record in a table the amount of time someone is in an Access database. I'm thinking that I can do something like record the session start time, session end time, then build a query to calculate the total amount of time. This is a single user database. Anyone have any suggestions ... 14 May 2010 17:14

Fomatting
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 shows the LoanId. Is there anyway to have it always show up? I was thinking of before update? =Format([DateofLoanAgreementSigned],"""HELP- ""yyyy""- 0""") ... 14 May 2010 17:14

FAQ Database Creation (knowledge management)
Can you create a FAQ topical database with keyword look up capabilities? Using Acess 2003 on a new help desk team. Would like to capture questions asked and quickly reference answers while fielding calls. I am a business user, not a programmer (although I did some interesting "damage" in a former life-smile)... 23 May 2010 20:09

Rounding Problem
I have been reading through previous posts, and nothing I have tried is working. I have changed the field i want to round to 3 decimal places in the BE table. It is now Double, Standerd, 3 places. When i open up the form, its the same, but its still rounding it. Not sure why or what to do. Everything I have tri... 14 May 2010 13:56

Browse for Folder (and set default folder)
I am using this code to browse for a folder (just folders no files) in Access 2007. It works great, I just want one extra feature: - to supply a starting folder I found one example on stephen lebans site http://www.lebans.com/callbackbrowser.htm but it required the code to exist in the code behind the form. I... 16 May 2010 20:08