Search results

Thank you all for your comments and suggestions. I have now plenty to work with this morning. As for the comments regarding using a name...yes I agree... I should have included the ID of the table instead of my made up name... I only posted part of my whole table but I get the idea that using a...

Yes a person could have two periods of employment or as in the case of my table a person could have more that two inpatient hospital stays. What I am trying to figure out is how long of time has elapsed between those visits. I use the datediff function to determine the space of time (length of...

I have a table that has the following feilds: Person Start Date End Date John Smith 10/1/2006 1/14/2007 John Smith 2/18/2007 5/31/2007 What I want to do is calculate the number of months between the 1st end date and the 2nd start date. Any ideas on how to do this? Thank you in...

THANKS! That worked! Funny how something as small as putting commas and brackets can mess you up. lol...

I am getting a data type mismatch on this code. In the debugger tool when I hover of the dolookup nothing is showing... not sure I am doing this right. The dolookup is refering to an actual query in my database. 'Declare and instantiate the object variables Dim dbs As Database...

I think the problem other than have the dlookup wrong was that I was trying to the reference strSQL. I changed my code to reference an actual query in the database and it seems to be working better now. Private Sub ComboClassName_BeforeUpdate(Cancel As Integer) 'Declare and instantiate the...

I give up.. I am going to try and go about this differently. I am going to try and populating the field with zeros to start with when I pull in the other data via my query.

I tried that but since I am populating some of the fields in the table before the form opens and that field is not one of them I get an error saying I am violating the validation rules.

How do I force them to enter a zero?

I am developing a form to process training taken by caregivers. On the form I have a field where the user will select the class. After the class is selected I must validate if the caregiver can actually take the class or not. This depends on how many times they have tried taking the class or if...

At least not in that field there is nothing to save but the problem is that I need something in that feild for me to caluclate other fields even if it is a zero. This one field must be verify by the user before proceeding to any other field on the form. I cant use validation rules in the actual...

I tried tabbing all the way through my form and then closing the form thereby saving the new record to the underlining table and nothing happens.

I tried the suggestions in this thread and it has me almost there but... it doesn't seem to work unless the user actually does something in the field. I am finding that if I just tab through the field it doesn't work. Here is my code: Private Sub CostShare_BeforeUpdate(Cancel As Integer)...

Thanks for this tip... I was working on this before I left work today...can't wait to go back tomorrow and try it out!

That is correct. The combo box will only hold the field that you have set as the Bound column in the properties box. In the properties of the combo box I usually hide all the extra data from showing in the combo box by setting the column widths to: 0";2";0";0";0";0";0";0" By setting the...

On the Orders form you want to use a combo box that is build with an underlinging query from the two tables that has all the fields want to use on the form. In the code behind the combo box use code for after update similar to the following: Private Sub ComboCustomerName_AfterUpdate() 'Updates...

Thanks! lol... how simiple was that! lol....

Hello fellow developers, I have two forms that I am working with: The Switchboard and a member/provider listing form. From the switchboard depending on which command button gets clicked opens up the member/provider from. On the member/provider form I have two fields: member field and a provider...

I have a form that opens up for the user and allows the user can pick a member name. What I want is that once member name is selected the Main form (Providers) opens up at the members name (Subform). I can get the main form to open up with the correct provider but I am having trouble getting it...

Yeah... after waking up a bit I figured out that it would be better to get my results with the following query: UPDATE WorkSheet INNER JOIN RateCode_DOS ON WorkSheet.PIC = RateCode_DOS.PIC SET WorkSheet.CategoryStartDate = RateCode_DOS!Condition WHERE...