Help

Sharepoint security settings to distribute Access database
Perhaps I was not clear enough for someone to respond to my earlier posts. Let me rephrase. I am trying to figure out the practical access privileges/security settings for using Sharepoint 2010 to host an Access 2010 app that users would download from Sharepoint2010 and run on their own PC using Access 2010... 25 Jan 2010 22:56

Open an external file from a formular
Does anyone know how to open an extern file from a formular? I have a formular with a field containing a filename related to a pdf file in a directory c:\goods\drawings I would like a button that opens the pdf file. ... 10 Jan 2010 14:05

Special TIMESTAMP - 0912291327
In trying to come up with a VBA timestamp for 2 digit year, month day and 24 hr time, I came up with the following code. IT WORKS! ? mid(year(date()),3,2) & month(date())&day(date()) & replace (FormatDateTime(Now, vbShortTime),":","") 0912291327 You can leave off the mid function if you want a full year. I j... 30 Dec 2009 09:47

exif
Hi I'd like to retrieve the timestamp of .jpg-files. The only thing I found was that this info is stored in the exif-data of the files, but I can't find a way to retrieve this from my vba-code. Anyone ? Tanx in advance ! D ... 7 Jan 2010 05:44

DateCreated
I use the following to get date created of say a form Function GetObjectDates(ObjName As String, ObjType As Long) As Date ' Get DateCreateds of Forms, Reports. Queries etc 'getobjectdates("Member",-32768) On Error Resume Next Select Case ObjType Case -32768 ' Forms GetObjectDates ectD... 26 Dec 2009 20:56

Outlook Custom form help needed... Set number fields to null?
Hi all, I know it's slightly off topic, but we've got a decade old database that takes an Outlook form, sets a connection to Access via DAO, and then writes back and forth to the recordset. The problem is that every number field on the form defaults to the "0" or "$0.00". I've tried all sorts of things to s... 23 Dec 2009 17:23

Font & Colour Dialog box
Access 2010 & Windows 7. Can anyone give me the code to open the Font dialog box and the Colour dialog box. What APIs do I need Many Thanks Phil ... 28 Dec 2009 07:27

this is very strange
Dear All, I copyed 3 access2003 databases to my laptop, all 3 having 1 form that's exactly the same. In that form 1 combobox ( the same in all 3 databases) doesn't show the values. Nothing just a blank list ! It only occures on my laptop, never seen it on another computer ! Combo's Name = AnalyseMonsterLoca... 23 Dec 2009 13:37

best way to handle #ERROR in Query
The following code calcuates the difference in work days between two dates: Function BusinessDays(PosHireDate, RepDate) As Long BusinessDays = (DateDiff("d", PosHireDate, RepDate) - _ (DateDiff("ww", PosHireDate, RepDate) * 2) + 1) + _ (Weekday(PosHireDate) = vbSunday) + _ (Weekday(RepDate) = vbSaturday) End... 24 Dec 2009 08:33

Possible to stop "Unsafe Expression" warnings (Access 2003 and XP)?
Hi, We have a client complaining that every time they start up their MDE, they are getting the "Unsafe Expressions" security warnings. And one of them says that to block unsafe expressions, Jet 4.0 SP8 or later must be installed. He said he has run Windows Update and that their are no more updates. Is it po... 23 Dec 2009 13:37