Search results

Thank you so much. Please find attached the database with sample data in the order final table as well as the append and select queries. Let me know if you are unable to open it.

Hi. I want to thank you for replying. The criteria does produce records from the CustomerDetails query as listed in the code but only without the criteria included. I am looking to have data upload doesn't exist in the master invoice. If I click to append without the criteria in the code, it...

Hi- I have a query to append new invoice records to a table I name master Invoice. I am having problems getting this query to look at query CustomerDetails and only append records that do not exist in Master Invoice. I have included my query below. This query with the criteria included will not...

Hi- Thanks for your reply, but I am a bit lost in the translation you mention. I am attempting to output from a table of the final results. How do I filter the report record source? Also is it possible to have the TransferSpreadsheet call for the grouping. The reason I ask is there maybe...

Thank you so much. I'll review and update. :)

Hi- I have created user defined function for lastdayofweek, lastdayofmonth, and firstdayofmonth. When I apply this function to an expression in my query, it returns a julian date. How do I apply the format for the calendar date? Maybe I am not calling my function correctly, so any help is...

Hi I replied to post of Exporting to the same XLS file on 1/4, but didn't receive a reply. I need to export out from one table to Excel grouped by client ID to each worksheet. The Excel report will have approximately 15-20 worksheets. The DoCmd.Output exports each client to their own...

Hello- I am interested in having this applied to my database, however, I wanted to know how to updated the command for a group by? The output for each sheet will be grouped by customerID. One Excel files with approximately 25 sheets which is based on customer name. Thank you- Anissw

Thanks Alan. It appears to demostrate what I need. I'll test and let you know the outcome.:)

Hello- I have created a database and report to summarize specific total returns in a week. However, I would like change this so that the user can select from a dropdown the parameters in question from 3 combo boxes on a form. I was able to create the form, setup the combo boxes to pull the...

Thanks so much!! As you indicated, I made the changes and it did work.:D

Thank you so much for replying back. I am including a screenshot of when I choose the 1st combobox, it displays the ID field instead of the ReportName field. When I change the column count, it then displays the ID field and ReportName field. I am interested in having the ReportName field to...

Hi- I have a database that has multiple buttons for generating 1 report, but different restrictions. I am taking this database and removing the buttons to implement combo boxes I have 2 combo boxes currently setup and want to implement VBA script with conditional statements depending on the...

Hi- I will be working on Crystal Reports soon. However, there are a few scheduled reports when ran will generate a Proxy $4 or Proxy $7 error without running. Does anyone know what this refers to? Thanks- :banghead:

Hi- It's has been awhile since I programmed in Access and while somethings are familiar, a lot I will need some help with. So without further ado, I'll start with a post Anissw