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

    Requery a Text Box based on another Combo Box

    BEAUTIFUL! Once I changed the row source for my cboEvent box to the Event Table, I could easily make several fields for the Issaunce table default to the values in the Event table in the After Update event code! (And yes, I am using an ID for the employee names rather than names. :) THANK...
  2. ShellyL

    Requery a Text Box based on another Combo Box

    Hi Pampers.. Yes, the two tables are related (one-to-many, Event-to-Issuance at Event.EEvent_ID = Issuance.IEvent_Num). PHV: Not sure what I could look for?? ~ShellyL
  3. ShellyL

    Requery a Text Box based on another Combo Box

    I've seen similar threads, but nothing seems to fit exactly what I need. Hoping someone can help! I'm dealing with two tables: An EVENT table, where we list all events, and an ISSUANCE table, where we list one or more surveys related to an event. They are linked so Event.EEvent_ID =...
  4. ShellyL

    Using Multiple Forms to run the Same Report with Different Parameters

    Thanks AceMan1! This works EXACTLY as I hoped. Thanks for the clear instruction.
  5. ShellyL

    Using Multiple Forms to run the Same Report with Different Parameters

    Hi! Here is what I am trying to accomplish: I have a query (Main_Query) as a record source for multiple reports. One of the fields on this query is Activity_Dt. One of the reports is Activity_Report, and users generally run this based on a specified activity date range. Currently, the...
  6. ShellyL

    two selects in one query

    Sorry. I don't know how to do that in one query. I would end up joining the two queries shown in a third one to get the results.
  7. ShellyL

    two selects in one query

    So your results will be six columns. Are the first columns from one table, and the last columns from another table? Or are all six columns found in both tables? Give me an example of the tables you are querying and the results you are hoping for.
  8. ShellyL

    Format month and year

    In your report, do you have your date field as one of the grouping levels, and the group properties as "group on month? That usually works for me. And then I ususally have the date field as a group header, and add a text box control to display the month: =Format$([YourDateFieldName],"mmmm...
  9. ShellyL

    two selects in one query

    If you're trying to select the same type of data from two distinct tables, then a basic Union query would work. Select Field1, Field2, Field 3 from TableA where Field1 = "parameter" UNION Select Field1, Field2, Field 3 from TableB where Field1 = "parameter" Is that what you're after?
  10. ShellyL

    Crosstab Query Sort Order?

    Formatting the ID worked great. Thanks for the simple solution!
  11. ShellyL

    Crosstab Query Sort Order?

    Tried that, but then my report sorts 1-Oranges, 10-Mangos, 2-Apples, etc. Anything else? :)
  12. ShellyL

    Crosstab Query Sort Order?

    In the crosstab report example, it looks like you are using the column-heading property to establish the order. I'm hoping to use the Product_ID value to determine the column order. Is there something else I should look for?
  13. ShellyL

    Crosstab Query Sort Order?

    Can you designate the sort-order for a cross tab query based on a field you don't want displayed in the query? The values of the column headings will vary each time, so I don't think setting the column-headings property will work. Basically, I have a base query that selects: - Customer ID...
  14. ShellyL

    Set Default Value for Text Box

    Works great! Here's the exact code I used: Private Sub Form_Load() intOrder_Num = InputBox("Enter Order Number") Me.Form.RecordSource = "Select * from Orders where Order_Num = " & intOrder_Num Me.TxtOrder_Num.DefaultValue = intOrder_Num Me.Requery End Sub And I needed to make sure...
  15. ShellyL

    Set Default Value for Text Box

    I have a form where I want users to be able to edit or add items for an order. “OrderNumber” is a key field. Because the Order Number is critical, I'd like to have that field locked so the user cannot update it. This means they also can’t update it on the blank row where the new item would...
  16. ShellyL

    Data type format problem with linked excel sheet

    Forgot one step. After you Save As Excel, then format the Column as Text the normal Excel way. Close the file. From that point forward, any data added to the Excel file will inherit a true text format. This solution assumes you are working from the same Excel file, not creating a new one for...
  17. ShellyL

    Data type format problem with linked excel sheet

    This is certainly not the most elegant solution but it works for me... I assume that when you changed the column in Excel to text, you used the normal Excel formatting. What I've experienced is that this doesn't "really" change the format when it interacts with other applications. Try this...
  18. ShellyL

    Row numbers

    You can add a text box that numbers each row in your detail section. In the report design detail section, add a text box. As the Control Source, enter "=1". Under "Running Sum", choose "over group" if you want it to re-start numbering with each group, or "over all" to have it continue numbering...
  19. ShellyL

    Choose multiple options for a Report

    FYI - As a non-programmer, I decided to give up on using vba and creating the filter string. Since the value options (my "regions") won't change often, I simply created a form with multiple Text Boxes. The text box Names are Reg_North, Reg_South, etc. The default value of each box is one of the...
  20. ShellyL

    Choose multiple options for a Report

    Thanks Randy. I like using the list box, and assumed that what I need to do is type my list of regions in the "row source" list box vs. linking it to my Region table, and set multi-select to "simple". If I do that, then I should be able to paste the code into the command. But I don't know how...

Part and Inventory Search

Back
Top