Anyone out there testing Access 2010 capabilities with sharepoint 2010? I am particularly interested in the capabilities to allow you to upload an...

Bob Alston

01-08-2010 02:53 PM
Bob Alston

I have connection to Access database and a name of a view Dim Conn As New System.Data.OleDb.OleDbConnection Conn.ConnectionString = "..." Dim...

Roman Trojan

01-08-2010 03:24 AM
Roman Trojan

Anyone having same issue?

Rob Smiler

01-07-2010 08:27 PM
Tom van Stiphout

I'm using Access 2002 and have been getting the subject message more recently lately. In the most recent case, I was (for the first time) able to...

Bob Darlington

01-07-2010 07:40 PM
Bob Darlington

Hi, I am trying to make a few simple graphs for reports in ACC2007 and am having a hard time figuring it out. I have not been able to find any good...

bipin

01-07-2010 12:59 PM
bipin

Hello, I have a problem within the form where I have date with default value 'Date()' which is formatted as week ('ww') showing week number. It was...

avi

01-07-2010 10:18 AM
Michiel Rapati-Kekkonen

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

Daedalus

01-07-2010 03:40 AM
Allen Browne

Good Morning All!! I have used a practice for years that is suddenly not working. If I need a parameter for a report, I use an input box to get the...

Matthew Wells

01-06-2010 08:04 PM
Salad

The pricing of Office 2010 can be read...

Salad

01-06-2010 09:36 AM
Salad

I have a form and a subform. The main form has order id field which is an autonumber type. The subform also has order id field which is a number...

Ryker

01-05-2010 09:10 AM
Ryker

Hi, In AccessXP a have a form with a combobox on it, it's recordsource is SELECT tblCandidates.LName, tblCandidates.FName, tblCandidates.ColUniNme,...

bobh

01-04-2010 01:21 PM
bobh

Using Word merge from Access 2002 has just started generating the following error: 'word cannot start the converter mswrd632 wpc.(5132)' Has been...

Bob Darlington

01-03-2010 05:14 PM
Bob Darlington

Hi, A client has a very important business critical database system, but are after greater performance. Currently they have two front end versions...

J-P-W

01-03-2010 12:20 PM
J-P-W

If I compact & repair a FE AK2 database I normally get no problems. If I set the option to compact & repair it on close, I frequently get an error...

Phil

01-02-2010 01:03 PM
Tom van Stiphout

Does anybody know how to change and apply a theme to a database? I can see the theme formatting but cannot figure out how to apply a new theme and...

Yuval Nir

12-30-2009 05:26 PM
Yuval Nir

I launch Outlook form MS Access 2003 using the code under the double line. When I send the first email it works fine. But if I send another email...

robboll

12-30-2009 02:07 PM
Tom van Stiphout

Using Access 2010, I need the Treeview control & ListImage control. They appear OK in the Insert ActiveX menu as version 6, but when I try to insert...

Phil

12-30-2009 01:22 PM
Phil

