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!

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

Search results for query: *

  • Users: akaRose
  • Content: Threads
  • Order by date
  1. akaRose

    Check form textboxes against one another

    Hello, I can't seem to figure out something that should probably be pretty easy. It just doesn't work, I'm sure its something dumb! I have an unbound text box with a number of fields of the form concatenated in it (I know its strange not my idea). I need to check that in the each new text box...
  2. akaRose

    Delete first tab of first line in a text file

    Hello, I'm having trouble figuring this one out. I have a text file, that will always have a tab before the first field header which shifts everything over when I import the file to Access. I'm looking for a way to get rid of this, but I'm not sure how to refer specifically to this tab only...
  3. akaRose

    Subquery to count records in a group

    Hello, I had previously asked a question in how to filter records based on date and was able to get it to work. However, it now leaves some groups with only one member, and I don't want to include groups of less than 1. I've tried using count, but can't seem to get it working. The field that...
  4. akaRose

    Query for Report, with groups

    I'm having trouble figuring out something I think should be fairly basic. I have a form, from which there are a few parameters that can be chosen which will open different reports. The reports are based on queries which is where I'm having a problem. I have data that has previously been...
  5. akaRose

    Problems with select query for duplicate records....

    Hello, I'm having trouble with a select query. I'll explain what I would like to see and maybe someone can suggest how I get there. I have a database that has duplicate patients, and unfortunately the quality of data is not always great due to the source - nothing I can really do about it...
  6. akaRose

    Show duplicates where names may have been transposed

    Hello, I'm try to use a execute a query from a form to show all duplicate patients in my database. I have the basic code to get it to work, however due to the nature of our patients we sometimes get reversal of first and last name, they will get tested multiple times over the course of their...
  7. akaRose

    Show matching data in a form as separate sets

    I'm working on a database that will hold bacterial strain typing information. I want to open a form, select from a drop-down the test method, say test1, test2, or test1 AND test2 to look for patients (bacterial strains) that have identical matching results. Test1 is a 12 digit code, and test 2...

Part and Inventory Search

Back
Top