Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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.