Search results

Do the queries run fine when you have the warnings turned on? Because if there was an error, you will not have been informed about it and the queries won't have changed. I think thats the case here. "DoCmd.Setwarnings False" shouldn't affect your code at all, you just aren't prompted for...

You can't do it in your query itself, because it is an aggregate function(like, sum, avg or max), meaning, it operates on columns rather than on rows. You can make a new query that holds the value, or you can put it into the controlsource property of a textbox as an expression. I have added...

I have a form that appends a record to a certain table. When it is done appending the record to the table, it opens a new form (which has that certain table as recordsource) Untill here all goes just fine, but: Is it possible to when the second form loads or directly after to show the newly...

have you tried refreshing or repainting the form?

I have made a little example of what I currently have and what I'm looking for. example.mdb Currenly no matter what the code is, subformA will always be shown. That should change. Can you help me?

Ok, But can I just change my objectsource like that when FormA is the current subform? I mean like : objectsource = "myFormB" Linkchildfields = "myfieldfromB" linkmasterfields = "myfieldfromMainForm" And than it will be replaced and shown automatically?

Whats the difference between DCOUNT and COUNT? or DSUM and SUM etc. So actually what's the diff between domain aggregate functions and 'normal' ones?

Hi, I have a form that has one subform, but according to a field of the current record( in the table that is linked to the mainform), the subform should contain FormA or in the other case FormB. How do I do this?

=Sum(TableName!TableColumnName) should do it

No, you're not missing anything. :p I just wanted to know wether something existed like form returnvalues. As is appeares it doesn't but there are the usual work arounds. Thans for the reply both

The code to replace the null-values with something else isn't really my problem and therefor irrelevant. What I'm asking is how I can know what the user selected on the popup form. So how do I get the return value of the form if there is such a thing? Or do I set a variable (being a not visible...

If this isn't possible to do, plz tell me so so I can stop looking for a solution. If it is possible but you don't know exactly how, but it can be done, than plz also reply. Any answer is a good answer. Though the best answer would be a sollution ;)

Domain agregate functions and normal ones? And when do you apply one or the other?

I would need to have a report that shows my artikellines on multiple pages, and at the end of each page it should show a subtotal of all the artikelprices on that page. Except for the last page, there it should show the total of all prices (of all pages), along with some other info. Is there...

yes, I think I get it now But I still have a problem. But I will post about it in the report forum.

Because I can only print 15 records on my paper. thus when there are more than 15, I will need to put the rest on a second page. So please if you know how to do it, don't ask why and just tell me ;) Thx

I really don't get this, maybe someone can explain it. I have made a form that is made ready to print. When I look at the printpreview all looks fine, but when I print it there are 4 lines of text that don't show up. Though those lines are set to visible -allways. :confused: The lines are...

I want to replace the recordset of my form with another one in code. It would have the same structure as the first, but other data. I would need to do this with the press of a button. So when I start the form, it will show the first recordset, and when I than press the burron, the seccond...

How do I do this. I need to get the first say 15 records of my table, actually a recordset from a form. And I want to put them into a new table with the same structure as the original (I can make this in advance so it doesn't have to be in code). Than I want all the other records, 16 and more to...

Is it possible to have something like this: I have some code that gets data from a table to another table. But it detects that some of the fields that can't be null for the second table are indeed null. So a form pops up with a combobox on it, displaying all the values that are possible for...