Search results

DoCmd.RunCommand acCmdUndo Me.Undo

Try separating them with ; instead of ,

Where is this 'reference number'. Say this was on your Main Form, the other two Forms could be based on a Query that uses the Main Form Criteria. If not the quickest way is to just create two Queries and have separate criterias.

Initially to open the Excel file Private Sub cmdOpenExcel_Click() Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Set xlApp = New Excel.Application With xlApp .Visible = True Set xlWB = .Workbooks.Open("C:\path\xlfilename.xls", , False) End...

Thanks @StarGrabber, it was late and I was on my phone so I should have been more careful

You could use a DLOOKUP http://599cd.com/tips/access/dlookup-function/?key=AlexForumAF =DLOOKUP (Field, Domain, Criteria) e.g. =DLOOKUP ("LastName", "CustomerT", "CustomerID=5") Or =DLOOKUP ("Address", "CustomerT", "CustomerID=" & CustomerCombo) Just set the source/default value of your...

Sub FilterTo2Fields() With Sheet1 .AutoFilterMode = False With .Range("A1:D1") .AutoFilter .AutoFilter Field:=1, Criteria1:="Dave" .AutoFilter Field:=4, Criteria1:="Lab" End With End...

Do you know the first cell of each range of data? You could set the range for the chart using VBA. Range("W6").CurrentRegion.Select

Private Sub btnCopyFile_Click() Dim myFilePath 'original file Dim myFolder ' destination folder myFolder = "C:\Folder_B\" Set FSO = CreateObject("Scripting.FilesystemObject") dim fileName fileName.GetFileName(Me.txtOriginalFile) myFilePath = myFolder & Me.txtMyPK & "_" & fileName If...

Are you wanting to create a new Excel file? Will this be the same existing file or do you wish to choose a different file each time. Will it always be the same cells in the Excel file?

Is there a reason why you can't just create an invoice template yourself and just email that to your customer? You could create a Report in Access then set up an email routine for that specific order. http://www.599cd.com/tips/access/130511-email-report/?key=AlexForumAF

You could either set your Form to have a Record Source based on a Table and then have a list of records with a button to open the specified Record DoCmd.OpenForm "frmName", , , "ID=" & Forms!frmName2!IDControl Or use a parameter Query and base it on a value from the Form...

Of the example which of the below we're sent? Did you have a loop that input each of these separately? Running all of the above code for each.

You could place the code in the Form's OnLoad event instead of a button.

You could create your own function and use =Environ("username") To get the currently logged in Windows user.

If you import the form into another blank new database does it act strangely there too?

You could create a Query instead. Save this and open that instead of your Table. It's best to work with Queries instead of Tables if you want do filters etc. Sometimes the filtering on a Table doesn't persist. Create a new Query, add your Filter, in the Ribbon in the Sort & Filter Section...

Is the name of your Table/Query "MHBTimeSO"? When that error appears and you press Debug, which line is highlighted in yellow in the vba window? As Alansidman suggested did you try: Call SendTQ2Excel("MHBTimeSO")

The function starts like Public Function SendTQ2Excel(MHBTimeSO As String, Optional HBTime As String) ... The values between the brackets ( ) are arguments: MHBTimeSO As String Optional HBTime As String The error messages is saying: Compile Error: Argument not optional message Because you...

Are you storing your values in a Field with the Data Type of Date/Time? You could use some time functions: let mytime be the Field name Example mytime = 02:07:30 Hour(mytime) = 2 Minute(mytime) = 7 second(mytime) = 30 Now since you are wanting to round on half hours we only need to change...