Search results

Ok, this really should be the simplist job of all but my I'm having a mental block and simply cannot get my code to work. I have a master table, TblFileData, that contains all records. The salient columns in this are fldCode and fldName, fldType and fldDepartment I have a listbox on a form...

Hi All, I'm not sure if this can be done or not, but I have a database project that includes - via VB - some file manipulation in the background. This all works perfectly, but there is a problem if the file to be manipulated is currently open by a user other than the one trying to make the...

Hi All, Ok, I'm hoping this is fairly straightforward, but I've been hunting around online and going throguh the inbuilt help files in Access 2003 for about an hour now but simply can't find the answer. Ok, I have a folder on my PC that contains a set of files whose names all begin with a 5...

Hi All, Ok, simple layout. I have a form with a unbound textbox on it called txtData. This has a control source of the field fldData in the table tblData. This field in the table contains alphanumeric data. All nice and simple so far. Now the textbox is set to be unenabled when the form is...

Hi All, I've been struggling with this for a few hours now and can't seem to get it to work. I'll use a simplified example, but the actual requirements are exactly the same: Ok, I have a table called tblData. This contains three fields; ID (the primary key), Code, and Name. Now I also have...

Hi all, I have a small search engine written in VB with Access forms. The engine works perfectly and produces a list of all files (filtered by dropdown boxes on the form) in a particular folder. Now what I want to do is have a series of three separate text boxes - unbound - on the main form...

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

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

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

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

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

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

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

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

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

Ok, this is really just a general query more than anything, but I've been unable to find the answer either here on on the internet in general. I have a secured database. BE is password protected and all objects are hidden. FE is MDE, all objects hidden, shift disabled, special keys disabled...

Right, this is the classic programmer's paradox. Day one, project compiles into an MDE without complaint. Day two, same project refuses to do so. I have an ongoing project that I'm writing for work. Various features/functions are being tweaked all the time, and everyso often I produce...

Right, so I have a perfectly functioning database that works beautifully and is fully controlled. It runs on modal popups, and a variety of techniques have been used to prevent the users from ever getting to - or even seeing - Access behind. I have now had a request from work to add the three...

Just a quick one. I have a split database written in Access 2003 with a ton of VB code running most of the features. The whole database works beautifully. One feature of the database is that when started, Access itself is minimized and the first form (a modal popup) appears on the user's...

Hi all, Hokay, I've been toying with this one for a while now, but would greatly appreciate people's advice. To keep it simple, say I have a form, frmDetails. On this form is an unbound text box, Notes, and a Listbox, ListBox, which is based on a query. The query calls all records in a...