Search results

This is the code I have created to move the image in to the bookmark position. If oWordDoc.Bookmarks.Exists("BM157") = True Then Set Rng = oWordDoc.Bookmarks("BM157").Range Rng.Collapse If strBookmarkValue = -1 Then...

I have a series of Yes/No fields in a table and I need to insert a tick box image either on or off and merged into a word document performed in access. This is what I started with but soon realised it want work - any ideas on how I can do it PLEASE...

ARNELP you are a marvel. That was the problem Thanks very much

when I view the source query SELECT Clients.ClientId, Clients.ClientGroup, Clients.ClientFileNumber, RTrim([Clients]![FirstName] & " " & [Clients]![LastName]) AS ClientName, Clients.LastName, DdSchedules.Status, Matters.Description, Matters.DebtPrinciple...

I can't get this to work If (DLookup("DdSchedId", "DdSchedules", "[MatterId] = " & Me.MatterIdFld) = True And ([Status] = "Not Active")) Then Can anyone help please

Thanks June 7. No. 2 is fine now No.1 - How do I format (I Know a dumb question) outside of the normal drop down options on the control field

1. I have a report with columns of Currency figures I have 2 that I wont to show 0.00 if they are zero of Null. These fields are calculated (Sum) fields in the feeding query When I run the report The TotInterest and the Totpayments don't have a zero ($0.00) in their cell. 2. To calculate...

I haven't got it working I have now used SELECT t.MatterId, t.TransCode, Sum(t.AmountTotal*[Transaction Types].[ValueType]) AS TotPayments FROM [Transaction Types] RIGHT JOIN Transactions AS t ON [Transaction Types].TransCode = t.TransCode WHERE (((t.TransCode) In (101,104,109,199,914,915)))...

Thank you everyone, what a great help

I have three tables Transactions, Transaction Types, The transactions file records relate to Many different financial transaction types. The most common thread is that they all relate to different MatterId's (one matterId to many transactions). I need to sum 6 different payment transaction...

Particulars is the description of the transaction. Yes I will make it mandatory Thank you

Update Transactions Set TransCode = 1 WHERE (Nz(TransCode, 0) = 0) And (([Particulars]) LIke 'DD Debtor Payment by*') Update 0 rows only - didn't work

I used that arnelgp but it only changed 57 records and there's 1000's of them

I have a table with payment transactions I need to go through it and change any transaction that has a (what appears to be ) Blank transaction code to 1 The table field TransCode is a number data type it is also a lookup field to another table called TransactionTypes The lookup for...

I have a small log in form. I don't want the user doing a right click on the form's top banner and closing the form or opening it in any other view. How can I do this in vba. I don't want all forms disabled (Using the settings) Any help would be appreciated

Thank you Gassman and pbaldy Yes it was the Control name. What's really annoying is that I know these things but I have trouble recalling them. Old Age I suppose Thanks again guys

The delete query that I have written, when executed telss me it can't find the parameter. The variable is on a subform of the Parent form The sql for the query is DELETE SkipTraces.SkipTraceId, * FROM SkipTraces WHERE...

Thanks June7 They worked as required The options are SchedId, trans code 13 (Direct Debit Payment) , Transcode 20 (Manual Payment), Transcode 50 (a Credit to their payments) . The status of the transaction could be Paid, submitted or Not Paid. May I ask - What does AWF means and where is...

My statement is Me.LastPaymentDateFld = DMax("DueDate", "DdSchedDDTrans", "DdSchedId = " & Me.DdSchedIdFld) & " AND ([TransCode] = 13 " & " Or [TransCode]=50 " & " Or [TransCode] = 20) " & " AND ([Status] = 'Paid' OR [Status] = 'Submitted')),0) Me.NextPaymentDateFld = DMin("DueDate"...

That fixed it - thanks