Search results

This is the data from your Excel file. Send us an example of what you expect to see. RowPartNumberNOTEGrade AA01READYa AA02NOT Readya AA03NOT Readya AA01NOT Readyc AA02READYc AA03READYc AA03READYb...

I get the same error as Gasman

Hi Is the attached screenshot what you are after?

You have a table named "nn" with no PK but lists all of the values you need to concatenate. Which Form has the Combobox where you want to select a "Section" ??

Hi The following works but it is very rough.

OK

Can you upload the Db

Sorry but all you have done is put my suggested line of code in the onclick event of SaveSalaryBtn What 1 wanted was a screenshot of the Macro that is on the Recalculate Taxes Button.

Can you post a screenshot of the Code you have on the On Click event of the Recalculate Taxes Button.

I would convert the Forms Macro to Visual Basic Then enter the following as the last line:- [Forms]![frmPayroll]![frmCDPayrollrecommSub].[Form].Requery

Sounds like you need to requery the Form

Hi June With my limited knowledge of VBA is the modified Module enclosed correct? Function ReturnData(lngMaritalStatus As Variant, dblBasicSalary As Variant, dblLower As Variant, dblExemptionCredit As Variant, dblAmountfromColumnA As Variant) As Double If Len("" & lngMaritalStatus) = 0 Or...

I get the same outcome as Gasman

Hi Alex Can you upload a copy of your current Excel file so we can see what your current requirements are?

Not having worked with Sharepoint I have no idea.

Hi Sorry to say but just fixing that 1 issue would not fix all of the problems in your database. You have spaces in names, you are using Lookup fields in tables as well as hard coded Lookup lists. Upload your fixed database and let us point you in the right direction.

Hi Your main problem is that your tblCandidates has a PK set as a Number Data Type when it should be an Autonumber. Your Main Form CandidateDetails is based on both the Candidates and Submissions table. The Main Form should be based only on tblCandidates. In your current Subform based on...

Hi Tested the file after downloading and it does not work. You need to recreate the Form as it must be corrupted.

Can you upload a zipped copy of he database?

Can you upload a copy of what you have created so far?