Search results

  1. A

    Why Isn't My Copy and Paste Working?

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

    Debugging Problems

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

    Cannot get a step through a set of query records working

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

    Cannot get a step through a set of query records working

    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"
  5. A

    Cannot get a step through a set of query records working

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

    Cannot get a step through a set of query records working

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

    Form Field will not display the string result of a drop down

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

    Query not working

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

    Using the primary key as the seed + 10000 to be a string number for another field in each record of a table

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

    How to change the Case of the contents of a bookmark in word

    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 \*...
  11. A

    How to change the Case of the contents of a bookmark in word

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

    How to change the Case of the contents of a bookmark in word

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

    Hop do I format the contents of a bookmark in certain documents with access

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

    Run Time error 91 Object Variable or With Block variable not set

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

    Nested Do While loops - keep getting "Loop without Do" error

    Thanks guys it now works well
  16. A

    Nested Do While loops - keep getting "Loop without Do" error

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

    Records will not appear in subform

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

    saving a pdf file into a string field on an access form

    Thanks everyone for your input. I have used Crystal's solution before and I will use it again, it does the job and looks like the only method to use.
  19. A

    saving a pdf file into a string field on an access form

    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 ?
  20. A

    I want to insert a small graphic image into a a book mark query I prepare in access

    Thank you everyone for your input, much appreciated. I have used strive4peace's idea. It does exactly what I need
Top Bottom