Recent content by joebater

No. Closing forms is only done in the event handler on the button. These are not called anywhere else. blue skies j.

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 Travis Thanks for your response. The changes certainly make the whole thing work faster which surely means that the problems are resolved. But.... (there's always one!) I don't understand what the difference means. Is there another thread or explanation I can look through? thanks for...

Hi Hayley I did indeed download your sample, like Sambo I am extremely interested to learn about the user limitations that you've put into your design. Can I try your patience by asking about "the tools menu"? I don't see what you're referring to and am hoping that in asking I'll only be a...

Not wishing to sound too stupid but... What happens when the legitimate recipient of your mail simply forwards it on (aren't the eventual recipients going to eventually be able to follow the path? or is it that once it's left your domain...). Ultimately would the stringency of your security be...

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

Rich, Perhaps stylistically it is a bit redundant, but I don't think it's the heart of the issue. The textbox is filled with the selected value from the combo box despite crashing (according to the debugger) at the line which sets the .text value... Still mystified! blue skies j.

Hi Thanks for your answers! I'm not able to check right now as the AutoExec macro which brought up the Splash form is currently killing the database and windows! (considering all it is does is DoCmd.OpenForm "frmSplash", I'm quite impressed!!!) Once that's sorted I'll give it a try - one...

Hi all, This isn't an answer I'm afraid - I'm having very similar problems! I have a form with a combo box and a text box. I would like the value selected from the combo box to be written to the test box. I have code: Dim strComboValue as String 'form module variable Private Sub...

Hi Fizzio Thanks for your comments - sorry but I don't really understand that well. The db that I have is to hold information about components purchased by the engineering company I work for. They issue a series of requirements documents (subject to quarterly revision, addition and removal)...

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 glynch let me try to understand your solution at a higher conceptual level. you've opened a recordset and have nested do loops, firstly iterating through the recordset, then within each record examining that record using an instr function to get the capital letter (obtained from...

Hi Jeff Yes, it's actually quite easy. Consider the following code: Option Compare Database Option Explicit 'initially start with the second combo box invisible Private Sub Form_Load() Combo2.Visible = False End Sub 'the first combo box is probably designed using the combo box 'wizard...

Hi Glyph (and other readers) Please allow me to give some context which will illuminate my problem (which is probably just ignorance on my part). I have a form (largely based on two tables) which has RFI's that have been sent to the companies regarding components that the engineering company I...