Search results

Hello, it has been a while since I have posted. Anyway here goes... Is there a way to save a form as a template and then apply that form to different tables? I run into the issue having multiple tables that I need to interface with the same form. Any recommendations? Thank you for reading.

Gizmo, Thanks for your response. I was able to solve my problem using a UNION SELECT Query. Thanks, again.

Rabbie, May the heavens above rain down blessings on you!!! Thank you very much, that is exactly what I needed. Here is my query via SQL statements: SELECT [Product] FROM [Georgia] UNION ALL SELECT [Product] FROM [Florida]; Works like a champ. Thanks, again.

Is there a way to combine queries? Or combine two charts into one? Thanks.

Hello again. I have a drop-down list that contains string values. Is it possible to construct a query that will sum the total number of times that the string value is selected? For example, String Value Sum ================ Chicken 3 Beef...

Thanks for the response. The part about storing the running totals in a separate table is what I am having trouble with. With the IIF statement, I get the correct totals. How would I store the values in the other table and how should I construct the relationship (or is it necessary)? Thanks.

Here is what I have: A report based upon a table with the following values: 1 Table Employees Columns: Name, Score, Recommendation1, Recommendation2, Recommendation3 I also have unbound text fields in the report which contain the following in the control source...

Sorry for the delay...finals at school. Anyway, I figured out what the problem was. Access by default, was expecting a more complex chart, thus the values it needed were not there. I slimmed down its values and the chart works perfectly. Thanks!

Hello again. I have a simple query with the following results: Above 4 Average 10 Below 5 Whenever I try to insert/add a chart (whether it be a bar, line , pie...etc), the chart does not display correctly. Instead of seeing my values, I see...

The iif statement in the control source worked like a champ. Thank you very much. Side note, how long have you been using Access? Thanks, again.

Hello. I have a report that I would like to auto-calculate the total number of instances in which a string value is selected. I have the following string values available from a drop-down list: Below Average Above I would like the report to have the total number of of Below(s), Average(s)...

Hello. My select case is not working properly. The code compiles fine, however after updating the value of the combo box, the recommendation field is not updated/auto-populated. Here is the code that I have (it is in a sub-form that is linked to a table): Private Sub Score_AfterUpdate()...

Thanks for the response. I would however like to know if it is possible to have VBA code modify a field based on a selection from a drop down list. I will look into modifying the table design to have a drop down list for the recommendations. Thanks.

The recommendations fields can be rather long. I set their data type as memo. If I set a lookup list to be of type memo, can I then trigger a certain afterupdate event when the user changes the score? Thanks.

Hello. Here is my situation: 1 Table Employees Columns: Name, Score, Recommendation1, Recommendation2, Recommendation3 1 Form On the form, I have drop down box that enables the end-user to select a score (1,2,3). The recommendation fields in the Employees table are pre-populated with...