Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brendoaccess

    Autodialler

    Hi I would like to be able to dial a number from within a form - I have broadband and so no physical modem and so autodialler doesn''t work. I have a voip app that can dial and connect numbers - is there any way to link the two? Suppose I could copy and paste the numbers in the DB into the...
  2. brendoaccess

    Look up fix

    Hi I have a look up table "tblContractors" with ContractorsID (autonumber) and ContractorName as short text - as several other post herein note, I get the ContractorsID number in forms when I want the ContractorName due to limitations of the lookup approach - I see fixes aplenty for combo boxes...
  3. brendoaccess

    Find multiple record query

    OK - got that - great, thanks a lot, lespaul. I know now how many donations have been made, and the date of the last donation. I can even tweak it for 'average donation' etc, which is incredibly helpful - thanks again. Back to my original question - for a list of donors, how can I get the Date...
  4. brendoaccess

    Find multiple record query

    Yes, but all I got was a mess. I'll have another go - sorry for the trouble.
  5. brendoaccess

    Find multiple record query

    Not there; TblDonors has fields; DonorID, FirstName, Surname TblDonations has fields; DonationsID, DonorID, DonationAmt, DonationDate The query I want would need the 2 tables to identify the Donor making the donations. I hope this is clearer. Thanks
  6. brendoaccess

    Find multiple record query

    Hi I have two tables that record a one (Donor) to many (Donations) relationship. Most of the Donors in tblDonor make regular donations - each donation has a date, in tblDonations. Having recently undertaken a mailshot I have received many donations from Donors that had been inactive for several...
  7. brendoaccess

    Choose all options in a Combo Box

    Bang on the money, dhookom - many thanks (sorry for delay - Christmas dinner at work) And thanks to you too, Remou.
  8. brendoaccess

    Choose all options in a Combo Box

    No good - returns no records, same as if left blank on the input form. I thought of this; IIf([Forms]![frmRunPremisesqry]![cboPremisesType] Is Null,"*",[Forms]![frmRunPremisesqry]![cboPremisesType]) but that's no good either.
  9. brendoaccess

    Choose all options in a Combo Box

    Hi I have a form that allows the user to make choices of 3 collectors, Kim, George and David via a Combo Box, cboCollector, that feeds into a query and thence a report. But if they don't know the parameter they want, or havent a preference and want to see a report that includes all the...
  10. brendoaccess

    In any given Month

    Brilliant - very helpful from both of you. Many thanks.
  11. brendoaccess

    In any given Month

    Hi. I have a 2 field table with Donation_Amount and Donation_Date. There are thousands of records covering over 15 years. I want to be able to tell which the frequency of donations by month - regardless of the year - and can't think how. What I want is something like >December and <February...
  12. brendoaccess

    Refer to a field on a Subform -sorry!

    Thanks for replying, The AceMan1 - carried on looking on the net last night and found this post; http://www.access-programmers.co.uk/forums/showthread.php?t=63597 which indicated a corrupt subform. Everything now sorted after replacing subform and compact/repair. (fingers crossed). Thanks...
  13. brendoaccess

    Refer to a field on a Subform -sorry!

    I have a form frmPerson, with FirstName and Surname fields, with tabs. On a tab called Home Details I have a sub form, "frmHomeDetails" with fields Address1, Address2, etc. I have an on click bit of code to send field contents to book marks in Word - which works, until it comes to referencing...
  14. brendoaccess

    Visibility Conditional on CBX value

    It is a single form, and On Current works just just Dandy. Many thanks MajP, and to you Aceman1 as well.
  15. brendoaccess

    Visibility Conditional on CBX value

    Hi, Aceman There are 3 values in the combo to choose - "Bulletin", "Member" and "Bulletin and Member". I only have 2 records in the db and one is "Member" and one is "Bulletin". If I change both records to member, the button and labels come back on re-opening the form. If I change the first...
  16. brendoaccess

    Visibility Conditional on CBX value

    Hello - I thought this was simple - the following code is supposed to hide a button (MemberReport) and its label, if the value in a combo box (Combo81) equals "Bulletin". Unfortunately, it hides them whatever the value of Combo81 is! Private Sub Form_Load() If Me![Combo81] = "Bulletin" Then...
  17. brendoaccess

    Chinese conundrum

    Good to hear from you again TheAceMan1. I'll check out the link. Many thanks
  18. brendoaccess

    Chinese conundrum

    That's useful - something to take away! (sorry)
  19. brendoaccess

    Chinese conundrum

    I administer a DB with several users over a network. Every now and again I get a record that has some fields filled in with Chinese (I think!) characters - like this: ????? Any ideas how this happens, and how I can stop it? Many thanks
  20. brendoaccess

    Chart Limitations

    You the man. My heartfelt thanks.

Part and Inventory Search

Back
Top