Search results

Basically, I'm trying to graph series of data. I've noticed that the values of FALSE and "" are not the same as a truely blank cell. Is there anyway I can return the result of a fomula in a manner which acts exactly the same as a blank cell?

Is there a way to pull the trendline equation out of the text box on the chart and use it in a cell?

I have large sets of data that has labels on them. For example "25.56 lbs". I just want the raw numbers. Can someone help with what to type in the update to field of an update query to just keep the numbers? Thanks

Is it possible to change form properties based on the group that the current user is in? I'm not sure if there is a way to get a user's workgroup information in code. The reason I ask is that in order for certain actions to work properly, I have to give one group update permissions to a table...

My query: SELECT Count(*) AS Expr1 FROM tblBuildListTemplate WHERE (((tblBuildListTemplate.[Part ID#]) Is Null)); This returns the number of records in the table where the field Part ID# is null. When this query is run, a value is given in the Expr1 field. My question is, how can I then call...

I'm looking to create something like this: If [FieldName] of any of the records is equal to null Then It would also be nice to count the instances in which those fields are equal to null to use later in the application. Any suggestions? I don't know how to cycle through a recordset like that.

I saw there were several posts by people who thought they lost their relationships after a split, but that was in the front end. Mine are now gone in the back end. None of the tables are even shown in the relationship window. Just a heads up I guess. :confused:

Not sure how to search for this one, so I'll just ask. What's the difference in using a dot or an exclamation point in the fashion of: Me.controlname or Me!controlname I see different versions of this particularly in referencing controls or objects outside the current module.

I've searched and couldn't find an answer. This is going to sound stupid, but why can't I step-into and debug code unless it is in a Module?

I have many queries that all do the same thing. The problem is that they're connected to specific controls on a form, so I have to make a new query everytime I make a new form to perform the same task as the others. This would be eliminated if there was a way to use the criteria the same way you...

Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties. Some of my column titles are long, and...