Search results

Intermittently I have this problem where access tells me that the action cannot be completed. Sometimes it works and sometime a sign comes up which does not permit cut and paste entries. We work on a network with Windows Server 2012 R2 and Office 365 It is in Access for Office were we are...

When I'm trying to debug my code My debugging keys don't work. When I try to use my break key (ctrll + Fn + b) i don't get a response. If my code stops at a break point I have set up and I try to progress one line Using (Fn + F9) or try to advance to the next break using (Fn + F5) no response...

I want to step through a Query file. I keep getting an error "Item not found in collection" The Query file DdFixPaymentFeeQry has 752 records on it. I had it going on a different version of the project and i wanted to make a few tweaks, now I don't know what I have changed Private Sub...

I have several fields in a table that are subject to the resulting recordId that displays the string shown on the drop down. They all work as they should except one and for the life of me I can't find the reason. I have checked the property sheet for all of them and all of the properties are...

I'm sure it has something to do with the address of the criteria. I have a form with a subform and and within that subform I perform the following Me.PaymentFeeFld = DLookup("PaymentFee", "DdSchedules", "[DdSchedId] = " & DdSchedId) MsgBox "The PaymentFee = " & Me.PaymentFeeFld & " The...

I have a file with about 5000 records I want to set up a new string field on each record. I want to use the records primary key, add 10000 to it and save it. Any help would be very appreciated

This may not be the forum for the above question. But I running the merge in word via access I simply don't know how to convert to UpperCase. e.g. I want the contents of BM70 to display in Upper Case

I have a large merge facility via word template precedents under the control of Access 365 . In certain documents I want the Clients name to be in Uppercase. The default is that it is in normal text. So for the odd document when I need the Client name in upper case how do I format the content of...

I keep on getting the above error. The rs.MoveNext is highlighted when the error occurs. I'm extracting a selection of related records from a much larger file onto DdTransTemp and then going through that DdTransTemp file and processing certain transactions that full into a From and To date...

I believe I should begetting a "Do While with out Loop" error???? I have two tables The first one, rs1 is the outer loop. The file contains schedules that are the parent record to the second table of transactions, rs2. The major keys on the schedules table is DdSchedId and MatterId (Which is a...

I have a form and it has about 8 tabs and each tab opens up a subform. I have one subform that wont show the 8 records it has. I have a "Add Record" button on the blank subform and when I press that before it opens the add record form all 8 transaction appear in the subform. What is wrong with...

I have a contact log in our system used to record all actions taken with our clients. I maintain all the relevant info and the action taken field is a string field (Long) and users want to be able to save pdf files in the action taken field - how can I do it ?

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

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

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

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

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