Search results

Hi all, I have a slight wrinkle on the "disappearing form" problems I've seen in the forum. I've written a form for the user to enter partial entries of data to match a single record in the database (which is effectively only a single table anyway). The finding the record part works fine...

Hi there I've written a fairly basic outlook automation function to create an email containing the text of a textbox to a contact (held in another table). Intermitently (i.e. when my boos came over for a demonstration) I get errors on the line : With out.CreateItem(olMailItem) telling me...

Hi there I'm running Access 2000 on Win ME. Until about an hour ago everything in life was wonderful (okay so that's a bit fanciful too), but now when I open my be_db the AutoExec macro which loads frmSplash kills Access. I get an exclamation message: " Msaccess has caused an error in...

Hi there I've split my db into a front-end and back-end. I've password protected the backend and am using some forms locally (for maintanence etc) but would like to use some of the forms that exist with the front end (in order to generate queries etc). 1 ) Is this possible? 2) Can anyone...

Hi there Ok so the obvious way to search on a term in freefrom text records might look something _like_: SELECT fldDate, fldQuestion, fldAnswer FROM tblQuestion WHERE fldQuestion LIKE '*[txtKeyword.text]*' But what exactly does that return, if I search for the term 'AT' I'll also get 'cat'...

Hi there I'm creating a database to track information about components bought by the engineering company I work for. These requirements are generally sent out as excel spreadsheets, completed and then returned. I've written a db which can read the responses in and process with queries in what...

Hi all, I would be grateful if anyone could enlighten me. The database I'm writing is to hold information on the technical specifications on components of products used by the engineering company I work for. There is one table per specification document, and one table linked by a one-to-many...