Help

Guided creation
Goodmorning, when use the guided creation of tables, query, and other appears an error message that says the characteristic is not installed or something is not activated. Someone knows to give some council? Thanks to all Marco ... 9 Aug 2006 12:39

Sum IF in Access
Is there a SumIF function in Access? I have to SUM a duration of time, but only if a logical Yes/No check box is TRUE. I am working with the expression builder and a Text Box. Thanks for the help. Forgive me...I'm a beginner programmer with expert expectations. *** Sent via Developersdex http://www.developer... 8 Aug 2006 18:34

Command Line Access
I have written a script to back/compact/repair an msaccess db it works fine however i would like to determine if access successfully compact and repaired the database. How could i do this? I am running Access2k Here is the batch script: @echo off copy "w:\l&c\stats\StatsConvert2k.mdb" c:\backups\stats\%da... 31 Jul 2006 13:00

Max Function
Hello all, I am stuck on a query, and was hoping for some help. I'm using Access 2003 with a WinXP machine. I need to find the Max value of a chemical, and also include SiteID, SampleID,Units, and Comments. Example: SampleID SiteID Chemical Results Units Comments Sample1 A ... 13 Jul 2006 11:48

Primary Keys
Most of the reference books recommend autonum primary keys, but the Access help says that any unique keys will work. What are the tradeoffs? I have several tables that have unique fields. Can I use them as primary keys or should I define an autonum primary key? One table has information about the 50 states i... 20 Jul 2006 02:24

Change Font in VBA
I included my VBA below. I would like to change the font of the "strBody" to be Bold, italic, color, etc. The code that I attempted to write is identified by ***. Any help would be appreciated. ------------------------------------------------ Private Sub EmlAll_Click() On Error GoTo Err_EmlAll_Click Dim strBo... 11 Jul 2006 10:23

Creating fields
I want the user to be able to create fields. It seems a bit odd, but I'm trying to make a 'marking programme'. (Teacher marks student's work - records comment or grades. Comments printed on label for student and stored for teacher. As I don't know the structure at the outset, the teacher must create it as h... 10 Jul 2006 04:46

VarPtr() Fun
I have a couple of questions about the VarPtr() function of VBA. I have created my own class, lets call it MyObject and in one of my modules, I have declared an array of type MyObject. In my array, i wish to store one or more references to the same instantiation of a MyObject object. So, I have something like th... 6 Jul 2006 11:47

How to close Acess
I am writing a small application using Access 2000 and I am using a Switchboard. The last item in the switchboard is to be used to close the application.. I selected Exit Application from the dropdown list of functions and it does close the application, but it leaves Access open. What I want to do is exit the... 13 Jul 2006 12:20

Printing Problem
I have written an application to print data on to pre-printed forms. However, I have data need to be printed on beyond the printable area (as there are minimum margins at the report). The right margin is defaulted with a 0.49" margin. Anyway to reduce that? I tried increasing the canvas size, but it simply goe... 5 Jul 2006 16:18