Search results for query: *

How can I calculate the median in Access? Thanks, Don

This is probably a simple question, but an answer would be greatly appreciated. I've created a VB app and now I'd like to distribute it to my co-workers. I've created a *.exe, but it won't work on another machine without a dll. Is there a way that I can bundle the *.exe, *.dll and anything...

Has anyone ever heard of the original lines of code being retrieved from a dll? In other words is it safe to transfer a dll to someone else and not have to worry about the risk of them retrieving your source code. thanks. T.

Hello, When I try to run my program the compile error I get is: user-defined type not defined The highlighted part of the VBcode is: Dim dbs As Database What is the problem here? This syntax worked on a form in a different database. thanks in advance. DTD

I'd like to set the ranges to a fixed value or have the ranges specified as the min() of some query. Clicking on the axes in design view of the form allows me to change the values, but they aren't fixed. How do I do this? thanks, DTD

I'm not an experienced autocad user and I need to extract info on coordinates from some *.dwg files. I've saved the files as *.dxf and browsed the ASCII contents of these files. I notice that there are several 'AcDb...' features. E.g. AcDbPolyline AcDbEntity AcDbSymbolTableRecord...

I have a short Fortran program that I compiled as a dll (test.dll). I would like to call and execute this program by pressing a command button within a VB GUI. What code would I have to type between these two lines to successfully call the dll? Private Sub cmdRun_Click() End Sub thanks, Don

A friend is currently running windows 98 on their computer but have been infected by virus' a couple of times and while the eradication/fixing software has been run, the computer is behaving strangely, eg. some software cannot be uninstalled, email crashes every time it is opened and now the...

I have found myself in the unusual circumstance of having to convert my Access 2000 database to Access 97. I have created the entire database in Access 2000, including approx. 20 or so tables and several detailed forms, queries and reports with associated VB code. How would I go about, and...

I'm displaying data using a listbox on a form. However it's displaying 12 digits of decimals which is unecessary. I notice that the number of decimal places can be specified when using a combobox properties. How can I do the same for a listbox? thanks,

How can the geometric mean of a field be calculated in Access? The 'mean' is an aggregate function and is easy to calculate, but what about the geometric mean? Thanks in advance.

I am puzzled by this seemingly simple task to calculate the log base 10 of a field of values. Any help would be greatly appreciated. The natural log (ln) is easy to calculate: If 'field1' contains a list of numbers, then 'field2: log([field1])'. How can I so the same for a log base-10...

I wrote a query for MS SQL. The basic structure is: SELECT DISTINCT TABLEA.FIELDA TABLEA.FIELDB FIELDC= CASE WHEN TABLEA.FIELDA LIKE "X" THEN "TRUE" WHEN TABLEA.FIELDA LIKE "Y" THEN "FALSE" ELSE NULL END, FROM... INTO... WHERE... etc. I get an...

I get an error message: "cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option" I am the database owner. How can I run this option? Thanks

I use the query analyzer to execute my queries. I use the drop down menu on the top right of the screen to select the database I am applying the query to. How can I run the query on a particular database, and yet include fields from tables in another database in my query? eg. Select Distinct...

I have some queries that I wrote in MS Access and I'm trying to convert them to SQL server syntax. In access, the SQL code is as follows: select distinct TableA.Field1 TableA.Field2 IF(TableA.Field3 like "X","1",IF(TableA.Field3,"Y","2",TableA.Field3))...