Search results

Hey all! I'm trying to create an amortization schedule query that will create the schedule in a table. The amortization schedule will need to factor in over-payments and allow me to stub in principal balance adjustments (the over payments). Does anyone know if there is working code out there...

Hey all, I'm using pbauldy's code to filter a report by a multi-select listbox. The only issue is..how do I include more (7 to be exact) listboxes to the code? It seems the OpenReport vba is only allowing 1 where clause? Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'add...

Hey all! I'm having some issues getting this to work. I have 7 multi-select list boxes, which I want the user to be able to select multiple items and have it filter a subform by what is selected. The subform will not be visible, so if there is an easier way with a query, please let me know...

Hey all, I'm looking for a way to email query results. Here is the setup I have. I have a list of accounts and account information, and the email address of the account manager. I'm trying to find a way where I can email out account lists to account managers individually so it includes just...

Hey all, I have a main form with two subforms. I'm trying to get my code so that it allows me to put 1 subform on one tab and the other spreadsheet on the other tab. Heres my code: Option Compare Database Public Function Send2Excel(frm As Form, Optional strSheetName As String) ' frm is the...

Hey all! I'm trying to make a query off another query where it will give me a list of unique managers, and the number of sales reps underneath them. I'm also trying to set it up to omit two sales reps who appear under everyone (hold placements). Here is what I have: SELECT...

I have a subform that is filtered by a textbox on the main form. Is there any way I can add a timestamp to a record on the subform when a user changes anything on that record? I've tried the Macro that is listed on Microsoft's website regarding timestamps, but I had serious issues implementing...

Hi all! I'm trying to do a lookup between two tables, whereas table A includes the product ID and table B includes the price. Is it possible to create a field in table A with a DLookup function on the product ID to get the product price from table B? Whenever I try to type in the DLookup...

Hey all! I've been messing around with this for some time and I can't seem to get it to work. I'm trying to make it so when a subform is updated, it will email the contents of that subform to me. I've got it all working, except for the content of the email part. Any ideas on how I can implement...

Hey all! I've been searching for a while for a way I could make this work.. I'm trying to make it so I could filter a subform from the main form and it will hold those results and allow them to be edited in the subform without it refiltering it. I want it to still be able to update the table...

Hey all, I'm having issues with this one. Table name is CompDates Subform is ViewByMarket Start date is Text13 and End Date is Text15. I want it to filter out any matches between the 7 fields. Here is my code: Private Sub Command19_Click() Dim strFilter As Variant, _ strSDate As...

Hi Everyone, I'm having an issue getting my query to ommit records with a blank field - in fact, it ommits all records. What I'm trying to do is: I have a list of customers, with phone and email addresses. I want to filter via query for only customers with their email address's entered...

Hey guys, I have a form that has a ton of checkboxes. 1. Select Product (combobox) or All Products (CheckBox) 2. Product Type (3 different checkboxes) 3. Includes (10 checkboxes) What I need is these checkboxes to filter the selected data from my Details table and export it to a new...

Hi guys, My issue is this: My form consists of a bunch of text boxes that calculate off of one text box (only one you can edit) at the top of the form. My problem is, whenever I enter this form, it will attempt to calculate all the fields (which takes a good deal of time) when there is nothing...

Hey guys. I think I read somewhere that DCount will not count blank cells, but when I try to do it - it counts everything. Here is my formula: =DCount("[E-Mail]","Detail","Not IsNull([E-Mail])" & " AND [Primary] = [Products]![Product Code]") Basically, I want to count the number of email...

Hey guys, I looked through all the previous posts about this, but it seems that I can't get my formula to work. I keep getting the dreaded #Error message on my form. What I'm trying to do: I'm trying to get the count of all lines that have 'SG' in the Assgn Type column from the Details table...