Search results for query: *

has no affect. Application.CommandBars("File").Controls("Save").enabled = True and Application.CommandBars("File").Controls("Save As...").Visible = True These "SHOULD" always work in "tandem". If SaveAs... is successfully set to True with the above code, then "Save" should be set to True...

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...

Upon debuging as you directed: In the query you'll notice I am inserting only Streetname... Since both the input-output have primary indexes.....the Insert needs BOTH the Street and primary key..................INSERT INTO tblsubjectcomps (UID,StreetName.... Thanks! final prime

INSERT INTO tblSubjectComps1 (StreetName ) SELECT StreetName FROM tblSubjectComps IN 'K:\Spatialest_Library\libArea11.mdb' tested this sql. It gave no run-time error but also does not do the insert. As you see, the single quotes were used.

I get error message "Syntax Error in FROM Clause" Function ri() On Error GoTo x Dim pathfile As String Dim rxy As New Recordset rxy.Open "tblpathFiles", CurrentProject.Connection, adOpenDynamic, adLockOptimistic pathfile = rxy!pathfiles rxy.Close Dim sql As String Dim db As Database Set db =...

When you say IN (C:\docs\ThatDB.mdb) I don't understand how Access would 'know' the connection has been Set to dbR. What you have here is a only a path & a file name.

Do you mean as an example: dim dbr as Database Set dbR = DBEngine(0).OpenDatabase(pathfile) INSERT INTO ThisTable SELECT ThatTable IN dbR

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...

Alex, Excellent, Thanks finalprime

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...

George, thanks for the education. much appreciated finalprime

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...

lorirobn. This is the 'guts' of a function that I worked on this morning and has worked. 1) checking a "Test" table in an application. 2) Here, searching for the field name called "PIN". SearchForFieldname = 0 Dim rstTmp As DAO.Recordset Dim fldTmp As DAO.Field Set rstTmp =...

Not in FMS. Just finished looking myself.

A simple Access crosstab function example using Wizard: SELECT tblSalesData.Code, Avg(tblSalesData.SalePrice) AS AvgOfSalePrice FROM tblSalesData GROUP BY tblSalesData.Code; Using my MedianFunction and VB SELECT tblSalesData.Code, ReturnMedian("tblSalesData","SalePrice") AS MedianSalePrice...

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 /...

Douglas, Over network: delete time < 1 second import time +- 9 seconds for Modules ; size has no affect for Forms: smaller sizes take slightly less time. Locally: Process cut down by 20%. ++++++++++++++ In sum, small-or-large and network-or-Locally, no significant difference...