Search results

as a footnote the code posted was actually incomplete as I had messed about with it so much and delete lines before giving up !

Hi John thanks for the reply - you seem to be my Guru today !! I'm grateful :) I'm at the point now of 1, smoking again ! and 2 asking for someone to write the code for me so I can move on with the dB. I really don't like asking for code to be written as I prefer to try and work it out with...

I have tried all day to sort this out myself and learn something but my lack of knowledge and understanding has finally won over hence this post !! So... (please note 'Form1' is a test form the actual message in the code below is from the control I want to use the code on - when it works!) I...

Many thanks David for the reply On the basis I'm very new to this could you tell me where I would actually put this code and how would I ensure 'my text' was in it? Thanks again Paul

Hi sorry to post on this again but just wanted to check something. I have got the email bit to work but when a value triggers it I get a pop up in access saying a program is trying to send an email message on your behalf...... and asking if I want to 'Allow' or 'Deny' it. is there any way of...

hi guys could someone tell me if it possible to BOLD "NewData" in VB? the following is part of a msgbox & vbCrLf & vbCrLf & Chr(34) & NewData & Chr(34) & vbCrLf & vbCrLf & _ what I want is for the newdata to be be BOLD in the msgbox when it appears - is this poossible? if so how !! many thanks

Thanks for the offer - I have just done it in code and its working fine now !

thanks for the reply.. i do actually have the same buttons on the details form (and both do work) but they were put on it as a test the reasoning behind the pop up is to try and "force" the user to select something rather than clicking somewhere else on the form. I suppose I am trying to ensure...

Hi Guys, I have a form "details" with various personal fields the last one being EmailAddress. when this field loses the focus i have a macro that opens a popup form "choices". this form has two buttons on it "Save and Exit Form" and "Add New Record" The add new record button works perfectly...

thanks john - much appriciated

Thats great many thanks for the reply and advice John Paul

many thanks for the replies John, The second lot of code i posted does seem to sort of work i.e Form1 opens but the TreatmentForm remains open in the background (Im working on this with accesss Tabs whilst designing the DB so not sure if that is why it stays open or not?) I want the form to...

I Think I may of worked it out but would someone mind looking at this code for me to see if it is ok please Many thanks Private Sub cboProductionEmployerDetailsID_NotInList(NewData As String, Response As Integer) intAnswer = MsgBox("The Production or Employer " & Chr(34) & NewData & Chr(34) &...

Hi guys could someone please point me in the right direction to "fix" this code please. I have tried my best to do it but I don't really know what I'm doing to be honest ..Im just reading other code for tips and hoping it works !! when I click 'cancel' on the 1st msgbox everything works fine it...

Many thanks all for the replies - I created a "testform" and re did the controls and it works now Thanks for the info Bob - i was wndering if that is what was causing the problem but now I know it was and why ! Thanks again

Thanks for the replies.. Yes it still does the same if I after I have enabled it by default (Data Properties - Enabled = Yes) The bound filed does exsist in the table but It was a field I added to the table after creating the form - not sure if that could cause a problem? The ControlSource of...

Hi guys, could someone point me in the right direction please as I can't seem to work this out ! I have a Combo Box "cboNumber" that contains a value list "1";"2";"3" I have an event set up on the AfterUpdate to check what number is chosen from the value list Private Sub...

Thank you so much that has done the trick What I did was to put a cmd button on the form called it CmdHidden and put the code in LostFocus and voila it is working great now !! I really appriciated all the time in resolving this.

Ok we seem to be getting closer here now when i enter a new record and get to the gender control if I don't enter a value the msgbox appears BUT if i just click ok to the msg and carry on it still lets me go thruogh the form until the end and the dread access default message appears again ...

sorry to say it is still not working as soon as I go to a new record and tab through the various fields and get to the gender box it allows me to tab past it without putting anything in. After completing all the other fields in the form and tabbing out of the last field the access default...