Recent content by DBL

That's a great starting point, thank you. Yes, the number is always at the start /left of the first space.

Morning - I hope you are all well. Not getting as much of a chance to develop in Access any more and a bit rusty. I use a browse function to let us capture a file name and location and save it into a table. The name is made up of two parts, the job number, and the file name. Any spaces...

That's great, I'll give it a try. The file is an externally created document that is prenamed at source that we log in our database and we need to remove the ID number from the document name purely so we can do a dlookup to check that the document hasn't already been send to us, with a different...

The job number is part of the name of a file so can't be split into two different fields.

Hiya. I run duplicate check on a form to make sure the file name doesn't match one that's previously been entered. Currently I have: If Me.NewRecord Then If Not IsNull(DLookup("File", "tblFileProcessing", "[File]=""" _ & Me![File] & """" & " and...

Morning. I'm looking for an Access developer in the Lothians area of Scotland to take over and manage 4 databases that I' have developed and managed over the past five years. Unfortunately a change in work committments means I am no longer in a position maintain these database for external...

Just wondered if anyone had any suggestions. I have a subform with a drop down list of requirements. Every client needs to have a response against all the requirement options but I don't want to hard code the requirements into a table and form as the options will change or be added to. So...

Sorry, just the way I've presented it here. It should have read: Sliced portions of brain: Frontal, Parietal, Temporal, Occipital, Cerebellum, Basal Ganglia, Thalamus; Organ Sample: Pituitary. The data is split into different tables as you've suggested, I'm just concatinating it for...

I even re-wrote is as DAO and I'm getting better results although this still isn't right as it's looping through infinitely! Dim stDocName As String Dim strdata As String Dim db As DAO.Database Dim rs1 As DAO.Recordset Dim rs As DAO.Recordset Dim Answer As String Set db = CurrentDb() Set rs =...

I posted a bit about this earlier in the week but didn't get any responses. I don't think my explanation of the problem was very good! Here's another go which I hope might be clearer: I have a database that records samples received into a lab. This includes the sample type and the...

Background: I have a form that logs multiple rows of data for each case: Material Option, Material Type and Area for reporting purposes I use this code to loop through the records and create a string so that the information can be output as a mail merge bookmark to a Word document template...

Doh! Thank you so much.

I'm trying to add in an order when I create a dynamic query. This is the code I currently use which creates the dynamic query: Set QD = db.CreateQueryDef("qryFrmSelectAreas_Dynamic", _ "Select * from tblLookupAreas") I'm trying to add in a sort by changing this...

this seems to be a known issue with 2010 http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/977d6056-fa92-4c08-a3fb-9cffbd4ce12f Very helpfully they say they are working on it but don't know if or when a fix will be available!

Re: Old Cod Thanks, I'll make that change. yes, it's the Microsoft ActiveX Data Objects that I'm having to reference. If I'm working on Access 2010 but the client is using 2003 then the reference isn't working for them and I have to reset it to an older version. Is there any way to late bind...