Search results for query: *

Great thanks, good advice.

Here goes, sorry it's bit complex SELECT [LastName] & ", " & [FirstName] AS FullName, qryContacts.Deceased, qryContacts.Archived, qryContacts.Subscriber, qryContacts.Complimentary, qryContacts.Cancelled, qryContacts.LastRenewedDate, qryContacts.RenewalMonth...

Have an annual subscription database with various dates Join Date - when a subscription is started; defines the RenewalMonth for later years :- LastPaidDate - from which a MonthPaid is derived using DatePart. A query then calculates LastRenewedDate - if the payment is late, the month...

Hi Again I have now circumvented the problem since this trail looks to have gone cold - thanks so much for your interest. I'm now setting a flag on the main form when a first payment is made after the current set date. The code running the batch update is on a new form that shows just the...

Sorry guys for not making it clear, here's more detail. Main form : frmSubsAndDonations This is based on qryConatcts and has fields for - ContactID - DDAgreementDate (DD being Direct Debit) Subform : sfmSubscriptions This is based on qryInpayments and has fields for - ContactID -...

Answering PHV's question : Before the SQL, some clarification just in case. The form name is frmSubsAndDonations. The query looks at the data source for the payments subform using these criteria and taking the Top record, ie first after the Agreement Date. Dates ...

Have main form storing contact details, with subform storing payments. I'm coding the payments as they are added but want also to do the same to several records as a batch. In more detail :- Payments have to be flagged as 01 if the first after a set date, then 17 thereafter. I'm using an...

Thanks again Remou The SQL I sent was the view of the query that selects data. It allows each of the criteria for SupplierTPG etc to be -1, 0 or neither so all possible combinations of the criteria are catered for. I tried your suggestion but got the 'error in SQL' message; then tried various...

Thanks Remou I think I'm already doing this as below (the example in my original post was simplified). SELECT qryContacts.FirstName, qryContacts.LastName, qryContacts.FullName, qryContacts.Title, qryContacts.FullAddress, qryContacts.Email, qryContacts.Choose, qryContacts.SupplierTPG...

I can successfully use a fixed query to feed a function like this for a mail merge MergeAllWord ("Select * FROM qryContactsSelected") If the query takes data from unbound fields in a selector form, eg setting the criterion for a field called category to say...

Thanks sxschech It works a treat to use Val in the union query then format the total as currency. So SQL becomes SELECT Area, Explorer,Companion,Date,Description,Val(HolidayAmount) As HAmount,Val(ClubAmount) As CAmount FROM qryClubExpenses UNION SELECT Area...

I'm reporting a series of amounts using a union query like this SELECT Area, Explorer,Companion,Date,Description,Format(HolidayAmount,'Currency') As HAmount,Format(ClubAmount,'Currency') as CAmount FROM qryClubExpenses UNION SELECT Area...

Hi Guys Tried both thanks and like the abbreviated version. Both still give the annoying green indicator in top left of Excel cells though.

Using Access 2003, have procedure to export current form's data to Excel 2003. Works fine except Excel flags cells that are formatted as text in Access but look like numbers to Excel. Whilst they are numeric in Access they may start with 0, hence need to be text. Ideas - it's an irritation...

Adding to MajP's advice I find it easiest to open the main form in design view then drag the subform into it from the form list. Then just click on the edge of the subform, not the black square, then Properties. Then in the All tab, click in Link Child Fields and open up using the ... at the...

Thanks Ace, top stuff as ever.

Thanks PHV, that worked fine Added a new Web variable then set Web=Hyperlinkpart(WebAddress,1) This did the job of extracting just www.whatever.co.uk

Hi When sending a URL on a form to a bookmark on a Word document it comes out like this www.whatever.co.uk#http://www.whatever.co.uk# How can the #http://www.whatever.co.uk# be prevented?

Chaps Very grateful for quick response but finding myself short on knowledge to try what you suggest. Are there any examples you can point to, or maybe a bit more of a leg up?

Have a form where individual fields can be locked by setting their tag values to "?", or unlocked by setting to "" (thanks for the procedure AceMan, it's been so useful). Users may want to change which fields they want to lock so I'd like to make it easy to tag or untag fields without having...