Search results

Thank you all very much indeed

Thank you just had to add underscore NC_Number (forgot about space.) works like a charm cheers

Help if possible please probably will seem basic to most. I have a form with a command button programmed to open a folder on my network. this folder contains a folder for each record where I store files relating to a given record. This button works fine opens explorer and displays all my sub...

Thank you all for your input much appreciated took a while but with your help above sorted problem thanks again all and stay safe ;)

Thank you and my apologies for the cross post I am now aware and shall follow etiquette going forward

copy of database

Thanks for your patience Hi no joy I am afraid this is the full code for that command button, The line in bold text gets highlighted in yellow? Private Sub Btn_Generate_Click() Dim i As Integer Dim RS As Recordset 'Check the form has been filled in correctly 'Check...

Run time error 3346 Number of query values and destination fields are not the same Both Query and Field in table are spelt correctly

I have a TEMP table and added field called Barcode, I have a command button which produces a report however when ever I press it I get the following error? What do I need to add to get it to read this field please DoCmd.RunSQL "INSERT INTO temp VALUES('" & Me.Address & "','" & i & "','" &...

Thank you both terrific help and yes Steve it was the sum total of records I was after Nice place this thanks again

Hi All Novice in access 2007. I have a welcome form with various options. On this form I would like a textbox visible showing the current total value of a number of records. I have these records in a query and able to total them but i would like this total value displayed on welcome form for...