Search results

Ok, have taken apart the database and been adapting it for my needs and everything seems to chug along beautifully. However, three minor issues have cropped up that I've been unable to solve. Since these minor issues both exist in the original database as well as my modified version, there's...

Fabulous, thank you. That's exactly what I was hunting for.

Hi everyone, Hokay, so I'm starting work on a brand new project. I've written a lot of databases in the past, although the last one was years ago and I'm a little rusty now. However, the last database made extensive use of VB, so don't have any worries about firing terminology at me! Right...

Update on this. We have managed to contact the programmer, who tells us that this has happened because of standard version checking routines in the database that prevent old versions sitting alongside new versions and causing instability. Apparantly when they were working for us, each new...

I have started working for a company that uses a split Access database (front end / back end). The people who actually work with the database use MDE files, which connect to the back end MDB tables elsewhere. Also in our possession is the MDB source code. Recently, all the users databases...

Quick bump in the hope somebody has an answer on this. The only issue remaining is point 2 in the post above; how to screen scrape data from within an XML tag that includes a CDATA tag? For all the other, non-CDATA, tags, WayneRyan's code works beautifully; I just can't grab the last details I...

CDATE!!! I knew I was missing something! Thanks, Rabbie. Code works exactly as it should now. :)

Already done. Even though txtDate is an unbound textbox that can contain any text string, when dates get parsed into it they check out as proper dates with the IsDate function. What I then want to do is have that date flipped from yyyy/mm/dd format to dd/mm/yyyy format for use elsewhere. The...

I know this one should be simple, but I jsut cannot see it, and a search of the forums doesn't seem to help. I have an unbound textbox, txtDate. For various reasons, this box is - and must remain - in text format, as it doesn't always contain an actual date. Various other codes populate this...

Thanks, WayneRyan for your help so far. I punched your code into VB as a function, setup the calls to a button and now have a situation where I can search the test XML page, then click a separate button to have your code grab the returned data from inside the textbox and pass it to the relevant...

Sorry WayneRyan, but your code produces invalid function and invalid call errors for me, specifically GetTag = Mid(strText, strStart, StrEnd - strStart) is returned as an invalid call or function, and If intStart = 0 Then GetTag = "" Exit Sub End If crashes out with Exit Sub not being...

The attached example will give a better idea of the effect I'm trying to achieve...

Assuming that the database window isn't accessible behind the database, have you tried holding down the Shift key whilst opening the main file? That will open the database, unless whoever built it has specifically written in code to disable Shift.

Thanks ASherbuck, that has worked beautifully. To summerise what I have on the grounds this thread may well help other people with the same issue: I have a WebBrowser object - WebBrowser0 - hidden on the form. I also have two unbound text boxes, txtMemSearch and txtResults (which is...

Have tinkered with this a little now, but not getting especially far, to be honest. If, if I understand it, bResponse is one of the fields I'm wanting to grab data from (such as PostCode), I presumably need to define X bResponse strings, where X is the number of fields I want to get...? I...

You know, Gemma, given the degree to which you've helped me and others, you really should be in line for a medal, you know :) Thanks for the post; it's given me something to start investigating to see if I can get it up and running for my own project. Obviously, if I do, I'll post the results...

*** PLEASE DO NOT REPLY TO THIS THREAD. A THREAD WITH A RELEVANT TITLE HAS BEEN CREATED FOR THIS ISSUE, AND CAN BE FOUND HERE***

Related to this thread. Apologies if this seems like a second post, but the above thread had two issues, the first of which - to which the thread title relates - is solved. I've decided to start a second thread for the latter problem with a more relevant thread title purely so, if a solution...

I've got the exact same situation running on a server at work. The database is split into front end (an MDE) and backend (and MDB). Back end goes into a shared folder on the server, to which all client PCs have access and full rights. Access is NOT installed on the server. Front end goes...

Sorry, I probably wasn't clear. I don't need to search on anything other than the number (which HiTechCoach's code does wonderfully). This all works, and returns an XML page in the format I've outlined above within the WebBrowser object. What I want to do eventually is hide the WebBrowser...