Search results

Hmmmm.... That's an interesting thought - I hadn't thought of doing that. I might try giving that a go next time I'm there. Thanks a lot. Andrew

TBH, I can't really answer the questions re their network infrastructure - I've no idea what their setup is (this is a large government body, whose IT is outsourced to a company based in India and who are not particularly responsive, but I can try to find out. I hadn't thought to turn off the...

Hi As per my original posting: So yes, we've tried both options, on two different laptops - one cutting edge, one less so... Andrew

As we're currently only testing, only two people have a copy of the FE, and there's only ever one of them using the system at a time. The BE sits on the server around 3 levels deep in the folder structure. I've also heard that long paths can cause issues, and so this is deeper than I'd like...

I haven't tried taking out the recordsource, and can't test that right now as I'm only in that client's office once a week (the rest of the time I'm either doing development from my own office or with other clients). But the very first screen to appear (the splash screen) does open quickly, and...

Hi all I'm developing a database for a client. It's currently split into an Access front end and Access back end, although the plan is to migrate to a SQL back end next year. To give an idea of scale, the back end contains 40 tables, and is just over 10mb. As you can tell, it doesn't yet...

:) Thanks for the help - of whatever kind! But no - I just used the curly brackets as my way of saying "Actual value goes here..." And the entire string is inside quotes, but as a set of parameter values to be submitted, they don't go in quotes. Anyway, all sorted now! The full working...

You are a star!! Thank you so much - worked like a charm. Unexpectedly, whether I set the filename to signature.png or signature.jpg, it still worked and happily saved a working image file! Can I just ask a followup (probably being lazy now...) - I've seen various references in postings and...

Hi Thanks for the input, but no - my code includes the parameter &image_id=1234 You may need to scroll to the right to see it though! Thanks Andrew

Hi Am I missing something? If you're trying to count how many rows there are that meet your criteria, then you've got two choices... you could use a recordset and a SQL statement based on COUNT(). But from the code you've posted, it looks to me like you're either doing this in the query...

Thanks to all who posted replies to this one - and sorry it's been a while! I've finally been able to do some more testing at that client, and the addition of a few DoEvents statements does seem to have made it a lot more stable! Many thanks again. Andrew

Morning all! I'm working on a database which is designed to connect to an app called Canvas (www dot gocanvas dot com). It's for a client which runs a team of heating engineers. All the information regarding the engineer's job is uploaded to Canvas through their API as an XML file, and the...

Okey-dokey - I've sprinkled a few DoEventses and I'll also log the times with Now() - that's a good thought. I don't think it's just a brain fart, but you never know. About to run another test, so I'll keep you updated! Thanks Andrew

Hi Thanks for the suggestion. The problem I have is that it's never done it on the same line twice. For example, I've just tried now to run this reporting tool, and it's stopped 3 times in total, in a process that lasts about 2 hours. Each time it's been on a different code line - twice...

Hi all I wonder if anyone's experienced this before... I've got a reasonably large database (circa 150 tables, several of which have over 10 million records). This is held in SQL Server 2012, hosted in the cloud (but not SQL Azure). The tables are linked to an Access front end, using SQL...

Hi all, I hope you can help with this - it's been driving me up the wall today, but I've never come across it as a problem before. I have forms set up as follows: frmFrame - this holds a Subform control called ChildForm. ChildForm has as its SourceObject a form called frmTitleOuter...

Hi Thanks for the response. I don't understand why you say that I wouldn't expect to see error numbers. Without error handling, I'd expect to see this: (sorry - won't let me post links or images, so imagine a dialog box with the title "Microsoft Visual Basic", then two lines of content, the...

Hi All I have a problem that's been baffling me all afternoon. The concept is that a customer may place a recurring order, such as 5 items per month every month. In addition, some months they may require additional items I have a form - frmOrdersMain, bound to tblOrderGroups which has a PK...