Help

ADO Vs Jet/DAO for compound aggregate function
I just wasted a long time figuring out this and I figure if I post it might save someone some pain! Jet (DAO) will allow you to to use nested aggregate functions like building blocks, e.g.: SELECT A, sum(B) as Answer1, Answer1 * 2 as DoubleAnswer From Table GROUP BY A; If you save this query and ... 10 Nov 2006 09:45

Compact Database
Hello friends, Is there a way I can run the repair and compact database via code? I update my database every month using txt files and after that the file is imported I would like to run a macro or a code to automatically run this function. Any help? Thank you. ... 9 Nov 2006 02:35

Controlling a Toolbar from another Form
I have an MS Access app with multiple forms. One of the forms has a Toolbar (MsComctlLib.Toolbar) and it works as advertised. I handle the buttons in the Toolbar1_ButtonClick event. I would like to be able to control the toolbar from another form. Forms!frmClipping!Toolbar1.Buttons(2).Clicked = True does not... 7 Nov 2006 19:36

HELP: Response Buffer Limit Exceeded
I am running IIS v6.1 on a virtual hosting server. Changing the default metabase value is out of the question. Can someone tell me how I can fix this script? Thank you. <% set conn = server.CreateObject("Adodb.connection") conn.open application("connStr") manualID = request.querystring("manualID") if r... 3 Nov 2006 17:24

Opening XLS book with spaces in the title
Hi I'm tring to open various xl books using Attach = "" & cboAttachments.Value & "" stAppName = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " + Attach Call Shell(stAppName, 1) However, some of the sheets have spaces in the title eg "High Level Assessment.xls" So instead of trying t... 1 Nov 2006 07:49

Mail Merge
Hello I have built an application using MSAccess 2000 that has a feature where the user can select a list of clients and then send fields from the client table to a .txt file to be used by a mail merge program. To transfer the data from the client table to the .txt file I am using: DoCmd.Transfe... 29 Oct 2006 19:46

Query not updateable
I link fields in tables 1 and 2 (one to one or unmatched) in order to update fields in table 2 with others from table one. If I use criteria from one of these tables there is no problem but if I link in a 3rd table in order to retrict the action, I get an error message saying that the query is not updateable (if no... 24 Oct 2006 10:09

Access Defaults in Standard SQL
Just want you all to know (just in case you have this issue) that some standard sql doesnt work by default in MS ACCESS 2003 anymore (I didnt know this, not sure if others do or not - and I couldnt find an answer to my problem anywhere else on the internet) I was getting a maddening syntax error on an alter state... 22 Oct 2006 02:31

FileSearch Object. Strange result with Wildcards
Access 8 on Win98 and WinXP I'm having trouble with wildcards in the .Filename property of the FileSearch Object giving different results on win98 and XP. I've been successfully using FileSearch in win98 to fill an array with filenames with no problems since about 1998. From the 97 Help: (The Filename Pr... 23 Oct 2006 10:33

Excel Spreadsheet Grid as interface for Access
Hi all. Wondering if anyone could point me in the direction of resources that could assist with using a spreadsheet grid in excel as the interface for dropping values into an Access table. I'm not having much luck searching the internet. Basically, I'm after something like this pitiful graphic demonstrates ... 26 Oct 2006 02:29