Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mycotropic

  1. mycotropic

    Password "recovery" in Access

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

    Opening another DB from a command button

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

    Password "recovery" in Access

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

    switchboard option to MS Word

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

    SAS Oddities/Input issues

    Thought I would share this little incredibly irritating tidbit; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ data one; infile in1 delimiter=',' truncover dsd lrecl=13; input visitnumber $ flights blocks ; label flights = 'Flights per day'; blocks = 'Blocks...
  6. mycotropic

    Create new record from combo box choice

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

    Create new record from combo box choice

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

    Create new record from combo box choice

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

    Create new record from combo box choice

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

    Summing in Proc SQL???

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

    Problem with the IN statement in Proc SQL;

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

    Bioinformatics Query - Filtering Multiple Columns with "or"?

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

    Bioinformatics Query - Filtering Multiple Columns with "or"?

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

    numeric value not stored as entered (X.90000009536743)

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

    A2000 dataentry; how do I turn off incremental autofill?!?

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

Part and Inventory Search

Back
Top