Search results

I have a string which is a combination of numbers and letters. I want to extract the end digit (always a number), or, if it is greater than 9, then the two digits. The format of the string is along the lines 18G003-2-4 (they are agar plate codes for refining fungal cultures). So I am trying to...

Hi Hope someone can help since this feels a disaster. I rebuilt my main PC as Windows 8 Pro yesterday following getting caught out by a suspected rootkit that must have sneaked in over weekend. Ended up doing full format of the disc and virgin install which got rid of problem. Everything went...

I need to be able to apply various specialisation criteria to a volunteer record. There are currently about 50 possible options but list will expand. Already have separated this particular aspect into tblVol, tblSpec and tblVolSpec so data is normalised. I thought of continuous sub-form based on...

I am trying to set up flexible dynamic search facility. User can enter one of four search fields (name, phone, email, postcode). I am catching the query using a criteria like [Forms]![frmContactMatch]![txtPostcode] This works fine for perfect matches but client now wants to be able to search...

Another wee glitch. I am trying to edit a DAO recordset that is correctly Dimmed and Set but when I try to run it then it falls over. Dim rstEc As DAO.Recordset Dim rstAct As DAO.Recordset ' Define constants Const CR = vbCrLf & vbCrLf Const QUOTE = """" ' Set the connection...

Hi. I am at the tearing hair out stage. I had set up email confirmation from a form and it was going fine. Initially used a PDF attachment but that contact person left and now the new person wants the confirmation incorporated into the body of the email (not a bad judgement) but they also want...

Hi I have one that is doing my head in. I need to test that a Job Number has not been used before. If it has there is a very slight chance they might want to re-use it. The relevant bit of my code (in the BeforeUpdate event) is [CODE]' Verify if job number has already been used varJob =...

Using ACC2007 and calling Excell 2007 I ran this module without issue last night but today it is throwing me a compile error as "object library feature not supported" with oSheet highlighted. The line causing the problem is Set oSheet = xlwkb.Sheets("qryGMExport") oSheet is dimmed as...

I am trying to add some funtionality to a charity's database that I had nothing previously to do with. It was developed in ACC2003 and I am working with ACC2007 but still as an .mdb file Mostly I have managed to do what I need but on this one I get an "Operation is not supported for this type...

I am having to try and understand a vb.net app following the sudden departure of a clients developer. Most of it I can (sort of) follow but I need to find out how I can get to see what is going on in the class modules. Almost everything happens in one vb form and there are numerous examples of...

I need to explore a secured db for a new client where previous arrangement had gone sour. They have password for the main db and this gets me in. If I do not hold down the shift key then I get a form that says db is locked but holding shift key gives me full access to the db. I am exploring...

I am having recurring issues where I am working on ACC2007 on my development system and then installing sometimes onto ACC2007 and other times onto ACC2003 (perhaps more relevantly Office 2003 or Office 2007) depending upon what the client has. Most of the time this is OK but if my VBA reaches...

Hi. I am having to make changes to an older db and decided to upgrade from ADO to DAO whilst I was at it (it made sense at the time). I am building a summary table to run a series of forms and reports. I know it is not the best way but it has worked. I append the employees to the table then run...

Apologies if this is not clear. I have set up report output to Word since formatting options are better but client now needs a new part added where instead of there simply being one entry to go to bookmark there is in effect a continuous report section which may have zero to perhaps 10 entries...

Hi. Got a wierd one here. I am using ACC2007 but with an ACC2003 db format. Have set up a check to see if a project is already listed varProj = DLookup("[lngPr]", "tblProjects", "[lngPrEntity] = " & Me!txtEn & " And [lngPrType] =" & Me.cboProjType & " And [lngPrYear] = " & Me.cboYear) I can...

I am having fun! An insurance premium refund has to be calculated based on rates and number of days etc. The maths gives this a value of (for instance) 9.0083. This shows up in txtPremium as 9.01 which is OK. You then enter the amount of the refund (txtRefund) given as 9.01 and process the...

I am having an issue with major processing in recordset of around 1500 records. I start the loop with While Not rstAprProp.EOF and I end the loop, many lines of code later with ' Move to next record rstAprProp.MoveNext ' Repeat the cycle Wend Every single record except the last...

Hope someone can help as driving me bonkers. I am recycling some text which works elsewhere but is throwing an error here. DAO 3.6 Objects Library is referenced. I have put more code in than usual in case anyone spots anything odd Dim stDocName As String Dim stLinkCriteria As String...

Hi Guys I am getting is a muddle here. I have got two columns where I want a £, a thousands comma and no decimal places, and other columns where I want similar but with the pence shown. The code I am using in Access is ' Set the cell format for Column F & G oSheet.Columns("F:G").NumberFormat...

I have a dilemma. I need my app to print out legally binding property schedules for insurance purposes. A property can have any number of schedules created during a year according to how many changes are made. My instinct is to use a set of nested queries to generate the reports and then save...