Recent content by ShellyL

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

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

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

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

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

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.

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.

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

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?

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

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

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?

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

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

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