Recent content by Kharonne

Hey everyone, I have been looking for examples, templates, anything to help me program and create a Project Managment application in Access 2003. So far, the only template available is for Access 2007. Has anyone created a project management application in Access 2003? Does anyone know of...

Oh, thanks Kryst51. I was typing my own solution and then saw yours. I am glad that I did it the right way. thanks again

I figured out my own problem. I changed the form property for additions to "no" and that fixed it.

Hey Guys, Do any of you know a way to stop this command from returning a blank record? Maybe there is a better function for me to use. I just want the user to navigate through the records. I do not want them to enter a new record through this function. I do want them to have the ability to...

Thank You, I should have known that. It was clearly stated in my access book.

Hey Guys, I have included a insert to statement. I am having issues with two of the variables. UpdateYear and UpdateMonthIndex. These two are just number variables, but I cannot figure out how to get the sql statement to realize they are numbers. I have no issue with the string variables...

Hey Misslinglinq, I tried both of these methods, but neither seemed to work for me. the second one, when I complied in Access 2003, gave me errors. The first one, I tried just did nothing.

Do you know of a way to do this in Access 2003?

Hey Bob, I just wrote the form another way based on a query. It just seemed too hard for me to get the filters to work the way I imagined. Plus, I was having a really hard time articulating my issue with the form and filters. Thanks for your help.

Hey Guys, I really need some help, so I am posting this question again but phrasing it another way. I have a subform that is linked to the main form through the link field "ProjectNumber". However, I need the subform to filter records on that linked field. I cannot seem to get it to...

Thanks Friend, The quotes worked! Huge help! :)

Hey Guys, I keep getting this wierd error message with a query I wrote inside some VBA code. Here is the code: Function GetChiefSeid() As String Dim cnn As ADODB.Connection, rst As New ADODB.Recordset Set cnn = currentProject.Connection Dim Y As String Y =...

hey, I found a form online similar to the one you showed me, however, it seemed to work in my database. I don't know what the difference is, but I can post it if you would like to glance over it. Again, thank you for your help.

Thank you for the calendar form, I could not get it to work in my database. I recieved an error message "An expression you entered is the wrong data type for one of the arguments"

Hey I need a little help, I have create a calendar form in my database. This calendar form is just a form with an activeX calendar object. I want to use this form with the activeX calendar object to pass dates to fields in another form. For example, in my form Projects, I have 4 date...