Recent content by Julia

I have a form where you have to add a category from a lookup table. Is it possible that if its a new category, you can add it and it also adds it to the lookup table list?

Hi Given this scenario, what would be the best option... I have a database already running with records in it, each record has a scanned document saved in a file. I want an option on the switchboard to open up this file so that the user can then find the scanned doc within the file...

Hi New to Access so need help! How do I link marco actions,,, i.e I want a macro to... open query display the result in the form (rather than the table) Help! Thanks

Hi I am fairly new to Access so I am looking for the most easiest answer! I want to look up a record number and if it isnt there, for it to return a message saying no record found instead of showing the table with (autonumber) and then all fields blank. Any ideas? Jules

Hi What wouyld be the best way to acheive this... I want to be able to put a search button on the switchboard where you can type in an ID and then it returns the relevant record, either highlighted in the table or on a seperate tab. and if it doesnt find anything, return a message. Thanks

Hiya I have a list of data ordered by Record Number. At the moment, the last record is 2555. I want to be able to use the form to go onto add new record and it start with 2556. Is there a formula I can enter into Default Value in design view what will do this? I havent used autonumber...

is there something I can put in Default Value which will say when adding a new record, it goes onto next number

Where would I put that function? I am newish to Access, I did it briefly a few years ago but forgot most things! Its just starting at 0 at moment

Hi all I have a simple problem but its frustrating me because I cant figure out how to do it! I have a list of data which I've already entered but I want the autonumber to continue from 2665. Also, I want to then, on the form for it to open on say 2666 to be able to add a new record...