Recent content by bmsrmd

I currently have a reports menu on my db that allows employees to use ComboBoxs to filter for accounts based on Program and Manager. Everything functions correctly, but my problem comes from how the accounts are displayed when there are multiple ones being pulled onto the form. In its...

That solved the problem! One of the tables (that is pulled out of an external system) had that column defined as text instead of numeric for some reason. Thanks for the help pbaldy and Pat!

I tried that method, but I get an error when I test it out: "This expression is typed incorrectly, or it is too complex to be evaluated." I've double checked several times to make sure I had typed it correctly. That shouldn't be the issue. =Sum([Plan]) Any ideas why the formula is...

I can't seem to find a way to SUM two seperate columns on my report. I've attached an example of what I am talking about. I was able to add the SUM feature to the 'Estimate' column, but it doesn't allow me to add that to the 'Plan' column too. The only options available are Count Records or...

Where would I put the code to inner join them?

I haven't setup any relationships yet between the two tables, but I made this to help explain my idea. Let me know if I can provide anymore information.

Table 1: Account Number Start Date End Date Cost data** Budget data** Table 2 (Imported excel file with cost/budget data): Account Number Cost data** Budget data** ------------------- Table 1 is the main table that will be viewable in this database. The idea here is that new Account...

I changed the subform from 'Datasheet' to 'Continuous' view, and was able to add the button. It does show up in Form view now. The problem with Continuous view compared to the Datasheet view is that it no longer gives them that snapshot of the data in the table. It basically just shows them...

Alright, I gave adding the button to the subform a try and updated the code onto frmReviewSubForm. I must be doing something wrong, because no buttons show up when I go back into Form View.

pbaldy - Thanks for the clarification. Here is what I got after running that Debug.Print.. Looks to be the same as you expected. DELETE * FROM tblEvaluationDatabase WHERE CAccount = '' Pat - The button is located on the frmEvaluationForm. My idea was for them to be able to click on a row...

I tried changing the code to: DELETE * FROM tblEvaluationDatabase WHERE CAccount = '' but I got this Run-Time Error 3075: Syntax error (missing operator) in query expression 'CAccount='. I am still learning how to use the Immediate Window to test my code.. That website has a lot of useful...

Thanks, I am taking a look at that now and I'll let you know what I find out. On a side note, what do you mean by the control may be blank? Is that something I can check within the code?

The delete button is in the subform detail section. What is causing it to only delete rows that have a blank CAccount field? With the current code, it will delete all rows that meet that criteria. I am looking for something a little more specific. Each row in the table will have very different...

Me.txtCAccount (and all of other fields on the data table) are populated by the various input fields on the form. The data that the user inputs on the form is then submitted and added to the table. I tried using the delete record button, but I couldn't get it to function exactly how I need...

Brief Description: The purpose of this database is to have a simple form that inputs data into a table. There is a subform view on the form so they are able to see their data that was submitted into the table. Problem: I have made an attempt at making a Delete Row button. The idea behind this...