I get this error Server was unable to process request. ---> The type initializer for 'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception....

Bob Alston

11-08-2009 12:47 AM
James A. Fortune

If you are looking for data to be secured from people with malicious intent then you could always introduce a cryptographic function to encrypt the...

The Frog

11-06-2009 01:59 PM
David W. Fenton

Hi all I have seen code (from Lyle, who always makes me feel sooo inadequate!) for sending emails via OE (MAPI stuff). I am under the impression...

jbguernsey

11-06-2009 11:06 AM
jbguernsey

Well i did as you said (i used PersonID as the primary key in Employees Table) but when i run the Persons Query (with criteria to give me only the...

Mistirios

11-06-2009 05:23 AM
Mistirios

Hi all, I team up with a GIS guy a lot, and we've built a good workflow around (me) generating crosstab queries/view from Access DBs for him to...

Jeff

11-05-2009 02:00 PM
Jeff

Hi I have a form/subform set up, with a button to add a new record. I want the button to add the new record to the main form but not add any data to...

paul

11-05-2009 11:20 AM
paul

Hi Everyone, I've written a basic function to return TRUE or FALSE depending on whether related records exist in another table. This works well...

elias

11-04-2009 08:22 PM
Chuck Grimsby

In order for my application to work, the Microsoft DAO 3.6 Object Library needs to be third on the list of references. Can anyone tell me why it...

pemigh

11-04-2009 08:15 PM
Chuck Grimsby

Hi All, Has anyone ever tried to have the data on a report center itself on print preview? The secretaries here are having a fit because a...

musicloverlch

11-04-2009 04:28 PM
Salad

"paii, Ron" <none (AT) no (DOT) com> wrote in news:hcrtt1$ej8$1 (AT) news (DOT) eternal-september.org: To me, Citrix is one of those FUD...

septimus

11-04-2009 02:52 PM
David W. Fenton

I linked a speadsheet in an app and opened it and noticed I had some #Num! cells. I guess that called to my attention that there were number and...

Salad

11-04-2009 12:37 PM
Salad

Any suggestion on the following would be greatly appreciated: I was working on a database in MS Access and I have encountered an issue I need your...

Mohabi

11-03-2009 07:17 AM
paii, Ron

I know this group is for helping in use of the access but hoping to find some help on installing '97. Recently purchased laptop w\ XP Home. Have...

doncee

11-02-2009 04:17 PM
doncee

I'm linking Access to Outlook, the system automatically generated a link table called "inbox" which I can't modify anything inside, seems like a...

shanq

11-02-2009 01:50 PM
shanq

I have an Access 2003 Form with a listbox on it. The row source is a Table/Query. The query sorts the records according a Date/Time field in the...

RCGUA

11-02-2009 11:03 AM
RCGUA

I have a form which has 2 dropdowns that the user needs to select. One is on Year and the other "Active or not". The 2nd dropdown has 3 options -...

Arlette

11-02-2009 10:46 AM
Salad

I have a search screen in MS Access 2003, with a unbound text box to put in the parameter to search. I need to have all the text boxes in the...

Arlette

11-02-2009 05:42 AM
Arlette

I am using Access 2007 and am puzzled by the form and report design tab. No matter what I do the gridlines group remains greyed out (disabled) Has...

Lou O

10-31-2009 11:42 PM
James A. Fortune

Hi Everyone, I am trying to find out if anyone has had any issues with Access applications / Jet databases on 64bit Windows platforms. I am...

The Frog

10-31-2009 10:54 PM
Tony Toews [MVP]

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> writes: Knock yourself out. -- Randy Yates % "Watching all the...

Randy Yates

10-31-2009 06:32 PM
Randy Yates

Usually a subform's recordsource grabs ALL records it needs and then the filter established by the Link Master/Child fields is applied. However, the...

Randy Yates

10-30-2009 02:36 PM
David W. Fenton

I am trying to email a personal invoice to our members. I can generate a PDF file of the invoice OK for each person and I can email them something as...

Phil Stanton

10-30-2009 01:04 PM
Phil Stanton

Using A2003. I'm using the coding below to look up AmountReceived for a certain date: strExpr = "AmountReceived" strDomain =...

emanning

10-30-2009 09:13 AM
emanning

I have a Color picker to lookup color numbers to be kept in fields - I give access to the Color Picker via a button, whn the user has selected a...

Malcolm Hind

10-30-2009 09:04 AM
Steve

I have a form listing Part Number and Part Desciption. PartNo is a small field and description is a wide field. So I wanted my heading to look...

Salad

10-28-2009 07:14 PM
Salad

Hi all, I want to dump some data in XLS without the table header information. Information on the docmd.TransferSpreadsheet Action is telling me...

Mat

10-28-2009 04:21 AM
Mat

I am trying to create an SQL statement in code to insert a record with 30 fields into another table with the same properties. The problem is that...

Lou O

10-27-2009 07:43 PM
Lou O

Hi - I am trying to get a report that will show 12 months of data for a Department (or less if fewer than 12 months are on file), BUT the user is...

sara

10-27-2009 06:03 PM
sara

I'm trying to update a table using as criteria selections made on a form with a combo box and a multi select listbox (lstproducts). The combo box...

Gordon

10-27-2009 09:08 AM
Gordon

A new user loaded my program onto her computer and began entering data. A number of macros had already run successfully before she got to one that...

Tomahawk Lady

10-27-2009 06:24 AM
Tomahawk Lady

I've set the record source of a subform to be a SELECT TOP N query. The problem is that Access appears to perform the TOP N before the implied WHERE...

Randy Yates

10-26-2009 11:28 AM
Krzysztof Naworyta

I am wondering what methodology you use, if you use FindFirst, to find exact matches in a string. If one uses linked tables, one can't use...

Salad

10-26-2009 07:26 AM
hbinc

Dear reader, In a datasheet form you have the possibility to set the field property Enabled to No. With this property you lock the field to...

Simon

10-26-2009 04:02 AM
Phil Stanton

Hi, This must be a problem which lots of people get on a daily basis, but so far I haven't been able to find a solution. I am using Access 2003 as a...

Bobby

10-24-2009 06:15 PM
Chuck Grimsby

I have a continuous form and I'd like to put a separator line after every 5 records. I've searched and can't find an easy way to do this. Any...

Jill McCarthy

10-24-2009 06:03 PM
Jill McCarthy

I have HTML color codes stored in fields - how do I convert these to accurate Access color codes that can be used to set background colors to Access...

Malcolm Hind

10-24-2009 06:02 PM
Chuck Grimsby

I need some advice on the design for a sales lead database. I have 4 tables (salespersons/products/postcode area covered/sales leads). Each...

Gordon

10-23-2009 06:15 PM
Gordon

Perhaps some will find the following useful. With more and more date fields showing up on forms lately, I decided to try to come up with a better...

James A. Fortune

10-23-2009 02:26 PM
James A. Fortune

I have a Report that contains a column of percentages (one at the end of each of the six rows). I have the Percentages Total textbox at the bottom...

zufie

10-23-2009 11:33 AM
paii, Ron

I have an A2000 mdb that works OK on one computer. I have transferred the mdb to a second computer and all is good except that when I click the...

Karl

10-23-2009 10:28 AM
Karl

HI All, My company is switching from Groupwise to Outlook 2007 and so I need to change/test all my applications that have email functionality...

bobh

10-22-2009 08:51 PM
Lou O

Hi I am interfacing an Access database to an SMS gateway and wanted to display the length of the SMS body as the user inputs it. I have tried to...

John Paterson

10-22-2009 08:36 PM
Lou O

Hi, I have been trawling round the net trying to find an answer to this, but all the solutions I have found so far have given me errors. I have a...

Kroaky

10-22-2009 08:01 PM
Allen Browne

Hello, I have a continuous subform within a form. Behind a button on the form, I included validation checks to ensure that various fields (on both...

Odd

10-22-2009 04:34 PM
Odd

I am working with an ocx control, that refuses to be instantiated directly through code. So, I thought I would employ a little "workaround." I...

Vincent

10-22-2009 10:26 AM
Vincent

We have an MDB that will need to impersonate a system user rather than the user using it. IT will assign the security groups surrounding...

Bob

10-22-2009 09:44 AM
Bob

Hi everyone, I'm trying to write a past append qry and as this is the first time I've had a go at it, I think I am way off the mark. I've got two...

Stinky Pete

10-21-2009 07:17 PM
Stinky Pete

Hi, I am using the dynaPDF solution for printing reports to PDF documents. On my own machine using the full Access 2003 it works fine. However, on a...

franc sutherland

10-20-2009 03:38 AM
franc sutherland

Access 2003 Listbox.AddItem w / 5 Columns Is Incredibly Slow As one can see from the function / code below I create a recordset with 5 returned...

JustBoo

10-19-2009 06:46 PM
rquintal@sympatico.ca

Hi - I haven't done anything in Access in a few years now and I'm blocked! I hope someone can help. I have data in a table: Key AccountNumber...

sara

10-19-2009 06:33 PM
sara