Search results for query: *

This code works Application.CommandBars("File").Controls("Save As...").Enabled = True YET this same code does not work for "Save" Application.CommandBars("File").Controls("Save").Enabled = True msgbox Application.CommandBars("File").Controls("Save") always gives False msgbox (lets you...

Hello, MSND provides this synax at their Office Developer Center INSERT INTO target [(field1[, field2[, …]])] [IN externaldatabase] SELECT [source.]field1[, field2[, …] FROM tableexpression They say "externaldatabase" is the path "to" an external database (the target) and...

For the following --test-- code I get 'incorrect syntax near >' SELECT DataSales.SalePrice, CASE DataSales.Saleprice WHEN > 35000 THEN 'Sold' ELSE 'NotSold' END 'SaleGreater35000' FROM DataSales WHERE DataSales.SalePrice > 35000 Any help needed to produce > results. thanks in...

to all: How do I delete a mdb database via code? My function below works great for creating one, but I'm stuck writing my delete function. help appreciated. finalprime Function CreateAccessDatabase(sDatabaseToCreate) As String Dim oCatalog Dim catNewDB As Database Set catNewDB = Nothing Set...

I query into sql sever with parameter for a field <call it X> with DataType Decimal, precision 2, scale 5, decimal places auto. When parameter for field X is ommited, correct values in X are returned with the query. When Field X filter is used, returned values are zero. example filter...

I need the Median in a crosstab function. From the choices I see only Avg, count , First,etc. functions from the CrossTab Wizard. Seems simple enough, I would us my own median functions. The problem is, I can't figure out how to do it. Any guidence? thanks in advance. Finalprime

Not sure where to start, but I want to display the Crystal Reports' charts in An Access Forms. In some my Access apps, Crystal Reports are generated from the app. Now, I need to write an app where Crystal report’s charts are returned to the form, not to a report. Any info or comments or...

I want to interface MS Access applications with SPSS. As part of the App, high quality Graphics / Statistics are to be produced. I know SPSS can easily work with Access Databases and of course an Access App ( if written properly) can produce about anything needed for SPSS Graphics /...

DoCmd.TransferDatabase acImport Once the password is accepted, my application replaces objects if needed. The Transer is so slow, I must limit the number of objects replaced to just a few. Any clues on how to find the problem? Windows XP, Office 2000, over a network, 40 users. -example...

Hello, Why would a footer formula's value get a different answer depending on whether the detail line is hidden or not? I have a formula field made up of running totals variables. An error occurs (wrong answer) if both the following two conditions are met. 1) the detail line is hidden and 2)...

In a group footer, I have code in a formula (let's call it Fx) that uses (as its variables), output from running totals for that group. In all cases, the Fx value returned is correct if 'Details-hide-Drill-Down' is Unchecked (not used) When 'Details-hide-Drill-Down' is checked (used), Fx...

I’m new to combining Crystal/Access 2000 / SQL Server into one Access App. So far, I’ve got a Crystal Report to run from an Access Form, whereby the Crystal is getting data from a SQL Server database. The SQL is in the Crystal. But I need the SQL to be generated with-in the Access app. How is...

Hi, For no other Crystal Report but one , upon opening the report, I get a message box statement 'crw.32 has generated errors and will be closed by Windows. You will need to restart the program. An error log is being generated.' Once the The ok' button is clicked, Crystral shuts down like the...

need some direction, For reasons beyond my control, on some key reports, management requires my removing sub queries from my SQL's. (In short, I'm up the creek & Dilbertized). I'm in search of all possible alternatives, including replacing each sub query with a user-defined function. Input...

Working with Access 2000 1) At open of formA get message box error message &quot;the recordSource ~sq~cformA~cList221 specified on form doesn't exist' 2) This error message is incorrect. I deleted field List221 off form. 3) In Design View's dropdown field list, List221 is not present...

The Form allows no edits if I populate like so: Private Sub Form_Load() Set r = New ADODB.Recordset With r .ActiveConnection = CurrentProject.Connection .CursorLocation = adUseClient .CursorType = adOpenDynamic .LockType = adLockOptimistic .Source = &quot;SELECT * FROM tblTrans &quot...

When I write code in one formula, then try & copy portions of it (or all ) to another formula, Crystal bombs (hanges up). However, I can copy/paste code within a formula. Does anyone have this problem? If so, what is the fix or work-around? thanks for help in advance. Final Prime

I'm new to SQL design beyond the simplistic of the simplistic Column1 is an account-number from Table-A Column2 is Value1 from Table-B Column3 is Value2, a summed value from Table-C calculated by reading multiple rows based on the account number Column4 is Value3, calculated by (Value1 /...

From MS 2000 Access help screens, ya can't use a cross-tab query as a sub-query. Can you do it with SQL Server?

I need some help with SQL Server . I'm still Access 2000 bound. cn is Active Connection to Server dtemp is Access Current() rsServer is recordset to Server rstAccess is recordset with Access r.Open &quot;tblAccess&quot;, CurrentProject.Connection, adOpenDynamic, adLockOptimistic acct =...