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...

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...

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 = "

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...

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...

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...

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...

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...