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

    Transparent Command Buttons!

    Cool. A little easier than I thought. Thanks. Gene
  2. EPBoone

    Transparent Command Buttons!

    Ok, what about a disappearing command button? On one of my forms, whenever you input the same data into one record as you have for another (not an indexed field, it just lets you know that two records have similar info), a list box appears to let you know which records they are. To keep it...
  3. EPBoone

    The natural order of things......

    I am not even sure how to explain this, but I will try. At the end of each week I have to send to each individual customer, a list of all the requisitions that they ordered for the entire week. This list provides the customer with Req. #, Material ID info, Quantity, and the latest status...
  4. EPBoone

    Importing Data Automatically

    I have been trying to use the TransferSpreadsheet in a macro, but it won't do it. I keep getting an error message saying "System Resource Needed." Any idea what that means? I also tried to use the TransferText method, but it keeps telling me I don't have permissions to read the...
  5. EPBoone

    Same query information, different results.

    Right now, the only way I can get this to work is creat a form and make subforms with all the different Queries, but I have to type in the same dates 10 times.
  6. EPBoone

    Same query information, different results.

    I take that back. What I was going to do won't work either. The thing is, I have a table that lists aircraft parts. The fields involved are [JD T/I] which is the date I received the part, [JC JD] which is the date the part was repaired, and [Status] which is the type of repair that was done...
  7. EPBoone

    Displaying query results on a form/report

    Is there a way to display the information that the user has to enter to get results from a query onto a form or report? Huh?!?! I mean, say I have a query that asks you to type in a date ('Between [Date] and [Date]'). Is there a way to have those entries displayed on the form or report that...
  8. EPBoone

    Same query information, different results.

    Not quite what I wanted, but thanks. What I need is ten different sets of results for each status. Actually, I am nuking this. I just realized that what I am doing is actually a pretty easy thing. Thanks though. I appreciate it. Gene
  9. EPBoone

    Same query information, different results.

    Alright, I have ten different queries. Here is the SQL for one of them. SELECT [DCU LOG].[Doc#], [DCU LOG].JCN, [DCU LOG].[PART NO], [DCU LOG].SERNO, [DCU LOG].[JD T/I], [DCU LOG].MCN, [DCU LOG].PC, [DCU LOG].STATUS, [DCU LOG].REMARKS, * FROM [DCU LOG] WHERE ((([DCU LOG].[JD T/I]) Between...
  10. EPBoone

    Multiuser Form

    Right now, everyone that uses this program uses the same UserID, but I think only two or three people use that specific form. I guess I could give them there own UserID. We need to all be able to use it at the same time. How would I capture their UserID's and format the report to do that?
  11. EPBoone

    Multiuser Form

    I have a form that is used to edit and print out records. To print a record, you have tag a check box so that when you print, it will only print the records that are tagged. If two people are using it, then it will print the records that both people have selected. How can I set it up that both...
  12. EPBoone

    Date format

    We use a Julian Date for just about everything where I work. How can I format the date for this? For example, a Julian date for March 16th, 2001 would look like: 01075. 01 being the year. 075 being the day of the year.
  13. EPBoone

    Reports and forms based on several queries and/or tables.

    I feel a little stupid with this one, but I have tried just about everything I know (which isn't much), and I cannot get this to work the way I want it to. I have a form: 1348-1 which is based on a query: Q-1348-1. The query is getting information from three different tables: DCU Log, ICRL-1...
  14. EPBoone

    Editing null values from Dlookup result in Form

    Never mind. I figured it out. Thanks for your help anyway. It is greatly appreciated!!!
  15. EPBoone

    BAR CODE PRINTING

    Excuse me, it reads the "*" on the end and at the beginning.
  16. EPBoone

    Editing null values from Dlookup result in Form

    You are right. Q-ICRL is a query not a table. Sorry about that. You are correct also about adding information. I don't want users to be able to change existing part numbers, but I do want them to be able to add new ones. SELECT DISTINCTROW [DCU LOG].[Doc#], [DCU LOG].SERNO, [DCU LOG].MCN...
  17. EPBoone

    Editing null values from Dlookup result in Form

    Well, the form is for a shipping document. I have for example, two fields (Document Number and Part Number), Three tables: 1. (DCU Log) A log with all of our Document Numbers, with fields part number and serial number. 2. (1348-1AS1) The table for the shipping documents. (Also the form name.)...
  18. EPBoone

    Editing null values from Dlookup result in Form

    On my form, I have several fields that are updated automatically with fields from two other tables by using Dlookup in the control source of the fields in the form. The problem is, when a null value is returned to these fields, I need to be able to manually input the information, but I can't do...
  19. EPBoone

    BAR CODE PRINTING

    FYI. I don't know if your scanners will do the same, I am using Barcode39 right now and it took me awhile to figure it out, but our scanners can't read just the barcode, because it reads it with "*" on each end of the info line. If you experience any problems with reading the...

Part and Inventory Search

Back
Top