Recent content by dt2demar

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)