Recent content by aervin5

Does anyone know if there is a function in Access similar to the "Solver" function in Excel? I need to vary a calculation input until the calculation matches another number. Can anyone help me with this? Thanks!

Thanks Thanks a lot for your help! I'll try that.

I'm trying to delete all but the last record in a table. This is what I have so far: Dim x As Long Dim y As Long Dim z As Object stDocName = "Open Input Table" DoCmd.RunMacro stDocName DoCmd.GoToRecord , , acLast z = Tables("Data Input Table")...

Hi everyone, In my code, I am able to set a variable equal to a form, but not a table. For example: dim z as object set z = Forms("My Form") However, I cannot set a variable equal to a table.... set z = Tables("My Table") does not work Does anyone have any advice? Thanks!

Hi everyone, I'm wondering how to enter code that says, "Delete all the rows in a table except the last one". Does anyone know how to do this? I was thinking something along the lines of: Do Until CurrentRecord Is Last ... Loop -with the "..." representing a simple deletion macro I built...

Does anybody know if there is a function in Access like the "Indirect" function in Excel? I am linking 2 tables, and I need to pull back the column in one of these tables that is named the same as the values of a column in another table. Thanks! Andy

Thanks Thanks a lot!

Does anyone know the expression for putting a date in the format "MMDDYY" without any /'s? In Excel, this can be accomplished with Month() & Day() & Year(). Thanks! Andy

Thanks! Thanks everyone!

Does anyone know how to suppress alerts in Access? I know the code in Excel is: Application.Displayalerts = False However, this does not work in Access. Thanks!

Does anyone know how to suppress alerts in Access? I know the code in Excel is: Application.Displayalerts = False But this does not work in Access. Thanks!