Search results for query: *

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

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

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

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

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

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?

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