Search results

Unwanted Fields: PO, DUEDATE, CREDITNOTE, INVTTLEXVAT,PAYID, AMTPD, EXPID, MTHEND, ENTRYDATE, FILE, DAYSDUE, SUPID, SUPPLIER

@MajP method is exactly what I'm looking to do, removing the unwanted fields then export. I'm still trying to decipher it to get it to work with my form (my form is set up in continuous view). I've attached my db, click on 'Reset' to see all the records.

See Post#6 For now I will hard code it but eventually on the form I would set up some check boxes or something for the user to select them.

I'm seeing the problem. Passing the Form's filter means that all the fields being filtered needs to exist in qryExport which defeats the purpose. So back to the question in Post#6. Here's what I'm thinking, 1. Get the form's filtered recordset 2. Convert it to a string and remove fields not...

@MajP it works (y) but is there a way to do this without having to create the query? Because when I filter by VENDISP the parameter is applied to [Search].[VENDISP] which does not exist in qryExport. [Search] is the Form's name.

Ok, I'm back to tackle this problem. I have the recordset SELECT uALLPUR.PO, uALLPUR.INVDATE, uALLPUR.DUEDATE, uALLPUR.VENDISP, uALLPUR.INVOICE, uALLPUR.SUBTOTAL, uALLPUR.VAT, uALLPUR.CREDITNOTE, uALLPUR.INVTTLEXVAT, uALLPUR.INVTTL, uALLPUR.PAYID, uALLPUR.AMTPD, uALLPUR.EXPID, uALLPUR.MTHEND...

Power query that sh##. Just make sure your query and its dependants don't have the Nz function anywhere. https://learn.microsoft.com/en-us/power-query/connectors/access-database and the great thing about a data-connected spreadsheet is that it's dynamic. As soon as the data is updated in the...

Once again @MajP for the win. Your solutions are so simple and easy to implement. Much thanks.

I have 3 forms that basically does the same data entry one for Inventory (deInventory), Expenses (deExpenses) and Foreign Purchases (deForeign). I have an event set up on each of them to detect available vendor credits. Private Sub SUBTOTAL_AfterUpdate() Dim rs As DAO.Recordset Dim CreditCheck...

With a form's recordset, How to export the current viewed recordset. I am using this code but it includes all the form's unbounded fields in the export. Private Sub bntEXPORT2EXCEL_Click() Dim Path As String Dim FileName As String FileName = InputBox("Enter File Name to Save As. (Will be...

Came across this little tip I never knew about https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/use-having-and-where-clauses-in-the-same-query-visual-database-tools?view=sql-server-ver16 very useful knowledge for people, like me, who uses aggregate queries a lot.

@MajP your code works perfectly. Thanks.

Sorry everyone for not responding sooner. You all know how it is, it's just one of those weeks. @Edgar_ Thanks for the explanation. Yeah, it is "hacky". I think I'll try @MajP code together with a pop-up form and see how it goes. I was trying to come up with something Private Sub...

:D This is exactly what I wanted. But now you have me worried Why? Can you explain more?

It's only for display.

I am trying to create an OnDouble Click event for the field APPLIED CHQS. If I add a hyperlink to the field the entire string is hyperlinked. I want to be able to click on each on the values that is separated by a comma. For example, the first record, if I click on either 506 or 1199 it opens...

I was just wondering how to go about extracting the Vendor list with their IDs from the history of purchases. I'm sure there are others who have had this problem before so I was fishing for how they dealt with it.

Good Morning Everyone. @ebs17 The query produced duplicates Max may not work. Let me explain the problem in more detail. I am trying to build a Vendor Listing. My Vendors are separated in to really 2 basic categories:- "Regular" - Vendors we consistently take goods from and have an account...

I have the auto number field in the original table [PURID] @CJ_London Last. I want the Last SUPID for the VEND, so technically if sorted by PURID, Last would also be Largest. Right??

I am using this Source query I know how to get this unique list query How do I join the last SUPID to my unique query? Like this Edit: Preferably as a single query as I want it to feed a combobox.