Recent content by atrium

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

Gasman, I had taken a copy of the whole project to do my testing. Yes it was the field names in the recordset Thank you everyone

I really want to know what is wrong with the code. I can't get it to populate the first record yet. I doesn't get past the first Me.DdSchedIdFld = rsQuery![DdSchedId] when it comes up with the error "Item not found in collection"

Reply to Arnelgp The error is generated when I execute line Me.DdSchedIdFld = rsQuery![DdSchedId] and if I put my cursor on any of the fields in the collection they show the error Reply to The Doc_man As soon as it hits the above line (first interrogation of the any of the fields in the...

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

Sorry I should have explained my self in a much clearer way. I have a number of documents using BookMarks to insert text from a query. Some of the BookMarks when used in some documents they need to appear in UpperCase but in other documents that are required to be in LowerCase If I use [BM70 \*...

I have tried that and it works for 80% of the times I use it. It's the other 20% that I need to convert Uppercase to lowercase and then Caps. Or I could leave everything in lowercase and convert the BookMark to UpperCase when I need to

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

Thanks guys it now works well