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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.