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

In AK2 I used the MSCOMCTL.OCX in the Windows\System32 folder. I am now using Windows7, and access 2010. Although the programme compiles without...

Phil

12-17-2009 12:58 PM
Phil

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

Using Access 2010 Beta; just wondering if Intellesense is available in the VBA editor when writing procedures (it's not working in my install). I...

Joseph Macari

12-12-2009 09:45 AM
Joseph Macari

I have an application that keeps track of payments. Those payments can be applied to various fees. I am trying to figure out how to create a report...

Bill

12-12-2009 07:14 AM
Roger

Is it possible to have defaults with lookups? Sorry, not sure how to explain this without an...

Astley Le Jasper

12-11-2009 12:10 PM
Salad

Hello, I have a table of reports and the functions that must run before the report is opened. Set db = DBEngine(0)(0) sSQL = "SELECT DISTINCTROW...

bipin

12-10-2009 10:12 PM
Tom van Stiphout

I am using a function that I found in Microsoft Support Article ID: 210350. It allows you to"Print a Constant Number of Lines Per Group". The...

Momo4kids

12-10-2009 09:47 PM
Momo4kids

I have a textbox whose control source is a string expression parsed from (other) bound controls on the form. After the user enters new values in...

Ron

12-10-2009 07:50 PM
Ron

Can anyone answer questions on how to set permissions for Access services in Sharepoint? I posted questions to the Sharepoint 2919 forum but have...

Bob Alston

12-10-2009 05:51 PM
Bob Alston

Dear All, Opening Qry_CrossTab_1MonsterLocatie from cmd in FRM_MONSTER_LOCATIES triggers error: Microsoft Jet database engine does not...

Filips Benoit

12-10-2009 12:57 PM
Filips Benoit

Hi all, I think I've annoyed Jet as much as possible, and may need to resort to VBA to write my crosstab. So I'm sure others have tackled...

Jeff

12-10-2009 08:11 AM
Jeff

I am sending 500 e-mails from Access with customized PDFs and Excel worksheets and I want to bold one line in the e-mail. How would I do that and...

musicloverlch

12-09-2009 05:52 PM
Rick Brandt