Search results

I'm not sure how I would do that? If I change the controls on the prexisting form then the user won't be able to enter data manually will they?

Hi, Is it possible to append to a form so that I can have a record from one table, query, append to a form. Then add additional info to that record and save it as a new record in the table the form is based on?! Thanks Sue

thank you very much that has done the trick! much easier than I thought it would be!

Hi everyone, I have a query as below: Row1 Row2 Row3 Row 4 Row 5 1, 2, 2 , 0 , 15 1 , 2 , 2 , 1 , 7 0 , 1 , 1 , 4 , 2 1 , 2 , 2 , 0 , 29 I need to pull our records which have the same entries in Rows 1-4 and then add up Row 5. For example The above query would make three more queries i.e One...

Hoorah!! it's working! thank you very much everyone who has helped me! Now I've learnt the exciting world of Case statements! Now onto the next thing! thanks again, Sue

I'll give that a go thank you very much! Good advice about paying attention to what I'm typing too! Not entirely sure what was meant about the IsNull check. If the field is empty then nothing should happen. Do I really need this? thanks again, hope you have a good weekend, Sue

select case statement Ok - here goes then, does this look right? If IsNull(me.purpose) then stradvice = "" Exit function End If Select Case (me.purpose) Case "3" OR "4" then IF (me.category) = "1" Or (me.category) = "3" stradvice = " This is Wrong etc." Case " 5" And (me.category) = "10"...

...more about If statement in code!! I knew there would be more! I forgot I also need to put in a separate criteria but in the same field property. So If Me.Purpose = 3 Or Me.Purpose = 4 Then If Me.Category <> 1 And Me.Category <> 3 Then Message = MsgBox(msg, Style) Cancel...

That seems to be working! Thanks very much! I really appreciate everyone's help! No doubt I'll be back soon with something else! Sue

Hi, that's working a treat now! Thanks every so much for all the help. If I wanted to add another condition is that possible? So If Me.Purpose <> 3 Then Else If (Me.category = 1 Or Me.category = 3) Then Else message = MsgBox(msg, Style) Cancel = True End If End If End Sub Could I add in...

I have put it on the On current part and that seems to work - do you think that's okay?

I think it is working - is it the else you added that makes the difference?! How can I stop the user from moving to the next record unless they have put in the right criteria. Cos eventhough the message now comes up when it is supposed to the user may ignore it and move on. thanks...this is great!

Thanks to both of you, gives me a lot to think about. However, there is only one combination that requires a message box. All the other combinations do not matter. The only one is if purpose = 3 then cat must = 1 or 3. Does this mean that I will then have to think of every combination and...

Hi, I have checked I have got the code is as if purpose = 3 then catagory should = 1 and 3 and if not then a msg should appear. However, the message only appears if the purpose field does not = 3. No matter what combinations the are. I hope this is not getting too frustrating for you - I...

Yes you're right. Sorry got myself confused!! I'll take another look at whats going on!!

Hi there, I put this in the after update properties. I only get the msg when purpose = 2. I need the message to pop up if purpose = 1 and category doesn't = 1 or 3. not sure what to change!?

Hi, thanks for the help. I can seem to get that to work. Does that go in the before update properties?

Hi, I have a form for data entry relating to experiments. I have several fields such as catagory, purpose, outcome. Each field has a listbox to choose criteria from i.e. Category = 1 Environmental, 2 biological, 3 toxicology, 4 other and so on. What I need to happen is if the user puts in a...

Ah! I have put that in now and it works. As long as the other field is empty which is fine. Thank you!!! Sue

hiya, thanks for the help so far. I've taken out everything except for the Like statement. Item = Like [Forms]![Formname]![Itemname] & '*' Date = Like [Forms]![Formname]![Date] If I work with just the query (switching between views) it prompts me to fills in the above. If i leave Item empty...