Search results

I'm using "DoCmd.TransferSpreadsheet acExport" to export two queries to two existing worksheets in an Excel workbook (the exported queries are used to populate pivot tables on the other worksheets). The export works, but I've noticed that the export doesn't completely overwrite the exisiting...

Thanks Galaxiom. I followed your instructions and the syntax seemed to be correct however, it would not filter by the control. I figured out another way - I made the filter field default to what I wanted to be filtered on open and I made the form open action the filter cmd.

I have a command button that I want to open a form and filter a field on a subform. The main form is "frm_QuotingListAll" the subform is "frm_Quoting Datasheet subform" and the field is "Transfer Status". Could someone please help me with the subform control syntax? Private Sub...

I think this is a simple question, but I can't seem to find the answer. I have a table in which the key identifier of each record is a field called "PolicyID". The problem is the one policyID can have multiple record entries. I want to combine all the data into one record. Here's what I...

Thanks very much David, that did the trick.

I have a command button that opens a new form and filters that form for the ID of the previous form: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_QAList" stLinkCriteria = "

Thank you so much Trevor, this has been driving me crazy for two days now.

I have a command button which when clicked, exports a query to an excel file using the following code: ------------------------------------------- Private Sub cmd_exportquoterpt_Click() On Error GoTo Macro_ExportQuoteRpt_Err DoCmd.RunSavedImportExport "QuoteExport1" Macro_ExportQuoteRpt_Exit...

Brilliant! Thank you Bob.

Thanks Bob. I cut down the code to just Me.YourSubformControlNameHere.Form.Filter = "" Me.YourSubformControlNameHere.Form.FilterOn = False It now clears the filter. I think I can't get the clear all controls code to work because I have non-filter text boxes in the header the identify the...

Money as always, thank you Bob! One quick follow-up question. I can't figure out how to apply what you told me to the clear filter code. When I click the clear filter button I get the following error: "Run time error '3333'. Records in table 'tbl_Quoting Data' would have no record on the...

I have some great VBA code that I used in the past to filter a form. Now I'm trying to apply this code to filter a subform but I have no idea how to modify it (I know pretty much nothing about VBA, I just relpicate what I can find on here and Google). My unbound filter fields/combo boxes are on...

Thanks for you help. I figured out my issue - the fields I was referencing in my query were not checked "Show:". I didn't know that you could not reference a field that wasn't displayed in the actual query. Thanks, Joe

I've been googling this for an hour to no avail. I am creating a simple query and have a field that is a calculation of another field (i.e. DWF: IIf([DWF?]=True,"DWF "," "). How would I reference this calculated field so I can use it in another formula i.e. Lines: [DWF] & [Auto]. When I run the...

This template is perfect, thank you Boyd! Now I just need to dig in and replicate its design.

I’ve designed a basic database that allows users to track progress and correspondence related to their accounts. The users enter their notes in a simple memo field which is attached to a button that adds a date stamp prior to their entries. I’ve read on various forums that there is a better way...

Bob, thank you very much it works perfectly! I appreciate your help.

I have a button labeled "Add Note." When a user clicks the button it creates a date stamp in a related memo field (Me.Text3720). Here is the code: Private Sub AddNote_Click() Me.Text3720 = Me.Text3720 & vbCrLf & vbCrLf & Date & "--" End Sub Is there a way to make the cursor jump to after...