Search results

Could be because you are using Date as a field name. Access doesn't like this at all. It's a reserved word. Using reserved for anything is up there with the evils of lookup fields. Change that field name to something else. What I post should work, because I'm using the exact same method for my...

Try this... In cboEmployee change the _AfterUpdate() to: Private Sub cboEmployee_AfterUpdate() Me.cboDate.Requery End Sub Then in cboDate, set the RowSource as: SELECT DISTINCT [tblTimecard].[Date] FROM [tblTimecard] WHERE [tblTimecard].[Employee] = [cboEmployee] That should work. I'm new...

I'd prefer to spank the user and let them know that they are doing something wrong (and shouldn't do it again), rather than leave them in complete utter confusion, and possible calling IT Support that their keyboard doesn't work :D

Wouldn't 'Limit to List' setting on said Combo Box achieve this?

Handy link to this fantastic PDF. Might take a couple of reads to fully understand it, but well worth it.

A text value. I'll describe what the data is in a little more detail should it help. First of all, we provide a service to health care professionals in the UK. So in Org we might have Goodhope Hospital and within that Org we have the following departments that use our services. Lets say...

Thank you for the very quick reply John. Does this looks right to you? I just tried the above code and it's spitting an error back at me :confused: Cheers for your help.

I’ve successfully managed to implement Cascading Combo Boxes into my new database. Quick overview: cboOrg is the main combo box cboDept values are dependent on cboOrg selection. Now all this works fine. However, I need to add one value (let’s call this ‘Dept X’)’ to all the Organisation...

I read this alot. Any reason why? Links to articles on this subject would be awesome.

I'd start with a pen and paper mate. Start with the basic table(s), like tblCustomer and tblFinance. Remember to keep different types of data seperate. Payment details shouldn't be in the same table as Customer details. They should be linked in Relationship Manager (via a PK). And then if you...

Couldn't this be achieved by basing the form on a query that pulls the relevant information from the respective tables?

I'd start with several sheets of A4 and some pencils. Draw your basic database design out. I'd start with tblLaptops (contains all the Laptops that you are able to book out) tblUsers (everyone who requests use of a laptop) tblBooked (contains details of booking, who, when, where and for how...

The following links might help, they all describe methods to achieve what you want. http://support.microsoft.com/?kbid=300688 http://www.mvps.org/access/general/gen0005.htm http://www.techonthenet.com/access/modules/hide_close.php

Had a brainwave while at work today, and did it there and then. :D Aye cheers. I'm all out of questions. Do have one regarding Cascading Combo boxes, but I think that deserves a seperate topic and in a different sub-forum. Thank you very much for all the Rabbie!

I'd suggest reading the PDF again mate. Found it a while back, didn't understand it the first time. But second time I sat down and poured over ever detail. And now I have a proper grasp of Access security. Currently implementing it in the new works database. The PDF is the how to mate ;)

Cheers. Managed to do that bit relatively easy (just looked at some demos, and changed the code accordingly). However, so of the departments need to be excluded from the cascading combos code. So they must appear in all Organisation, is there anyway I can adapt the code to do this? This is the...

We currently have a database that we use a work, while it does its purpose, the database design is not the best, nor does it follow best practices in my opinion. Therefore, I am in the process of redesigning it from scratch. While I can do this, I need a little help here and there. I should...