Search results

Thanks all, Got it working in the end.

Hi All, I have a field on one of my forms called Status. It is a combo-box with 3 option, Awaiting Collection, Collected and Cancelled. When a new record is entered, the status is usually Awaiting Collection, it later changes to collected. I want the time to be recorded when this change...

THANK YOU EVER SO MUCH!! That was exactly what I was looking for. It works perfectly. I have one more problem though.... When I try to use the frmUsers from my db, a message pops-up saying: Microsoft Access couldn't find the toolbar 'Standard form' What could cause this problem? The rest is...

Hi All, How do I assign a password to a single button? The buton will be on a form, acting as a switchboard. Only some users will be allowed to use it. So, when the button is clicked, a form asking for a password should be opened, after entering the password, clicking the OK button should...

I know that a single Archive button will do the thing, what I need to know is HOW DO I MAKE ONE??? I have tried and tried, but cannot make any sense out of it, would you please help me? The easiest wat for me to do it is by building a Macro, I have had no training in Access, so I am not...

Hi, Thank you for your very detailed reply. You've really dropped yourself in it now, I need more help, and will be knocking on your door to find it!! I've got a form acting as a switchboard, on there I want a button. When you click this button, it must start a fully automated back-up process...

Nothing in the Archive search is of any use to me. I have looked at some of them. The only one that might be of help was a guy asking for all deleted records to be automatically saved in a new table. This will work for my purpose as well, but the link given in the post is not active anymore...

I am stuck!! Please help me with the validation rules for certain field. I have a text field called Sender_out if this fiels left blank I want an error message to be displayed. Please help me with the format of this validation rule. The field is a combo-box, linked to a table with...

I have this databes that is being used to keep track of parcels delivered to and collected from my office. It has been used for about three months now, all the data is stored in tables, unfortunately the amount of data is getting so much, and it really slows the thing down. Is there a way of...

Hi All, I have just finished rebuilding my database, the reason: the old one didn't want to allow me to create a new MDE file after some changes were made to the Back end. I have got a copy of the database on disk now, so I wouldn't need to rebuild the damn thing ever again!! Can someone, in...

Don't Worry, Got it sorted

Hi, I have a Excell Spreadsheet. In the "A" Collumn I have Last names, and in the "B" Collumn I have First Names. I Know that there is a formula to merge them in to one collumn in the Format Lastname, First Name How do I do that? Please help as soon as possible, Need to get this fixed...

I would like to stick a spanner in the works as well now!!! After succesfully creating MDE files from the BE on the server, suddenly MS Access doesn't want to allow that anymore. It says: Microsoft Access was unable to create an MDE database. Why is that? Can I fix it in some way? PLEASE HELP!

*.MDE When I try to create an MDE file, All it says is: Microsoft Access was unable to create an MDE database. I have no idea how to get around this, it is not crucial that I get to create a new MDE, but, there has been some changes, and if I implement the suggestions you made, I will have to...

Hi, Most of you have probably noticed that I have been posting rather stupid question all over the Forum today. I have been struggling with this damned database for weeks now, and I am at the point where I have decided to start all over again. I need Help! I need a basic database to keep track...

Hi, I am new to this discussion so please be kind to me! I have a VERY basic database that I have been constructing myself. I have had no training, so it is very simple at the moment. I use it to keep track of all the parcels delivered to my office. In my table/form, I have a box to enter the...

I am currently using a Microsoft Acces Database, It has been in use for about three months now. It is very basic since I have had no training and am only playing about at the moment. The promblem is: I am using the database from a server on three different PC's. I have split the datebase...