Recent content by matt beamish

I've tried this way, but Form3 is not picking up the value/navigating Private Sub Command17_Click() On Error GoTo Err_Command17_Click Dim stDocName As String Dim srid As String Dim sprid As String stDocName = "F_SampleFractionRecordsAcc" sprid = Me!SampPtRecIDcntrl...

the Form is opened by some users to find the set of records they want by running a wild card search and then using the resulting records in the cbo to find the ones they want. There are a number of forms that are then synchronised using various controls and oncurrent events. Most of my forms are...

Thanks. I've found the method below does now open Form2 and populate the control, so progress. But I'm not getting the subform (form3) to navigate to the value of sprid successfully. Private Sub Command17_Click() On Error GoTo Err_Command17_Click Dim stDocName As String Dim srid As...

Hello folks. I've been battling with this and can't see what I am doing wrong. I am trying to open form2 from form1. Form2 is not bound but has an unbound search that allows users to open it from a menu and find the records they need. I want to open Form2 and pass a text value from Form1 to the...

Yes I can see this would help - thanks

Thank you very much everyone for your speedy and helpful responses - the line above is the solution. Context is an integer although it's use is only as an identifier - but as far as storage and formating go, it as a long integer. Sometimes I format it as text and use it as such. Re Chr(34) and...

Hello forum people. Please can someone help me with a Dlookup - I've spent a few hours on it now, and I am going around in circles. My criteria are [FullAccession] which is a string, and [Context] which is an integer. This works: =DLookUp("[Title]","[Q_DiggitContexts]","[ContextInt] =...

Thanks for this which is very light weight and does just what I need to do - and you've written it into a query for me so I can adapt to all the appends I need to do which is appreciated. There are multiple tables that I have coming from field recording devices where the data is getting...

I now have this running successfully. Thanks for help Moke123 and everyone else for quickly chipping in. Good to know that the Forum is still here and that all you helpful people are there to help.

I've just read that DAO (which I did used to need years ago) is effectively replaced with MIcrosoft Office 16.0 Access.....which is loaded on my machine

Might this be a reference library issue - perhaps I need DAO3.6?

When running from Immediates, I'm getting this compile error:

Here is some of my data as a text file - thanks for help

Thanks for replies. I'm sort of confident about just getting the numbers out somehow, it is more how to get the results into just one column, and so how I get split() to loop. From I get but I need single values in the context column and the 'number' column repeated for as many instances...

Hi all, long time no see from me as my job changed a bit, and I'm not doing anything near the amount of VBA I used to do. So apologies, but I am just a bit rusty and would appreciate a hand. I need to split a field that is consistently delimited by commas, and contains numeric strings between...