Search results

Have you based your form on the table or a query ??

Okay I'm sure this is straight forward and believe me I have searched for an answer but I think my problem is that I don't know what to search for! I have a form and on this form I have a list box with three choices, Pending, Accepted and Rejected... What I would like is when they choice...

You may find this thread of help, also follow the link at the end of it http://www.access-programmers.co.uk/forums/showthread.php?t=44656&highlight=dates

and onion crisps

They called their child Vienna, do you really expect them to know the difference ?? :D

Hi Can't help with all but I think what you may want is under tool - start up and if you uncheck all the boxes relating to toolbars expect Allow Default Shortcut Menus... you users get very limited menus to use However if this is not what your after, try doing a search on custom tool bars...

Have you done a search ? They has been a lot on changing there colour..... I know Cosmos75 has put some stuff in the database exmples Changing Buttons

Rich... I would be interested in seeing this but I can't open your attachment! I'm using 2k :confused:

the problem is it Saturday and you don't get many on the boards over the weekend, only us fools who have to do six day weeks!!!!!!! give it a while, I know I looked so one of them was me but I'm sorry not that great myself and although I maybe able to offer some advise you are better waiting a...

Try doing a search on combo boxes or list boxes, or depending what you are trying to do at the table level you can use the lookup wizard.....

Have you tried using Group by and then using a Expression to count each group

Your welcome :)

You want to set data entry to yes

Charityg…. That did it!!! Thank You, :) o1110010 Thanks for sticking with me…. Got there in the end !!!! :D

Any ideas ?? :(

No worries, just glad for the assistance. :) Okay I have attached the form and the table What I would like is when they open the form they can see what the next box number would be…..

Okay had a look but not really sure what I was looking at……. What (in simply terms :) ) did the code included in this thread do?

No, I could get it to work but not when the form was set to data entry :confused:

Okay all I need on the form ( which is data entry) is the highest box number; I don’t want it to add anything to this as a whole box is entered at one sitting so they just need to know what the last box was numbered. Each box can have about 30-40 files in each and the box number is entered on...

Okay I know what I would like but not sure the best way to explain it! We have a very high turn over of staff and clients, which generate a lot of files that we need to hold for seven years. Therefore our archive is large. I have a table in access that holds both client and staff and the box...