Search results for query: *

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...

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...

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...

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

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

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...

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

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.

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...

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

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...

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...

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...

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

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...

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...

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

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

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

You the man. My heartfelt thanks.