Search results

Hi Bob, sorry wrote it all a bit too quickly! So I want it to be appended to a field in the table as a new record

I have a table that I would like users to update. Ideally I would like them to press a button that then opens a message box or form where they can enter their name. Then with another button click their name is added to the field in the table. This table then feeds a picking list for something...

Thanks both, Minty could you give me a little more detail how to do this please?:confused:

Hi, what I would like to do is open a form based on an old record selected from a drop down list. When the new form opens it creates a new record but with the old values. I want it so that the user can then edit these values. When the record is saved it keeps the old record and creates a new one...

Thanks the brackets seem to have done the trick

Hhhmmm, the problem I am now having is that moke123's code now works even when Me.Drug.Column(1) = 0. Is there a way around this? Thanks for the tip Minty, I have tried this but it seems to still allow the printing.

Thank you so much, that worked perfectly!

Hi, I am trying to set an if statement to prevent someone from printing a label unless they have enter all the correct information, under certain conditions. So my statement below works when the condition is enabled, but it makes no difference if they enter data into the two other fields or not...

SOLVED Re: Keep the previous value after creating a new record Thanks all, I have got it now :D

ok, so would the quotes be the word quote or the mark " ? Thank you again!

Although next problem is it provides #Name? instead of the data in the two text fields. Should I convert these to string?

Thank you that has done the trick!

Do you mean the phrase cQuote?

I get a run-time error 438 if that helps

Thanks but it still doesn't like it :(

Thank you, that works, but how do I code it to take the data for two other fields or is that asking too much of Access?

Ok, yes I understand that but, how do I set contants for the other two fields?

Hi, I have used this to code to open a new form keeping the details of one of the fields: Private Sub Command48_Click() Const cQuote = """" Me!Cost_Centre.DefaultValue = cQuote & Me!Cost_Centre.Value & cQuote DoCmd.GoToRecord , "Form Label BRI", acNewRec End Sub It works...

SOLVED Re: Printing Problems Got this sorted! With thanks to Minty for tidying it up and explaining what was happening. I then worked out to a an extra if statement to end the event if needed.:)

Ah ha! So I am happy with clause 3 always printing, but only if I can make sure that clause 1 works only works if clause 2 is false. Obviously what would be better is if Clause 1 always prints and clauses 2 and 3 only print if clause 2 is true.