Search results

Either 12 or 24. possibly 15 or 27. Does this alter if it can or cannot be done?

Hi, is there anyway to display the results horizontally? if these are the results of my query Results 2 2 3 4 6 8 Normally they would be diplayed just like that in the report. What I would like is to have them displayed like this: Results 2 2 3 4 6 8

Its fine i have it working. If you were wondering what it looks like its attached. Sorry for any confusion. p.s you can probably see how easy the thing i was trying to explain is!!

Sorry I must not have been clear. I am using cacading combo's (I think, one boxes values depend on another, in a parent-child format)

I have a table with the following 4 fields (these are the ones i'm having the issue with but there are others). ID, Country, City, Date I enter data into this table via a form The ID is an auto number. The date is simply enetered. The Country Field is a lookup (in the table itself) with the...

Ok i had a look and these are the new questions regarding the modification of SJ McAbney's example. In his example he uses a table as the data source for both of his combo boxes. I would like a value list for the first/parent combo box (as stated above) and then use the code "SELECT...

Thats what i think i meant. I do have a form to input the data into my table. I'll have a look at your recommended example then get back to you. Thanks.

Hi, I have a table with the following 3 fields (these are the ones i'm having the issue with but there are others). ID, Country, City The ID is an auto number. The Country Field is a lookup with the following lookup properties Display Control: Combo Box Row Source Type: Value List Row...

Hey that works well. Thanks. Now the next problem... In the second combo box cboMonth (that displays the data according to the table select box "combo6") it dosnt select the months fields contents, it selects the contents of the first field (patient number). I think this code needs changing...

It still says Access cant find the macro. Stupid Question - Am i actually using a macro of some kind?

Hi Uncle Gizmo Even with your code i get the same error. It says Access can't find the macro. I'm not even using macros?? :confused: I also read in another forum i shoudnt use the name month as access uses this for something so i have changed month to FinMonth

Cascading Combobox record source Hi, I need help on cascading combo boxes, in my form In my example DB i have 3 tables(when i find a soloution i will implement it on a larger scale database which will have around 15 tables). I need to create reports of these tables. The problem was that i...

I'm sure it is something along the lines of this FAQ but i wan to base 1 combo box depending on the table it has selected. How do I filter combobox based on other combobox/control value faq702-3924 Posted: Jul 22, 2003 (Edited Aug 13, 2003) Mostly access user having problem to filter/fill...

Hi in the attached database there is a form called "with table select". I want to be able to select any one of the three tables i have in the top combo box. When this is done the bottom 2 combo boxes will display the relevant data if needed (look at the other form "myform" to see the fields...

You are simply amazing!!! :-) That has worked a treat. Thank You Very Much!! Now one final improvement if possible. The database i am building has alot of tables holding information from different districts. Is there anyway to select the table I want to select the fields from? I think I...

Thanks Jon. That would work fine (here it comes) but... I need to put the data into a report (which will be predesigned). So pulling up the results this way wouldnt work. However... I have been researching and an IIF statement should be able to carry out what I need to do. Something like...

I think I get you, any resources/examples you could point me to?? Thanks.

Now you've got me!! Was that a joke or a serious suggestion? Would a form of some sort help me?

How would i be able to put a grand total then? And is it actually possible to to sum the sums as it were? PS what is that article ID (I'm a pain but i learn). Edit - I figured out the article ID Long live google...

Hi, I need to sum the sums of groups (stay with me!). This is the rough report layout: DETAIL SECTION in red GROUP FOOTER in blue Value 5 77 12 Sum (this sum works) 5 3 5 Sum (this sum works) Grand sum (Sum of the 2 sums in above example) Ive tried putting the grand sum in the page...