Search results

Hello All, Is there a way to retrieve the very last entry to a table (via a query) without passing a value to the query. Lets say I have a table Pets ID desc ============== 1 Dog 2 Cat 3 Lizard For example lizard was added last, is...

Hi, The user preeses a button: Private Sub cmdPreviewTodaysActions_Click() On Error GoTo Err_cmdPreviewTodaysActions_Click Dim stDocName As String stDocName = "ShiftWorked Query" DoCmd.OpenReport stDocName, acPreview Exit_cmdPreviewTodaysActions_Click: Exit Sub...

The variable is one that I have created in code it is a string variable. What happens is that a button is pressed to display a report. The report is based on a query that receives one parameter that is unknown to the user. So... there is an inputbox that pops up, I would like to avoid this...

Hi All, I have created a query that I want to run from a form (thus far no problem). Where I do have a problem is that I want to take the contents of a variable and use it in the query. I don't want the input box asking for the value. I hope that I have made myself clear. Cheers, Aaron

Hi all, I am basically trying to concatinate a currency symbol to the value of a textbox BEFORE it is saved and I am being hit with the "Run-time error '2115'" Here is the code: Private Sub amount_BeforeUpdate(Cancel As Integer) Select Case strCurrency Case "CAD Dollar"...