Search results

I have a table that has two fields which I want to sum the one field based on the other field. The field I want to sum is a number data type and the other is a text data type. My research has pointed me in the direction of using this line of code. totalP = DSum("[FieldX]", "TableName"...

Yes.. I did find that out...after doing some reading... I have made an alternate design to accommodate for what I was doing. Thank you everyone for all the posts they were extremely helpful even though I am unable to do what I exactly wanted to do. With some modification I should be able to...

That makes complete sense...and I understand exactly what you mean... and it works for a text box on a form but what I am trying to do now is use the same function to edit the text color of fields in a form with subform that queries tables. Can I somehow before/after the query takes place edit...

I am sorry... I cannot distribute my work because it contains sensitive data. It would make it easier to solve but cannot be done. I appreciate all of your help. I am going to be debugging that section of code shortly I am currently working on another task which is almost complete.

I was going to do it in a form? I haven't really worked with a continous form so I am not sure of the differences. I wanted to make a form that would query the table with the date fields the spit that to the form and then run this function on it to change the text. Utimately, I would like to...

I did ... still no go...I am actually going to go over my conditionals above that because I think they may/may not be preventing me from ever getting to the insert statement. will update.

Thanks... That makes a little more sense to use a case statement. The code you present seems to do exactly what I am intending to do. Now my question from here would be using this line: myControl.ForeColor = ColorValueOfDateComparison(Date#1, Now()) Now from my research on how to change the...

I am trying to build a function that allow me to compare dates and based on the dates relevance to current date. I have a table that has several fields of dates and I wanted to be able to color code them accordingly. My questions are I want to be able to do this in a form or series of subforms...

Hello, I got around to testing your suggestion and the original way I had it setup it was giving me an Invalid use of Null error because I was using the the OnClick event and after I click a value from the drop down list it would error out because the selected value would get set to the...

Hello, Thanks for your input... I will try and test it out tonight on my test db here at home. But when I get back to the actual project I will test it there. It seems that it should work. I must be just missing something stupid. Thanks again... and I will update this post if it works.

I wish I could it would be helpful but the data I am working is sensitive and cannot release it. I am just experiencing issues with the design because the db was given to me and I was told to make it work etc.,etc.. Anyway, what I have done so far if made an OnClick Event procedure. This...

Thanks for the reply. I actually starting doing that and it didn't work for me. But I have tried it in VBA and I used the INSERT statment to do so and I also added a section that won't allow data entry until the list item is selected. Now I am just debugging the event side of it. I am not sure...

I have general question about queries and data entry form working together. I have made a drop down list that queries a field spitting back all of the entered data in that field. The next action I want to do is upon selecting a certain item from that list I want to enter in the selected item...

I resolved the issue in a re-design of the orientation of my forms. If I have more time and interest I will go back to having pages instead of separate forms.

Ok... I am still having problems getting data entered into the table. I have simplified my form down to just one table to see if I can get my code to work...unfortunately this doesn't work. Here is what I have done with my code: Original Code: Private Sub cmdSubmit_Click() CurrentDb.Execute...

Thanks for your response again... I appreciate your help I have been researching this area for I am not that familiar with writing code for forms. I have taken your advice and checked all of the names and controls. The way I have it is that each control and name are the same only for one text...

I was unable to find row source but I am assuming you meant control source. Looking at my properties window for each text box on all the pages including page 0. has a control source selected as the name of the field from the correct table. The name field in the properties window is the same as...

I am sorry I probably wasn't very clear in my explanation. I have 3 tables with different data. I wanted to make one form that would allow me to enter the data for all three tables then hit a submit button to insert it into the respective tables. The idea was to make a data entry form that...

Thank you for your response. I am still receiving Object required run-time errors when executed. However, when it got the statement that controlled the pages I could not enter data in it threw out an error saying it cannot append a row on NULL data.... which makes sense because nothing is in...

Hello, I am trying to make a form that will enter data in 3 different tables. I created a tabbed form with 3 pages. Each page corresponding to a separate table. In Design view I set the Form Record Source to include the three tables I want to enter data to and set it to data entry = yes. I...