I have come across www.fontstuff.com by Martin Green. He seems to be a gifted teacher (so I recommend the site for some things like using SQL in the...

Strasser

12-29-2009 06:13 PM
David W. Fenton

My application uses A2002 with up to 8 concurrent users with record level locking on open. The site is remote from my office. From time to time, one...

Bob Darlington

12-28-2009 04:56 PM
Bob Darlington

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

Phil

12-28-2009 06:09 AM
Phil

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

Phil

12-26-2009 07:30 PM
Phil

I have the following query, that has been in use for 3 years that extracts GL positing from a Jet/Access97 table that has existed for 10 years....

paii, Ron

12-24-2009 09:32 PM
Arvin Meyer [MVP]

The following code calcuates the difference in work days between two dates: Function BusinessDays(PosHireDate, RepDate) As Long BusinessDays =...

jeromez

12-24-2009 07:29 AM
jeromez

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

jonceramic

12-23-2009 03:48 PM
jonceramic

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

Filips Benoit

12-23-2009 03:08 AM
Filips Benoit

I have 2 buttons on a form. Both buttons invoke the same report named "BS". In my report header I have a label depicting the report header. If...

Prakash

12-23-2009 02:40 AM
Prakash

I have a form containing the following code in the Current Event. However, sometimes (only sometimes) it throws up an error message on the "If =...

Prakash

12-23-2009 12:58 AM
Salad

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

PW

12-22-2009 06:11 PM
PW

I was asked to make an existing app at work a bit more secure. It is written in A2003 and will soon be ported to A2007. All users have Access...

Salad

12-22-2009 12:28 PM
Salad

Let's say all users have A2003 and A2007. I guess by using the following it should always start A2003 for the app. ;this is the expected default...

Salad

12-22-2009 01:49 AM
Tony Toews [MVP]

In a class form I am doing the following. Public Property Set Form(FrmIn As Access.Form) Set frm = FrmIn frm.OnGotFocus = "" frm.BeforeUpdate =...

Mat

12-21-2009 10:34 AM
Krzysztof Naworyta

Hi I have a form that start on open i would like to show the current date in Day(text), date(number), month(text), year(number) i'e Monday, 7,...

kevcar40

12-21-2009 08:41 AM
Richard Cooke

I have the following code that is used to determine a person's age as of the run date. I'm receiving an error message in my query related to this...

Coll

12-21-2009 02:49 AM
Allen Browne

I have two dates: StartDate = 11/09/2009 ReportDate = 11/30/2009 I know that days elapsed is simply: - = 21 Days

jeromez

12-19-2009 11:51 AM
jeromez

"CARL" <carlmdobbs (AT) gmail (DOT) com> wrote Please don't use this group for solicitations, it is a violation of the charter. This group is for...

Keith Wilby

12-18-2009 02:56 AM
Keith Wilby

I am convertin from AK2 to A2010. VBA routines which opened Windows explorer to find files or folders no longer work (unsurprisingly) Can anyone help...

Phil

12-17-2009 12:19 PM
Phil

Dear All, using function below without attachment send an email with an attachment like ATT?????.dat. What can i do about this. Thanks, Filips

Filips Benoit

12-17-2009 03:28 AM
Filips Benoit

When I open the form normally, ie: From the database window, the combo box works correctly. The query behind the combo box references a field on the...

Mat

12-16-2009 07:42 PM
Mat

I have a report (reportA) with sorting / grouping by 'description' and that works fine if I include reportA as a subreport in reportB the reportB...

Roger

12-16-2009 05:35 PM
Roger

On 16 Dez., 15:31, tgkeefer <tiff... (AT) juno (DOT) com> wrote: This would be easy to do in a report (running sum). One possibility for a query...

Marco Pagliero

12-16-2009 10:46 AM
Marco Pagliero

I'm trying to distribute a new application. Everything works on my computer. I Debug/Compile in Visual Basic, then Compact on Close. I go to My...

Tomahawk Lady

12-16-2009 08:07 AM
Tomahawk Lady

The latest update makes the process of initial user setup much easier. You will now be able to click on button in the utility and paste a link into...

Tony Toews [MVP]

12-15-2009 11:45 PM
Tony Toews [MVP]

I've downloaded the hotfix that is discussed here: http://support.microsoft.com/kb/974995 in an attempt to fix the A2007 problem of combo boxes...

Wayne

12-15-2009 05:33 PM
Wayne

All, My name is Mike Skousen. We just had one of our access data base builders leave us to work for a family business in California, so I...

Mike

12-15-2009 04:51 PM
Mike

I am trying to append records to a linking table which contains 3 ID numbers (fldCustomerID / fldSalesAreaID / fldProductID using a simple form which...

gorsoft@hotmail.com

12-15-2009 01:15 PM
gorsoft@hotmail.com

I don't even know why I am asking again but surely someone here has been successful exporting Access data (2003 in our case) **TO** Quickbooks? My...

PW

12-15-2009 10:18 AM
Karl

* Begginner I have just created my 2nd ever database. The database was built in Access 2003 using the 2000 file structure. I have split the...

BamaBlast

12-15-2009 08:14 AM
BamaBlast

Hi all. I'm not sure if this is possible, but can one use a combo box lookup for a value being currently inserted in the same tuple in an...

Darragh

12-15-2009 12:46 AM
Darragh

This might be of help to some people. I have been producing some PDF reports lately directly from Access using the basic techniques found...

James A. Fortune

12-14-2009 05:00 PM
James A. Fortune

In the code to define and run UserList it starts out like Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim cn2 As New...

Salad

12-12-2009 03:01 PM
David W. Fenton