Recent content by mycotropic

I am the owner of the database. I purchased the equipment that is used to collect the data and the storage bin for that data. I see nothing in the least unethical about saving my data entry staff time and using the data that I paid to collect. If I were to take that database design and sell it...

Hey GoingDeep; I am doing something similar and haveing an irritating problem. I'm using; Private Sub RunVisitsMerge_Click() On Error GoTo Err_RunVisitsMerge_Click Dim WordDocument As Word.Document Set WordApp = CreateObject("Word.Application") WordApp.Documents.Open...

HI; I work in research. We are collecting patient data using a device which writes to an Access database. We will be seeing around 300 folks data using this device. It would save an INCREDIBLE amount of time if I could load this database with my patient data so that the tech won't have to type...

Hi - OK I'm trying to do almost exactly this, except that I want to open a merge document with a button on a form. The merge document is pointed at a query which draws its between values from the same form. This works fine for passing those values to Reports - but I can't seem to get it to work...

>1) What data source is used to populate your combo box on >the first form? A table that contains all of the valid VisitNumbers - there is an invisible text box that contains the value in the combobox since earlyer i was told that i couldnt capture the value selected in the combobox and use...

Apparently my stupidity knows no bounds! In the switchboard the code now looks like this; stLinkCriteria = "[VisitNumber]=" & "'" & Me![shelf] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me![shelf] which compiles so i assume that it is passing the...

I wish that I were that smart; Thank you for your help but could you give me one more step here - what does the VB actualy look like wherin I 'check' that property? Once I get the logic of this 'check then set' down MOST of my problems are solved!! I work mainly in SAS you see, where I can...

Hi! I KNOW that this is very simple somehow; I have a data entry switchboard that alows users to select an ID using a combo box, then, once they have an ID, select which data they want to enter; choose a form. If the ID in the combo box is already in the table that that form is conected to, the...

The only good SAS resources I have ever found are the Manuals and the SAS website. Once you have a few years under your belt you can wade through the documention pretty quickly. Oh yah; and if it involves output other then the regular SAS text, formated as HTML, give up and buy MatLab or...

Hi; Have tried leaving PROC SQL (where I always get strange errors with anything I do) and doing what you want in a qualified DATA statement with a KEEP thrown in?I think that PROC SQL uses memory differently, hence the error message. Hope that helps at all. g "Man is the cheapest...

I typed in the data you used, ran the query and got exactly the answer you were looking for. Are you sure that you're putting >=50 on different OR lines in the query? if you put >=50 in Criteria for each variable it will do as you said. If you put the into different OR lines for each variable it...

In the query include all 5 fields, then Criteria for the first is >=50, for the second put the >=50 in the or collumn below criteria and so on. I just did it, it works. g "Man is the cheapest computer we can put into a spacecraft and the only one we can mass-produce with unskilled...

HELP! OK; I type in 5.1 into a field where; field size = Single format = standard decimal places = 1 and, when i export that value to excell it tells me that the value is; 5.09999990463256 I didn't type that number in Bill - where did it come from? this also hapens in a file defined as; field...

It happens in all of our win2k databases. We are in research and have several data-entry folks. one front end, one back end and everybody uses them. We have other limited use databases as well and they act the same way. In fact, when I started ranting about this irritating activity everybody...