Recent content by psimpson

I must concatenate the cell location from other data. Once I have the correct cell location, I want to use it in a sum function, but my function adds to the cell location instead of the contents. For example, D1, plus 20 becomes D21. Instead, I want 50, plus 20 to equate to 70.

Hello. I want to work with the value that a cell address located in a cell corresponds to; and I want to use it in a calculation (=sum(x+y)). Is there a way to convert the cell (say D3) to its value (say 50) and add it to get an aggregate number? Any help is appreciated. Thanks.

Well, here is my pseudocode: enter coabbr, coseq# if coabbr previously entered then find coabbr with max aggregate_coseq# value add new coseq# cell value to it return aggregate_coseq# else aggregate_coseq# = new coabbr and set initial coseq# value in aggregate_coseq# field endif...

Hello! I am wanting to set-up a macro or code an "if statement" in MS Excel 365 that will allow me to find whether a company has previously made a request, if so to identify today's current aggregate total and add the new entry's total to it to arrive at a new aggregate total. Can someone...

Hello. I am using MS Access 365 using VBA. However, I continuously get the above cursor error message shortly after opening the customized software. Has anyone else come across this issue? Any help is appreciated. Thank you.

Thanks to all who helped. Your feedback has been very helpful.

Basically, there is a form which contains data from multiple tables. When a record is to be deleted, any associated records are to be deleted too. So, for a particular registration number in the master table, if there is a professional related to it, the professional record should be deleted...

JDRAW - The beginning of the code looks like: Dim db As DAO.Database Dim db1 As DAO.Database Dim rst As DAO.Recordset Dim rst1 As DAO.Recordset Dim strSQL As String Dim strSQL1 As String Set db = CurrentDb() strSQL = "SELECT * FROM table1 WHERE table1.Project_Number='" & Me.PROJECT_NUMBER &...

VilaRestal rst references a recordset. Each of the suggested options where tried, but still gets the same error message on that same line. Do you have any other suggestions, which I might try?

I get a 'No Current Record' MS Access error message on the first line of code below: If rst("PROFESSIONAL_REG_NUMBER") > 0 Then Set db1 = CurrentDb() strSQL1 = "SELECT * FROM Table2 WHERE Professional_REG_Number = " & rst("PROFESSIONAL_REG_NUMBER") 'Set db1 = CurrentDb() Set...

That worked. Yes, Option Explicit is being used. Thanks.

The above error message is returned when the following code is executed: If rst(PROFESSIONAL_REG_NUMBER) > 0 Then The table does list this field as number and the label from the form uses text. Is there a way to convert this field without changing the form? I am not certain the number of...

Actually Paul's solution worked best for my needs and all responses appreciated. Thanks.

That worked. Thanks so much to all who responded.

The code below is placed in a button control in ms access 2007 (using vba), however the above error message is returned at the set rst = db.openrecordset(strSQL, OpenSynaset) line. I am struggling with this for some time, but no solution yet. Any help is appreciated. Thanks. Dim db As...