Search results

Did as Pat suggested and from there on it was real easy.

Thanks for that Newman and Dopeman. I think I understand what you mean. Unfortunately I'm not smart enough to really get it, i.e. I cannot get it to work. I've done the following: The optiongroup is called fraMyOptions and has 4 buttons: Option1, Option2 Option3 nd Option4. The main table has a...

Hi, On my form I have an option group with 4 radio buttons. Depending on the button selected certain fields become visible. This works all fine. Problem is though that I don't know how to store the selected value. At the moment, every time you open the form you have to select the same button...

Problem fixed! Thanks Pat! Great tip, I got it to work.

Hi all, I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I...

Rich and dcx693, I've finally got the qry going AND finding the correct records!! Thank you both so much for helping me see the light. I might even be able to create one all by myself now :p After this rush I feel ready to tackle the next problem(s) Thanks again Walter

it is a combobox and there are 2 clomns, 1 = CompanyID (autonumber) and 2 is Company (text) I've tried changing the bound column for 0 to 1 to 2 Same thing, no results If I remove the CompanyID from the row source I get an empty combobox so that cannot be right either (I've changed the bound...

OK, did that. I'm sorry for the length of this posting but it's not as bad as it looks as there are only minor changes in the code that I've explained. Simplified qry. Just the period as an expression without amy criteria for Company or Area. PARAMETERS...

No reason other than that in my desparation I've tried all sort of minor changes since nothing seems to work. Also, since I have a significant gap in my limited knowledge in this area nothing stops me from making the simplest mistakes. The SQL without the quotes don't work either si there must...

Thanks for yor reply. I now understand what the parameter bit is (I think). That's the good news. The bad news is that I'm still not getting a result. Here's what I've got after adding the parameter for ChooseCompany: PARAMETERS [forms]![frmFormsAndReports_Period]![txtdate1] Short...

I wish I understood what you meant. Apparently I've defined the other one (how though?) i haven't got a clue how I can fix this. Could you be a bit more specific please? Thanks.

Hi newman, Yes, thanks for this suggestion. This is so much better than printing all 3 views every time. It's a simple solution but great solution to my question.

Re: can't work I suppose you want to make the button invisible when there is a date in your txtdischarge field and to have the button visible when the field is empty? This is a code that'll do the trick: If IsNull(txtdischarge) Then Me.cmdArchive.Visible = True Else Me.cmdArchive.Visible =...

'on current' of your form Open form in design view open properties open code of 'on current put your code there save and that's it!! Good luck Walter

Hi All, I'm working on a crosstable qry that should compare records of various companies in a variable (but defined) period The form has 2 text fields to define the period (txtdate1 and textdate2). That works fine. I can also combine the period criteria with a company criteria by manually...

Again? Are you trying to get ahead of Rich (# postings) by posting same code twice?;)

And another one, almost equally fast! and that one works just as well (i.e. don't notice a difference) Are you guys competing:p Is there an advantage of one over the other? Thanks again.

I don't think I've ever received a swifter response and, more importantly, the answer is 100% correct too! Thanks Rich

Hi, I have a form with a button that I'd like to be visible or not depending on the text in a field on that form. I only want the button to be visible when the field txtwhere on the form reads EP. This doesn't work: If me.txtwhere.txt = ep then me.btnShow.visible = true else...

Ok, That's too bad. I think I might leave it in that case. I've spend the best of 2 days to try and get that to work from a form but i get printouts of several hindred pages, one for each record. After I've created a report it got much better, just the one report that I want prints, albeit on 3...