Recent content by NickS

Hey guys, This is amazing. I have a calendar I use to show who is out of the office on leave. I have >100 employees, so, sometimes that is a long list. In order to make the list readable I only make appointments on this calendar that are "all day events". Here is where your sample code...

I went to make sure I can still add new records using the form and it opened to a new record this time. I am not sure what is different, but it works now. I am kind of embarrased to have sent you on such a wild goose chase, but thank you so much for your help. This forum has already improved...

Thanks Pat, I am not sure why I would want to open this form to a specific record or how I would do that, but, I think you are suggesting that I place two buttons for this form on a switchboard. I don't have a switchboard for this DB yet (still in development) and I don't really want to...

Thanks for the quick reply Linq. I cannot find anything to indicate that Access 2000 has a trusted location feature. It is not in the places cited by BTAB, nor is there any mention of 'trusted location' in the Access 2000 help file. I think the other code there was created when I used Access...

Oh, I am using MS Access 2000 if it matters. Thanks again, Nick

Okay, so I am trying the same thing. I want to have my form open to a new record, but I also want to be able to see other records and edit them as needed. I do not have a switchboard yet. Here is the whole contents of my VBA code for the form: Option Compare Database Private Sub...

Pat, Can you help me understand why it is helpful to avoid spaces and special characters in nameing columns? I am working now with some databases that were poorly constructed and that is part of why I have to rework a lot of them (several databases with overlapping information, tables that...

Hello there! I am reletively new to database design and I am hoping to make robust data tracking systems which will serve my workgroup for a long time to come. I have two tables relevant to this question: Employees and Evaluations. Employees has the following fields: EE ID, EE Name, Job...

Hi, My name is Nick, I live in the US where I work at the City of Modesto's Wastewater Treatment Plant. I am an Administrative Analyst and I am working to, among other things, improve the data tracking capabilities of my workgroup. Chears.