Recent content by hcoburn

I have been passed a very simple database with one table and one form. It is being used simply as an invoice number generator. I have been asked to empty the database for use on a new site and prefix the primary number with a letter to distinguish it from the previous site. The form has two...

Ahhhh - thank you! Just by asking that question and making me look at it, I have realised that Company is text, while the value in Customer is numeric. By changing [Company] to [ID] it has worked! Thank you very much for your help! I can go to bed with a big smile on my face now :-)

Hi Gary, Thanks for taking a look at my problem. Unfortunately, being totally new to this I have no idea what you mean by PK and FK. Hazel.

Of course - sorry! I get a runtime error 3634 'Data type mismatch in criteria expression' Just in case it's useful, I have also used the code below which opens the form but at a blank record. 'Private Sub CustomerDetails_Click() 'DoCmd.OpenForm "Customer Details", acNormal, , "[Company]='"...

Hi. I am new to this site and to database programming... I have a form where I have placed a button, which when clicked, I want to open another form at the relevant record. I'll try to explain this. The form which I am starting from called Case Details has a field in it called Customer which...