Search results for query: *

Thanks to everyone that helped me with this. I think it was a combination of these answers that fixed this. Trial & Error. In case anyone is interested, here is how I got it to work: Used Gary's suggestion and created the funtion he suggested but changed it to an Integer instead of a String...

Sunil, Goood advice and you are correct. To my humble defense, however, I am merely trying to work through some design challenges right now and hence did not pay much attention to naming conventions. That's a bad habit on my part though. I should at least clean it up before posting here...

Gary, Wow, Ok. So there is something I didn't know. Thank you. I made the changes you suggested yet still receive the "Data type missmatch in criteria expression". Both the Public variable and the EntryType.numResClass are declared as Integers. Yet your function declares as a string. So...

DanJr, Thanks for the quick reply. Yes, I just tried that and received the following error when trying to drop down the cbobox list on the datasheet: 'Data type missmatch in criteria expression' Typically I do not have this kind of difficulty when using the Query Builder to create my SQL...

On the premise there is no dumb question. And I have searched the forums and cannot find exactly what I need to know here. I have a publically declared variable in a module called 'publicdecs' Public varResClass As Integer I populate this variable within a form. Now I need to use this...

cmm, Thanks. I think you are right and I will meet with our dba today. Thanks again Doug

I asked this question a while back and received no replies. I think I might have been a bit convuluted with my scenario. So I will try to be more concise this time. I am creating an NT Network based work-flow system in Access 2003. I have some "local tables" in native Access format as well as...

I am modifying a couple of the SQL statements contained within the WNTFY_EVENT_QUERY column in the above table. These records manage the SQL statements that are utilized to create content for the automated emails Project Server sends through Outlook when triggered by a modified task. In...

Hopefully someone has this answer: Scenario: I have a form with a tab control. On one of the tabs is a datasheet form. The datasheet form has a subdatasheet form. The relationships are working find between the subform and it's child datasheet form. But what I need to do is the following...

:-) Aceman1 Thank you. That solved it. And saved my bu** for a weekend demo I have to give. I think I better click on the 'Click here to donate' link for Tek-Tips as I couldn't begin to estimate how many hours/$$ the answers on this site has saved me. Thanks again Doug

I'm using Access 2003. I have a datasheet located on a tab control. The datasheet is unbound as I populate it via ROWSOURCE after the user has made a selection from a combobox on the tab control. That all works fine. My question is that I have data located in a CHILD table that I want to...