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

    form filter to show multiple records

    03-42 is one location Here is a sample list of 7 distinct locations 03-42 03-43A 03-43B 04-02 04-012A 04-12B 04-12V
  2. dcorleto

    form filter to show multiple records

    Works great. But what I need to be able to do is show all the records in that location. For example, if I have a location 03-42, I would like to be able to enter that location in the search box, and have it display the group of records that are associated with that location. For instance...
  3. dcorleto

    form filter to show multiple records

    I have a table with a field called LOCATION. I would like to make a form where a user could input a location and click search, and all the records in that location would show up. Can someone please give me a hint to jump start. Thank you so much. dc
  4. dcorleto

    SEARCH FROM DROP DOWN LIST

    Very cool - it works, but once I select the location, I get an error saying changes requested to the table not successful would create duplicate values in index primary key or relationship...etc. Otherwise, this would be great. Also, any way to type in a string that doesn't necessarily have to...
  5. dcorleto

    SEARCH FROM DROP DOWN LIST

    have a combo box on a form that user can drop down to search for a record. Have it locked so user cannot change the list which comes from a primary key field in a table. Is there a way to allow the user to type in charactes that would bring the items in the list close to what the user is...
  6. dcorleto

    Get user input and generate a report

    I have a table linked to an excel sheet. Have run a Query that selects only the fields needed and returns all records. Would like to have a form that the user can input up to 10 employee numbers, and have the query run and return only those records that were input by the user. I know this is...
  7. dcorleto

    Move inventoryrecords easily

    Getting there slowly - on the form, I have the subform that contains the assets. In that subform the Asset Tag column appears. It is related to another table TAGS that contains all the asset tag numbers. Is it possible to add a record while in the subform and have it append the primary Tag...
  8. dcorleto

    Move inventoryrecords easily

    On my, I think that worked - can it be? How'd you do that????
  9. dcorleto

    Move inventoryrecords easily

    This is where I get lost - no SQL experience. Based on your suggestion I created a form. Named the text boxes. Made the command button, event prodecure and put in the following code: FORM_ID_358989923 is actually the full name of the ASSETS table. What/where did I miss putting something in...
  10. dcorleto

    Move inventoryrecords easily

    Have ASSETS table: Tag Asset Location Model Serial Received Misc Have 2 more tables TAG - only one field and it's primary indexed no duplicates LOCATION - only one field and it's primary indexed no duplicates Have both of these related to appropriate fields in ASSETS table. Am I on the...
  11. dcorleto

    Move inventoryrecords easily

    Would be great if I could just have a form that shows this: Enter Asset Tag: XXXXXXX Enter New Location: XXXXX and then a command button to do the rest. That sounds so simple, yet sounds like it would be alot of work to do somehow.
  12. dcorleto

    Move inventoryrecords easily

    Don't need history - I create a table with Primary key for Location, then created relationship. On the subform, I've changed location to a combobox, and selected source of the primary key table. It then gives me a drop box to pick from and I'm selecting the new location that way - then I put...
  13. dcorleto

    Move inventoryrecords easily

    I have db with tables: assets, employees, locations. They are all related, and somehow I've got forms actually working where I can see assets by location, or by employee. Ex. search for an employee and see what assets they have in a subform. My question: what is the best approach now to...
  14. dcorleto

    New db to track assets

    Looking for advise on a structure for maintaining hardware assets. Currently I am in the process of collecting model, serial, asset tag and locations in one table. Have another table of employees and the same location field in that table, so thinking that the location would be the common...
  15. dcorleto

    Update query - based on non matching criteria

    I need to update employee ID numbers into a table from data in another table. The table with the employee ID's have first and last name fields. The table that needs updating has the same field names, but the naming convention is different. For example, one table has Doe, John while the other...
  16. dcorleto

    Command on form to print only the displayed record

    Obli - Presto and another question ! Your idea worked as follows: Private Sub Command85_Click() Dim strCriteria As String strCriteria = "[Code]=[Forms]![Video Productions]![Code]" DoCmd.OpenReport "Workorder", acPreview, , strCriteria DoCmd.PrintOut acPages, 1, 1, , 1 End Sub The form prints...
  17. dcorleto

    Command on form to print only the displayed record

    For some reason, none of these suggestions are working. The form is based on a query with expressions. Records cannot be added to the form or the query. Could this have something to do with why I am getting errors? All I need to do is have the report print just the page for the record that I...
  18. dcorleto

    Command on form to print only the displayed record

    DoCmd.RunCommand acCmdSaveRecord This gave me an error saying Save Record command not available now
  19. dcorleto

    Command on form to print only the displayed record

    Thanks Obli - Here's what I have based on your message: Private Sub Print_Avid_Sheet_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workorder" stLinkCriteria = "[code] = " & Me![Code] DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria...
  20. dcorleto

    Command on form to print only the displayed record

    I believe I need a Where clause, but what syntax would I use so that only the current record would be printed from the report.

Part and Inventory Search

Back
Top