Search results

Just to drudge this up one more time, where SHOULD the relationships be? Front or back?

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

In my case, the security is fighting against me a bit. I need that group to have update permissions for the table in question, but I don't want those permissions when used on a particular form. Is there a way to not only determine which workgroup they're in (everyone who uses the database will...

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...

I had tried the text box method before I posted and had no luck, but the code given in the first response worked perfectly. Thanks!

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...

The SQL statement works great, thanks for that. I'm having a hard time calling that value in my code's "if" statement though.

I'll try it out. Thanks!

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.

Yes - split database, no relationships anymore in backend.

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:

Thanks for the reply. It looks like a somewhat confusing topic, but from what I gathered, in my applications it shouldn't make any difference.

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.

Thanks - I was hoping there was a way to run the code without actually triggering the event but I guess that is not possible.

When I'm working on code in within forms.

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...

Yeah, I think I'm stuck with it.