Search results for query: *

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

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

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

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

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

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