Recent content by smpayne69

I have 2 pivot tables with string groups and their values. I want to calculate the 2 grand totals outside of the pivot tables. I can do the simple calculation, however when more groups are added to the pivots, the physical position of the grand totals move and I get errors. Can anyone help???

I am running a query where it counts the number of records in a database. I want to add a field to the query that will make a division calculation against another field in the query called instances. Can someone help?? :) Thanks.

This may be a very neebie question, but I have a form with drop downs for data choices. When an employee finishes with the selections, I would like all the data transferred to a table as a record. How would I go about doing this. Any assistance is really appreciated!!

I created a macro in Word to essentially take a series of numbers in a column and format them on a single line seperated by a comma and a space. I want the macro to run until it reaches the end of the list of numbers. I am new to VBA so please be patient. I have attached the code below: Do...

Great! Thanks so much for you help!

I have a query in which I need to pull all values from a field that is exactly 10 characters in length (Alpha or Numeric). Can anyone help me with this? Thank you!

Anyone Else?? I am still unable to get this to work. It only works on the initial load of the form, but not after a requery....anyone know what I am doing incorrectly? Help...please! PS...even if someone knows where I can DL a sample database with a similar structure that I can take a peek...

mmm I created a macro to query the Supervisors table 'After Update' and it still only works the first time I load the form. Any other thoughts??

I have 3 fields on a form that are combo boxes. The first field is linked to a table with Department names. The second field has Supervisors for the departments. When I first load the form and select a department, it correctly runs the query that populates the supervisors in the department...

Thanks for your help. Thanks for trying, I appreciate it.

Outlook Actually, the message is from Microsoft Outlook, not Access...sorry, just noticed it.

Warnings I have set Warnings to No in the macro list, but that does not stop it. :(

I am emailing a report from access and am getting the following pop-up: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" How do I get that to not pop-up and spoil my automation dreams??? Help!!

Thank you! Thank you, much appreciated.

I have a query where one field is Date:Now() so that todays date is forced in. However, it is giving me the date and time. I only want the short date, how do I achieve this??? Thanks!