Recent content by mgpa

I have managed to determine the problem. It appears to be an issue with Access casting the data from SQL Server indeterminately, specifically the columns in a combo box (incidentally all affected fields are declared within SQL Server as a "money" type). Me.Claimed > Me.PremiumRef.Column(2)...

Thanks for your prompt, but as I said it has 3 columns. Does anyone have any ideas? This is doing my nut!

Hi, as no-one has responded I will give you the following - it is entirely "as is" and I will struggle to respond with much help (I will try when I can). However, most of what you are after is in the MakeLetter() function - i.e. you will need to declare and manipulate a Word.Document type...

Thanks for your prompt reply, but that's how I found the problem as my next code is: If Me.Claimed > Me.PremiumRef.Column(2) And Me.Claimed > Me.Offered Then ' do something ' this code never runs ElseIf Me.Claimed <= Me.PremiumRef.Column(2) And Me.Claimed > Me.Offered Then ' do...

Environment: Acc2k3 (SP2), SQL2000 MSDE (SQ4) and XP SP2 I have a simple table displayed on a subform. With 3 fields, one is derived from a combo and 2 text fields (currency) values, called PremiumRef, Claimed and Offered. If I select a Premium for the PremiumRef combo (3 columns - a unique...

Be careful, if you are using an ADE/MDE compiled file you will not be able to create an Acc2000 ADE/MDE using Acc2k3. Upgrading to Acc2k3 sounds great, but (in this example) you will have to upgrade the Access runtime from 2000 to 2003. Only *consider* upgrading if all your users have Acc2k3...

If it helps, you have missed out " AS " before "booleanC"

Hi, you should probably search the forum as this is a common problem with most (all?) MS products for non-Americans. The problem stems from Access trying to obtain the international options of the PC on which the database is to be implemented upon. However, unless you have direct control of...

Thanks for you comments ghudson. I have been an idiot! :o I have searched through my plethora of MS CDs and I found one titled “Microsoft Office Access 2003 Developer Extensions”. Given that it is separate from the afore mentioned "Visual Studio Tools for the Microsoft Office System" I can...

Ok, I have Acc2k3 professional with Visual Studio Tools for the Microsoft Office System which according to MS includes the Microsoft Office Access 2003 Developer Extensions (http://msdn.microsoft.com/vstudio/office/officetools.aspx) that are required to package an MDE/ADE file using Acc2k3. The...

It is possible to output the results of an Access report into a text field for later retrieval? The concept is simple. I am creating automatic letters using Access reports and I would like to store the results in a SQL Server table for later retrieval and proof of generation. The letters have...

With a minor change it worked a treat: [form_frmFile Damages sub].AllowEdits = Me.AllowEdits (Note the brackets) Thank you.

Hi I apologise for the newbie type question. However, I am a VB not an Access programmer and the syntax for sub-forms always confuses me! (The FAQ by "SJ McAbney" did not help.) I have an ADP project (pointing to SQL Server, if it makes any difference) and have implemented a security model...

Thanks for your help chaps, but I've found the solution (KH gave me the clue). Needless to say it's very Microsoft!! The subform has a viewable height within the main form. However, the only way that I could find of changing the height was to click on the bottom line of the scroll bar for the...

John, sample pics for your information. KH, thanks for the obvious, but I have already tried that. However, it would actually help if there was a "Height" property for the form as in VB/VB.NET. Thanks for the suggestion Marcus.