Search results for query: *

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

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

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

Have a form with search capability. Once I am on the record that I want to see on the form, How can I use a Command Button to print a report for that selected record only? When I click the command button it runs the report for all the records. Thanks in advance

Have a report named "Workorder" setup from a Query. The total number of records is about 30. I would like to have the following happen... From the switchboard have an option to generate a workorder. A Dialog box would open requesting the "Code" (that is, one of the fields that has a unique...

Have table Projects with fields called EmployeeID and ContactName. Have another table called Contacts with EmployeeID and Name. Have set up a relationship between the two on Employee ID. Would like to have the database populate the name field automatically when I input the employeeID in the...

I three tables. 1. Projects (code is unique field) 2. Vendors (have a a list in there and need to add as necessary) 3. Resource (a way to categorize what the vendor does - have some things in there, and need to add as necessary) I want to create a form that selects a code from the projects...

Have the following mess of SQL code that creates a query based on several tables and other queries: SELECT SubProjects.Code, SubProjects.Client, Val(Nz(Sum(Budget.AvidHours),0)) AS SumOfAvidHours, Val(Nz(Sum(Budget.AvidSub),0)) AS SumOfAvidSub, Val(Nz(Sum(Budget.GraphicsHours),0)) AS...

I have a totals query that sums several fields. I would like to make an additional field that takes three existed "summed" fields and adds or subtracts the values in each. How might I go about this?

I am on a trial version of a program called Formdocs and have created a form that calls data from various tables in an Access database using ODBC. That's fine. I have created another table in the database that I would like to hold the results of completed forms (includes subtotaled fields...

I have the following that needs to be created in table: Stock Quantity Price Amount The Stock is tape and could be VHS, Beta, or Other The Quantity could be any number between 1 and 10, however, (and here's where I get confused).... The Price is as follows - Quantity of (1) is one price...

I have an excel sheet with only two columns - one named Project and the other named Subcode. Is it possible to create an small application using VB to be able to search on either one of these two column headings? I would like to be able to put in part of either one or the other, and have it...

Please help - I have the following paragraph in Word Had last week Had last 2 weeks Had last 3 weeks Had last month Would like to select the text, run a macro and then have the following result: Had last month Had last 3 weeks Had last 2 weeks Had last week (Thereby reversing the order of...

I have a table that is formatted with all the appropriate sizing, borders, etc. I need to have several other tables formatted exactly the same way. How can I easily do that? Can I create a style based on the original table, or create some sort of empty table template, then paste in the other...

I would like to have the beats per minute tag shown in a column when viewing mp3 and wma files in Windows Explorer so that I could view/sort them in that order. Is there a way to show the BPM details without using 3rd party software? The BPM tag is already embedded in the files and has already...

I have a document which contains text and tables The tables are formatted as such: text(paragraph mark) text(paragraph mark) text(paragraph mark) I would like to write a macro to have the tables now reflect the following: text(tab)L(tab)-(paragraph mark) text(tab)L(tab)-(paragraph mark)...

First, thanx for all the help I have received so far in this excellent group... I would like to highlight/select some lines of text - there is a paragraph mark at the end of each line. I have some autotext already created. I want to automate going to the end of each line in the highlighted...