Search results

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

Does this include forms where multiple tables and possibly multiple records per table are affected?

Yes. This is exactly the result needed. Will modifying the relationship to cascade delete cause the application to perform differently for non-delete transactions too? This is an existing application and I want to make sure that changing the relationship will not affect any other existing...

This is correct. But, the record in table1 which matches the form value should be deleted as well. Basically, I want to delete the child record for table 1 before deleting table1. I hope this helps to clarify the issue and thanks for responding.

Currently using VBA for Ms Access 2007. The current issue I want help with is the basic syntax, objects and/or methods required to do the following: Read a specific table (say table1) from project where form num equals num found in table1 Then If the reg_number field from table1 = reg_number...

Here is my current code: Dim tmpNumber As String Dim tmpAddlTableRecords As String Dim strSQL As String tmpNumber = Me.NUMBER If tmpNumber = Me.NUMBER Then Dim tmpReg_Num As Long <The same error if datatype is 'String'> tmpAddlTableRecords = "SELECT * FROM Table WHERE Table.NUMBER =...