Search results for query: *

Dodge20, with respect to your earlier response, can you give me a example (in SQL) of how I could use 'Public Function MedianOfRst' in a query to generate the median of a field called 'Values' in a table called 'VTable'? Thanks, Don

Thanks. This is very helpful.

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.

Figured it out: Create reference to DAO and move it into third position of references list. VBA window's menu <Tools>;<References> Thanks anyways!! DTD

Repairing the database didn't work. Same error. Any other ideas?

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

Yes. That solves my problem. Thank-you very much. This website is awesome!!

The mean is calculated as: mean = (sum of x)/n geo mean = sqrt(sum of squares of x)

I did a search for 'format function' and I found the following (see below). I'm now sure how I can use this though? I tried putting it into the query field that calculates the data, but it gives me an error. Any help would be appreciated. FIXED Rounds a number to the specified number of...

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.

Thank-you too Petermeachem. You were very close. I have forgotten a lot more about logarithms than I realized!!

thanks for your help!