Search results

Is there a way to write an if statement into a query with a SUM column that says if the query is null, return 0? The query that I'm is trying to total an amount of a certain type of asset, Insurance. But, it is possible for certain sets of clients to have none in that category.

I totally forgot about setting the format of a column in the query. My mistake. /thread

The column in the query that is sorting oddly is an expression that does Format(Value, "STANDARD"). Instead of sorting ascending or descending, it is sorting like this: 1,526,222 167,254 17.56 1,800,332 200.45 2,364,209 240,000 and so on. The value was initially currency but they don't need...

Okay one more thing. Since it shows the column as an expression, how can I set decimal places? It doesn't show up in the property sheet for the column.

Cool, thanks for the info!

So I would just call the function as that column?

Okay, so I've not done much with calculating a value as a query value. I'm currently doing some research but I figured I would also ask here. So this query needs to include a fee that is calculated in the following way: 0.4% for the first $5M 0.2% for the second $5M 0.1% for everything else...

No I did, there is one form that shows clients and their net worth. When you click on one of them, it switches to the Client tab, grabs their Client ID (which is the bound column in the combo box on the Client Tab) and runs the After Update, as if you just selected them on that page.

No error messages, it just never sets a new ID. I'm going to try something here shortly and I'll report back with my findings.

I found the problem. There was faulty logic in the code hat was bypassing the AfterUpdate call. What happens is after switching to another tab on the Navigation controls, if there's a certain condition met, it will run the after update to pull the correct data. The after update is for a combo...

I had another thread that as more specific but I figured I'd ask another question that is broader to help my understanding of how these work when creating a new record. Let me give some background. We have a form that pulls from a table called AssetLiability. It contains assets for all the...

Is it possible to have code run the _AfterUpdate event? I've seen it done with ControlName_Click in the program I'm working on but it dosen't seem to be working if I try to do ControlName_AfterUpdate.

Well, I just checked the table. It looks like they're in there but it's not saving the Client ID (one of the fields in the AssetLiability table that we filter the records on). If I'm pulling info from a table (Select * from tblAssetLiability where Client ID = #), which pulls all the assets...

Well, one of the combo boxes requires a pull on the AssetLiabilityID (the primary key that should be autonumbered), and while trying to create a new record it is always null in the new program. I tried saving the record before doing that part of the code and it seemed to work but whenever I get...

Let me explain. So the old version of the program we're working with, one form is pulling from a table. If you hit new record, it assigns it a new ID in that table (even though it says the ID is null when it loads, I have a message box pop up on current and it always says Null). Anyway, in...

If anything, the basic thing I need to figure out is if I can switch tabs from the code.

Anybody? I feel like BrowseTo isn't the code I'm looking for. I can't find much about coding a switch in Navigation Tabs.

Basically what I'm trying to do is DoCmd.OpenForm ("frmname"), acNormal, , , , acWindowNormal, variable & ";" & variable2 which works fine for forms that are pop-ups. The problem I'm having is that on a navigation control, if I do the same thing, it doesn't go to the tab the sub form is on...

Okay, I was just wondering if I could do something like ListBox.Requery ORDER BY or something similar. At the moment I'm just setting the row source again except applying a Ascending or Descending sort. Thanks for the reply!

Okay, I have a few listboxes on a page that have several columns. Is there a way to requery these and just say order by somehow instead of having to rerun the whole query with a different order by? Thanks in advance.