Search results

Hi Peter OK - I'll take a look at V-tools - thanks for the tip. I already have mz-tools - smart indenter, and the error handler, are excellent! Cheers Les

Does anyone know if there is a good replacement for Speed Ferret? At http://www.databasecreations.com/prod_speedferret.htm I gather that "EFFECTIVE JANUARY 1, 2011 BLACK MOSHANNON SYSTEMS HAS DISCONTINUED THE SPEED FERRET PRODUCT." Pity - it sounded great:(

Hi Peter - nice to hear from you! Thanks for your input. It did occur to me that the sql was consistent with the criteria as I originally entered it, but what seem wrong - and very offputting - is that the design grid view of the query changes to something else after closing/reopening the query...

Hi pr2-eugin I did realise that the sql wasn't pretty, which is why I described the problem quite fully in words - thinking that this would be sufficient to get across what is happening. The actual combinations of criterion are quite complex, which is why the sql is how it is: how can I make it...

Hi All I'm no expert, but I think I've found a bug in access's query builder:confused: I have a query with 4 rows of criteria, with the same value in 3 of the fields (these 4 criterion must be satisfies in every case), and varying values in values on one row only in 4 other fields: so the 3...

Hi AccessBlaster Thanks for your reply - and apologies for the delay in my response (I've been out of the office). Unfortunately me.dirty = false didn't work - the record didn't save! If you have any further ideas I'd be really grateful! Thanks again Les

Hi All I have a form frm_GlobalSettings with a combobox cmbDescription that finds a record based on the value selected. The row source type for cmbDescription is Table/query, and the row source is a select statement on the form's underlying table. I want the user to be able to use...

Hi All We have an access routine that creates and populates an excel workbook, and adds lots of validation - typically: 1220 With objSheet.range("AM9:AM" & lngRowCount - 2).Offset(0, ColOffset).Validation 1230 .Add type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop...

Hi All I have a report that has the query below as its data source. The query runs fine on its own, but when I try to run the report I get: "Multi-level GROUP BY clause is not allowed in a subquery". How can it be that this is allowed when running the query but not when running the report? If...

Rain / 'Doc_Man' Thanks for your further replies: I get a sense of MySQL coming at us like a train, and it's a bit daunting :eek: If I understand the comments about multiple backends correctly, the upshot seems to be that we should definitely NOT DO THIS: is that correct? Our setup is that we...

Hi Thanks for that link. I've had a very good look at all the info there, and there is a lot that will be useful to me, but as far as I can see it doesn't tell me how to open the VBA window at the code of a specified 'VBA document'. It seems to me that there should be something like a...

Paul: Thanks for that link: there's a bit for me to digest there :) Rain: Yep - I know we're heading that way - have been putting it off for ages, but perhaps as you say now's the time :eek: Our frontend is big and complex, so it's not going to be easy. Do you know of any particulaly good...

Hi Both Although there are only 4 'main' tables, there are many others too ;) We do lots of writes/deletes every day, so I do regularly compact/repair the backend - otherwise we'd have been at 2Gb ages ago :( Question: is a 400Mb backend likely to be noticeably quicker to use than a 1.8Gb...

Hi All I have written a procedure into my error handling that writes all the error details to a table, so that I can audit/fix the errors that occur. I have a form frmErrors that displays the unfixed errors in continuous form view, with a button in the detail section that uses DoCmd.OpenModule...

Hi All We have a split A2010 accdb, and the backend is now 1.8Gb so I need to do something :eek: If I put each of the 4 main tables in 4 separate backend accdbs, will the fact that the frontend then needs to link to 4 accdbs in some way impact on performance? Another possibility (given that...

Hi Wayne Thanks for coming in on this: and from my very quick look at the link you gave I'm confident that this is the solution to the problem :D I won't be able to implement this until later this week, but will post back to confirm that all is well (or that I'm struggling ;)) Thanks again Les

Hi Dave You are absolutely right: the problem was that you were making suggestions that I needed to reply to. Each time I believed that I could get my point across, and that you - or someone - might come up with a solution! In retrospect, as you say, perhaps I should have simply done the job...

Hi Dave I know about Chr(13) & Chr(10) and about vbcrlf. The problem is not about how I can include 'new lines' in a Find and in a Replace - not about how I can create new lines in a MsgBox, or in an Append, or in an .Update !! I'm sorry that I hadn't made this clear :( Les

Hi I haven't actually written WriteErrors() yet :o, but it will be pretty trivial. It will not have a vbCrLf part - just a .Add .... .Update on a DAO.Recordset. I know that I could insert the code itself (as opposed to the new function) to the error handling, but I think it would be neater to...

Hi David Thanks for your further reply: but I've obviously not explained what I'm trying to do adequately :mad: I don't want to change the MsgBox (I can't see what difference it would make - the message itself linewraps just as I want it already) I won't be using an append query to log the...