Search results

Thanks for such a swift reply Bob I have made change and will test - it takes a while to run through. Just out of curiosity why use the one not the other? I presume less "thinking" needed by vba or is it just I learned an older device that has worked ok on less demanding processing? Best wishes

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...

OK I have resolved the issue by deleting the original tblSixWeekChecks, closing and restarting Access, and then re-creating the table. This has put Absolute Position to 0 and it works What a bugler! If anyone reading this understands what happened I would still love to know Thanks for your help...

Might be on to something but it doesn't mean to me. When I look in the locals window whilst stepping in once I set rstAudit if I expand the rstAudit part is shows absolute position as 0 but when I step over to rstSwc and do the same then the absolute position shows as <Opertion is not supported...

Have tried suggestions from both Ken and Gemma (had already thought of and tried Ken's off my own back) Neither work. SOmething really wierd is going on here. I have commented out as much as I can but will see if there is anything more I can comment out in case it is upsetting it Thanks for the...

Have just run the rst.findfirst code sequence in another database and it works OK so it isn't my Access configuration. It also has DAO 3.6 referenced. Hmm ....

Yes, FindFirst comes up quite happily in the list of options. Am going to try another db where I use this and I KNOW it was working just in case there is a gremlin developed in my Access configuration

rstSwc.FindFirst "[lngSwc] =" & Me.txtSwc

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...

Just punting a guess here but it sounds like a permissions issue. The database has to be in a shared folder - does the user on Dell laptop you are having issues with permissions to the shared folder. I am not too up on Vista but it sounds a possible scenario. There may also be some issues with...

Thanks Shades I got the text wrap OK with a bit of Googling and experimentation. Might experiment with the macro idea - never actually done on in Excel - and not in Access for the last five years!!!

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...

Thanks davea300 Not quite what I had in mind but the principle is the same, and yes it would achieve the objective. Yours is a nice one where people populate from a report but I generally use a form, so effectively the same process. I worry slightly that storing this data seperately it will...

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...

Brilliant as ever. Thanks guys for the help. I can now see immediately where my logic went down the pan. Just breaking it out into more steps makes it easier to follow. Ok it possibly make the programme one milli-milli second longer to run but heck, it works! Thank you

Hi I must be needing a break already! I cannot see a quick way to do this and all my attempts have failed. I have a textbox on a data entry form that can only be accepted if it meets one of three conditions: It is null It says "Yes" (or "yes") It says "No" (or "no") I can get around the...

Hi Ken Sorry. Been away playing in the hills with my Defender 90 for the weekend! The error procedure is as shown in post 3 which to my untutored eye looks like it has the resume statement in it but all may not be what it seems. Best wishes

You need to run a seperate query to identify which suppliers had shifts worked. A sort of clunky way (but always works quickly) is to make a temporary table (tblTmpShiftSuppliers) with supplier ID as a primary index; run a query identifying all shifts worked in the period; append the supplier...

Thanks Ken That gives me an error code of 3078 but again as soon as I click on the <OK> button on that error message I am back in the "Object variable or with block variable not set" loop. Somehow I need it to be a bit more graceful if a table name is mis-spelt, at least during my development...

Err Nope. Have not usually found too great a need for one but perhaps I have been lucky so far! What I do have is the basic Err_cmdChLCancel_Click: MsgBox Err.Description Resume Exit_cmdChLCancel_Click Confess I would not be sure how to start but more than willing to learn if you could...