Search results

Cheers for the responses guys. Could I just ask for a little further clarification? I guess that I'd want the results to get returned on the same form that the WebBrowser object is on. Assuming I make the aforementioned browser invisible, would the code to update the unbound textbox fields...

Ah, perfect, thanks HiTechCoach. Now I just need to tinker the an event type to attach this code to. On a related subject, once the browser has navigated to the site, it returns data from the online database as a list of XML fields, for example: <Member>...

Hokay, I've been tinkering with this one for a while, but no luck. Let's say a form has a browser embedded, called WebBrowser0. The OnLoad code for this form is: Private Sub Form_Load() Me!WebBrowser0.Navigate "http://www.mydomain.co.uk/search.asp" End Sub Now the page Search.asp does...

Hmm, but I don't think that will take effect when being run as an MDE. I suspect I may have to go down the encryption path after all...

I certainly agree in principle, Gemma, and my code already locks down all the things you've mentioned, but I want to avoid the problem of the end user running tools like this one.

Good point on the time period, I will mention this to the people I'm writing the database for and advise they consider shortening the trial period. With regards to your solution, I've already writtne code to test for expiry and it runs great, it's the actual trigger bit I don't know how to...

Right, so I'm working on a database project that, on final release, will have a free trial version. When this free trial comes to an end, the database should cease to function. Probably the best way I can think of to do this (although I'm open to other suggestions) is to include some VB code...

Perfect, thanks jal. I can see how your code works, and have now made a few small amendments to suit the setup of my form proper. Thanks again :)

An interesting possible solution, jal. Unfortunately, I add your code into my VB form code (although I'm amending the btnCalc_Click to an AdvisorList_AfterUpdate() event as I want the code to fire when a user clicks a listbox selection, not a button; I'm also amending the MsgBox Scalar(sql) to...

Take a look a the attached database, which is a vastly cut-down version of the project I'm currently working on. I have a form, frmReports. On it, I have a listbox, AdvisorList (containing a list of all those names that appear under UserName in the tblEmployees); two date fields, txtStartDate...

Ah, thanks. I thought that might have been the issue, but as my StartDate, EndDate and the dates logged in the table were all in UK format, I disregarded it as being responsible, assuming - perhaps foolishly - that Access would realise the difference and amend itself accordingly. Ah...

Thanks, stopher for that code, and for your advice on how to combat the General Date to Short Date issue. However, I've run into an odd issue and can't seem to resolve it. Take a look at the attached example, which is a very cut down copy of the database. If you set the dates to 11/12/2008...

I'm not too sure if this is the right way to go about this, but I have a form - frmReports - on which is a list box, showing all the database members. When I click on any member, an AfterUpdate event sends that member's number to a hidden unbound textbox, Number. This is then used in a number...

Thankyou very much for all your help and advice, allan57; thanks to you I now have exactly what I was trying to achieve. :)

Thankyou very much, allan57. I have a couple of queries though. I can convert the returned integer into the text I need using additional If statement that simply identifies the number, then uses it to alter the value of an unbound textbox to give the field name. however, is there a cleaner...

Aahhh, I see how it works. Wasn't familiar enough with queries to know you could fiddle with the Field section. Giving it some thought, it would seem as though I can achieve the same result without queries at all by simply placing multiple unbound textboxes on the form, each with the code...

Sorry, but I'm not familiar enough with Queries to be sure of this. Putting that code anywhere within a query just returns a syntax error. Putting it in a form either does the same, or does nothing. And surely if I were calling a query from a form, the query name should be somewhere in that code?

Embedded where? In the Criteria of a Query? Throwing that into the Control Source of an unbound field just returns a syntax error.

Hmmm...I get the idea, but don't see how I can use it to practically solve my issue. My table has eleven fields, one primary key ID field and one field for each of the ten subjects. The query or code or whatever should be able to count how many ticks appear in each column, not row, then...

I have a table, tblLogs, which - as wella s the ID primary key - is comprised of 10 checkbox fields which represet a Subject. When records are logged into the database, the user can selectively tick or untick any of these Subjects from the form, so that one record (thus one row in the table) may...