Help

Detecting Accde database
This code worked in AK2 for seeing whether a database was an MDb or MDe Function IsItMDE() As Boolean On Error Resume Next Dim strMDE As String strMDE = CurrentDb.Properties("MDE") IsItMDE = ((Err = 0) And (strMDE = "T")) End Function Can anyone tell me the equivalent for checkin an Ac... 27 Jun 2010 20:29

Command Button wizard in 2007
I do not write code. I use wizards and macros. Until last year none of my clients were using 2007, so I continued to use 2002 to design databases. In 2009 a new client had Access 2007, so I decided to try to use it to create their database. My greatest problem is that the command button wizard doesn't work pr... 19 Jun 2010 11:16

Sizing problem with picture in BoundObject control
MS Access 2002 SP3/SQL Express My client has a form with a BoundObject control on it whose control source is an Image column in a SQL Server database. Today, she tried to add a new picture to a record and it's not working correctly - the picture is distorted and shows the title of it, whereas on my system it wo... 19 Jun 2010 03:43

MS Access query
I have this table: CustName TripID LocID ABC 12 96 CBS 18 91 CSI 19 97 ABC ... 16 Jun 2010 17:41

Prevent Rounding of Double in Report
Hi, I have a field in a report. I've specified that 3 digits be displayed. The underlying column in the select that the report is based on is of type double. How do I prevent the report rounding the answer? If the value in the column is 3.0001 or 3.0009 I want the report to display 3.000, but I cannot find a ... 16 Jun 2010 16:34

Access 2010 - SQL view removed from queries!
On 15 June, 17:23, Banana <Ban...(a)Republic.com> wrote: On 6/15/10 9:05 AM, Albert D. Kallal wrote: Ah, found it here: http://www.pcpro.co.uk/reviews/software/358558/microsoft-access-2010 I can see why it can be misleading. A quick reading seems to imply it's a change for Access 2010, rather t... 16 Jun 2010 04:30

Access subform issues
I have an Access subform issue which a friend submitted to me, and I am stumped. There is a "Main" template with tables, forms and subforms connected to it, built relationships, etc. She wants to keep the "Routine" subform that was activated on the "Main" main form (which she renamed "Applicants" - maybe this ... 16 Jun 2010 00:11

Fueling your car with natural gas from home
Dear Everyone, as you know the price of the Oil is more and more increasing, while the oil supply is decreasing. Moreover Oil is causing wars, terror, oil spills, a lot of greenhouse gases. Do you know that there is plenty of natural gas ? The supply will last for many decades, probably for hundred years. A lot o... 15 Jun 2010 17:37

Access 2010 - SQL view removed from queries!
I read an article in PC Pro that states that SQL view has been removed from queries in Access 2010! Surely this can't be true? I frequently copy and paste SQL form the query builder to the VBA project. This would kill Access as a platform for developers, wouldn't it? Paul ... 16 Jun 2010 01:16

BUY FAKE ID CARD,SALE FALSE ID CARD,BUY FAKE ONLINE ID CARD,BUY FAKE ID UK,BUY FAKE PASSPORT
"Justin Dulton" <support(a)buyfakepassports.com> wrote Our team is a unique producer of quality fake documents. My guess is that there is little unique about Justin's company, that they take any money you send them, and assume you won't complain to the authorities when you don't receive a fake document of an... 15 Jun 2010 17:37