Recent content by Jaxson

datAdrenaline, i want to thank you for your help. I highly appreciate it. This WHERE ( [Field1] Is Null Or [Field1] = "") AND ( [Field2] = "L" ) AND ( [Field3] = "L" ) statement worked perfectly.

I just discovered that the search turns up for the blanks as long as I set the database default value for the text fields to "". However because I am importing this table from excel, I dont know how to apply the default values to the imported data. Im not sure how the blank cells are...

dmonney, yea...I just moved the chart to its own individual form and created a button to link to it. Now everytime it opens, the chart is always updated with the new values opposed to when it was in a subform. Maybe because it was drawign values from other subforms in the same main form...

Hi, I have created a filter for my database. I have a combo box for the user to select what they want to filter the database by. Every option works except when the user wants to see the records with blanks in a certain field. Using debug.print, this is what the code looks like, do you see...

I dont know what it could be. I had a refresh button that requery the graph when clicked, but that is what was causing the "enter parameter" message to appear when exiting the graph. So I removed it. If I dont click on it, the message does not appear when exiting. So now I still need a way to...

Okay....but now when i exit the form, a message box saying "enter parameter value" for each of my sql statements appears. If I just click "ok", it will clear my table since I am not entering anything. But if I click "cancel" it will ask to debug my code and highlight the "DoCmd.RunSQL...

I have the following code posted in the form with the chart. Other than it not updating the chart, it also requires the user to click the chart first before thiese lines of codes even run....I though the _enter() was an automatic type event procedure. Private Sub ComparisonChart_Enter() Dim...

Unfortunately, that still isnt working. I entered the code, which you help me with yesterday, into the form with the graph. But with the code u sent me, a message box pops up everytime to notify me that its updating the table. But by the time the table is updated, the chart is already up and has...

dmonney, Your the man!...Thanks. But I have another problem, maybe you can help me also. The issue now is that the value sent to the table is 0 at first because the two subforms dont get a chance to calculate the volume and weights before the chart is created. Is there an event procedure...

Anybody else have any suggestions?

hey dmoney, Thanks for your help so far. Unfortunately I still got an error. It seems like theres a syntax error involving the perenthasis and the quotation makrs. Please let me know if this is right. Is this what you mean when you said I had to fill in the paranthesis. Thanks Dim...

Hey guys, Objective: Create a chart comparing the weight and volume of two items, A and B. Parameters: I already have two subforms, each which calculate the weight and volume of A and B. I then created a bar chart which illustrates the weight and volume differences for a set of psuedo...

bump......

I have two subforms, each displaying a "weight" and a "volume" of a specifc car. However now I want to plot them on a bar chart, one bar showing the weight diff and one showing the volume diff. How do I go about doing so? I tried chart wizard....I even tried to link the subform to a table...

Pbaldy, Thank you so much. It worked. You just significantly helped a huge group of people.