Donate SIGN UP

Access Database help needed

Avatar Image
Moonstone6 | 10:54 Wed 15th Jul 2009 | Technology
6 Answers
Hi All,

I use an access database at work. Basically i just want to add a new field on the records screen where i can enter a reference number. I thought i had done it but it keeps the same number i have entered on each record.

How do i make it so that on each new record the box is blank again so i can enter a new number (and it stays there)?

Thank you
Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by Moonstone6. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Hmmm from memory, I am presuming that the field that you want to add is already in the database?

If you have a newer version of Access make sure that the wizard icon is clicked in the toolbox when you draw the field onto the form. You can then select which field you want to bind it to.
Question Author
Well i created a text box where i wanted it but it has no event on it as all the events that are already on the system are on the same page so if i add it to this box it will edit the other field thats on this page (if that makes sense?)

Thank you btw :)
I don't think it's an event that you want, you want the rowsource to be the corresponding database column.
doesn't it work like excel.....click at top of column to highlight ...right-hand mouse click......click add column.....god it's years since I used access....
Question Author
Thanks Craft bt that doesnt sound like what i'm looking at here??

Haggis - how do i do this then??

Thank you :)
-- answer removed --

1 to 6 of 6rss feed

Do you know the answer?

Access Database help needed

Answer Question >>