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!

Search results for query: *

  1. caosity

    Enter key behavior

    Ok, I have 2 questions that I am struggling with. First, due to limitations of the built-in lookup dialog box, I have created my own. The form opens on cntrl+spacebar likes its supposed to, and I can select an entry and click the OK button for it to be inserted into my primary form. First...
  2. caosity

    copying files with filename in table

    Thanks for the information, unfortunately, due to the way the files and folders were originally set up, before me, I don't think I can have access add the extensions. The files are named using a person's social then .med.pdf, there are two dots in the file name. We have changed the process to...
  3. caosity

    copying files with filename in table

    Ok, I need help. First I am running Access 2000 on a Windows 7 computer, don't laugh, I know. I have a database called testing containing a table called Table1. The table consists of a single field, FileName. I am trying to code a module to look in a particular folder and copy all the files...
  4. caosity

    Opening report from pushbutton.

    Ok, I know how to create a pushbutton to run a query and return a tableview, or even open a report, and this works when everything is in the working directory. I have, however, run into a problem when trying to open a report not in the working directory, since not everyone uses the same working...
  5. caosity

    Locate record in form with value in field of another form

    Awesome. Thank you very much.
  6. caosity

    Locate record in form with value in field of another form

    Could you also help me with some code that if the person is not found in the second table, now I have other tables involved, that it gives a custom error message?
  7. caosity

    Locate record in form with value in field of another form

    The frm.SS_#.locate("SS_#",SSN)almost worked, but I got an error message that there wasn't a field called "SS_#" in my table, which since in quotes I was able to leave out the "_" and it worked. I don't mind them changing the preference to another record in the table, but now the button works...
  8. caosity

    Locate record in form with value in field of another form

    Ok, I know this is simple, I just don't know what I am doing wrong or missing. I am using paradox 5. To simplify matters, I am using 1 table and 2 forms, x and y. Form x displays the social security number, last name, first name, and middle name of a client. Form y displays the same and...
  9. caosity

    Querying by value in form field.

    My apologies, but I think I may need that example. Where do I set the field variable? How do I use the variable in a query where the variable equals the value in the field as displayed on a form? Also, while I have someone who knows how to do this, say instead of a query, I would like to open...
  10. caosity

    Querying by value in form field.

    I have tried the same thing. No luck. I assume it will take a bit of SQL, which is fine, just need to figure it out, or find someone who knows how to do it.
  11. caosity

    Example Elements

    1) Yes, the records in one table are in the other. 2) No, there may be more than one person with the same last four digits, but I am also joining the tables by dates of birth. The likelihood that someone will have both information the same in our tables is slim at best.
  12. caosity

    Querying by value in form field.

    I know there has to be a way to do this, but I just can't seem to find it. Is there a way to form a query using the data displayed in a field in a form as the criteria? In Access I would just use Form![fieldname, or something to that affect.
  13. caosity

    Example Elements

    Is there a way in a double query (a query involving two tables) to use example elements to match records based on partial data in a particular field. For instance, I have two tables, both with a field for social security numbers. But the first table only has the last four digits. I want to...

Part and Inventory Search

Back
Top