Search results

Didn't work. Type is prolly the problem as you said so I gave up on this and just did it the hard way. You know Making a query, making a form based on that query, putting it in a subform and requery it from time to time. Djees and all that for a stupid total :cool:

I don't know why but I always get #Error can you type it for me please, so I can just copy paste it. This is the sql statement SELECT Sum(Amount) FROM Results WHERE Type = 'Order'

I have a form which contains a subform. The subform is based on a table named: "Results" I have a textbox on my mainform which needs to show the sum of all the "Amount"s in the subform that have "type = 'Order'" So I tried the controlsource of the textbox and I'mpretty sure that it can be...

I want to have a msgbox asking for confirmation when closing a form by pressing the X in the top right corner of the form. Grtz, Nirious

Hi, I have disabled all menubars in my program, but with all those windows open, things can get a little messy from time to time. So I thought I'd put a small form in the bottom that is always on top of all the others (even when another window has the focus) and put a combobox on it that at...

I have noticed several functions come in two ways. With and without a "$". What's the difference?

Yeah sorry about that. The string I copy pasted came from different parts of my code. The querystring is built dynamically based on what the user wants to search for. the pieces I copy pasted don't really fit very well. :) I tried it entering the dates in US format being mm/dd/yyyy. And all...

I'm going nuts here. I have a sqlstring in code that acts as a search function. I can search for all and everything, but there is something wrong with my date-search, and I can't get it right. This is what I have: SELECT bestelbonnr, klantnr, datum, 'Leveringsbon' AS EXPR1 FROM Bestelbonnen...

OK, thx. I'll give that a try Nirious

But it isn't based on a tabelcolumn. It contains values that I added myself.

Ordo I have to write the sorting code myself? Or is there someone who already did it :p

Actually the title says it all. With for each or do while or something?

Thx, had to first turn autocenter on and than again off to get it to work. But I got it :)

I have attatched a jpg-file that shows the layout of my report. I currently have the first one. But isit possible to show the second layout? In the first I use the form's footer and header to draw the lines, but I can't do that in case two as the "details-section " doesn't run all the way to...

I have several forms on my screen right now. Is there a way to tell access where to open which form from code or properties or something. So give access the x-y coordinates where to show the form every time it gets opened

I made my own printdialog window for printing my report. I already have a list of all printers, and all works just fine. Now I added a new item to the printers combobox "send by mail". Any help with what code I should put there. Or are there (if possible free) programs that appear as a printer...

I want to know how I can find out if access already is installed on a pc from code. What file or registry key should I look for?

I haven't tested it out but if I had do do it, I would write it like this: =Sum(IIf([vehicle description] Like "*sand*";1;0)) Or maybe something like this: =Sum(IIf( InStr (; "sand"; [vehicle description]; ) > 0 ;1;0)) Again not tested so don't shoot me if the syntax is wrong. But it should...

I have an unbound textfield that is copied to some other fields and blah blah blah. Bottem line, how do I restrict the user from entering more than 30 signs in this field. I'm looking for a concrete piece of code, or constraint or something. Thx for helping, Nirious :cool:

I have a table with two columns ( OrderNr and Client) So lets say I have in this table three records: ORDER CLIENT 100001 AA0001 100002 RA0005 100003 BV0034 I would like to have them printed(or just shown on screen) like this...